EBS 12.1.3 Upgrade Fails at ap12alu.ldt With ORA-01403: No Data Found (Doc ID 1595582.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms



During the upgrade to REL 12.1.3 , adpatch stopped at:

ATTENTION: All workers either have failed or are waiting:

  FAILED: file ap12alu.ldt on worker 1.

The log shows:

Uploading from the data file /lv01/apps/oracle/apps/omarcsug/appl_mgr/ap/12.0.0/patch/115/import/US/ap12alu.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/lv01/apps/oracle/apps/omarcsug/appl_mgr/fnd/12.0.0/patch/115/import/aflvmlu.lct(120.0.12010000.1), /lv01/apps/oracle/apps/omarcsug/appl_mgr/ap/12.0.0/patch/115/import/US/ap12alu.ldt) to staging tables
Dumping LCT file /lv01/apps/oracle/apps/omarcsug/appl_mgr/fnd/12.0.0/patch/115/import/aflvmlu.lct(120.0.12010000.1) into FND_SEED_STAGE_CONFIG
Dumping LDT file /lv01/apps/oracle/apps/omarcsug/appl_mgr/ap/12.0.0/patch/115/import/US/ap12alu.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (FND_LOOKUP_TYPE SQLAP 1099 PAYMENT REPORT OPTION , FND_LOOKUP_VALUE NOT_SMALL ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
 Error loading seed data for FND_LOOKUP_TYPE:  VIEW_APPSNAME = SQLAP, LOOKUP_TYPE = PAYMENT TYPE,  ORA-01403: no data found





Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms