My Oracle Support Banner

iStore ldt file gives error "FAILED: File Ibebilkpup.ldt" On Worker 4 during upgrade to 12.2.8 (Doc ID 2483388.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle iStore - Version 12.2.6 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version,

Patching for upgrade to 12.2.8 gives failures for file ibebilkpup.ldt on worker 4.



ERROR
-----------------------
Uploading from the data file /u11/oracle/EBSDEV/fs1/EBSapps/appl/ibe/12.0.0/patch/115/import/US/ibebilkpup.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/u11/oracle/EBSDEV/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/aflvmlu.lct(120.1.12020000.2), /u11/oracle/EBSDEV/fs1/EBSapps/appl/ibe/12.0.0/patch/115/import/US/ibebilkpup.ldt) to staging tables
Dumping LCT file /u11/oracle/EBSDEV/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/aflvmlu.lct(120.1.12020000.2) into FND_SEED_STAGE_CONFIG
Dumping LDT file /u11/oracle/EBSDEV/fs1/EBSapps/appl/ibe/12.0.0/patch/115/import/US/ibebilkpup.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (FND_LOOKUP_TYPE FND IBE_ADDTOCART_NAVIGATION , FND_LOOKUP_VALUE L ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Error loading seed data for FND_LOOKUP_VALUE: VIEW_APPSNAME = FND, LOOKUP_TYPE = IBE_ADDTOCART_NAVIGATION, LOOKUP_CODE = SC, ORA-24344: success with compilation error
ORA-01403: no data found
  Error loading seed data for FND_LOOKUP_VALUE: VIEW_APPSNAME = FND, LOOKUP_TYPE = IBE_ADD_REL_RULE_LOOKUPS, LOOKUP_CODE = PN, ORA-24344: success with compilation error
ORA-01403: no data found
  Error loading seed data for FND_LOOKUP_VALUE: VIEW_APPSNAME = FND, LOOKUP_TYPE = IBE_BIN_FREQUENCY, LOOKUP_CODE = DAY, ORA-24344: success with compilation error
ORA-01403: no data found
  Error loading seed data for FND_LOOKUP_VALUE: VIEW_APPSNAME = FND, LOOKUP_TYPE = IBE_BIN_NAME, LOOKUP_CODE = SUMMARY, ORA-24344: success with compilation error
ORA-01403: no data found
  Error loading seed data for FND_LOOKUP_VALUE: VIEW_APPSNAME = FND, LOOKUP_TYPE = IBE_BIN_NUM_DAY, LOOKUP_CODE = 1, ORA-24344: success with compilation error
ORA-01403: no data found
  Error loading seed data for FND_LOOKUP_VALUE: VIEW_APPSNAME = FND, LOOKUP_TYPE = IBE_BIN_NU

Note many other modules in addition to iStore (IBE) were failing with same errors and manual load failed also -

        ORA-01403: no data found
        Error loading seed data for FND_LOOKUP_VALUE: VIEW_APPSNAME = FND, LOOKUP_TYPE = <lookup name>, LOOKUP_CODE = <code>, ORA-24344: success with compilation error

Changes

 Upgrade to 12.2.8

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.