Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Irep Parser

Daniyal AhmedDec 8 2022

Successfully generated ILDT File for .pls file but failing when trying to load ildt file using FNDLOAD, below is error i'm facing
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDLOAD: Generic Loader
+---------------------------------------------------------------------------+

Current system time is 08-DEC-2022 16:33:24

+---------------------------------------------------------------------------+

Uploading from the data file MBCL_WORKREQ_PKG_pls.ildt
Altering database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (/Oracle/apps/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/wfirep.lct(120.8.12020000.3), MBCL_WORKREQ_PKG_pls.ildt) to stage tables
Dump LCT file /Oracle/apps/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/wfirep.lct(120.8.12020000.3) into FND_SEED_STAGE_CONFIG
Dump LDT file MBCL_WORKREQ_PKG_pls.ildt into FND_SEED_STAGE_ENTITY
Dumped the batch (IREP_OBJECT PLSQL:MBCL_WORKREQ_PKG C , PARAMS 0 0 ) into FND_SEED_STAGE_ENTITY
Upload from stage tables
Error loading seed data for IREP_METHOD: OBJECT_NAME = PLSQL:MBCL_WORKREQ_PKG, DEST_TABLE = C, FUNCTION_NAME = PLSQL:MBCL_WORKREQ_PKG:MBCL_GET_ON_HAND_QTY, OVERLOAD_SEQ = 1, ORA-28115: policy with check option violation
ORA-06512: at "APPS.FND_IREP_LOADER_PRIVATE", line 1453
ORA-01403: no data found

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 08-DEC-2022 16:33:25

+---------------------------------------------------------------------------+

Comments
Post Details
Added on Dec 8 2022
0 comments
472 views