Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Irep Parser

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
+---------------------------------------------------------------------------+