During upgrade to R12, File Asodepmp.ldt On Worker fails with ORA-04063: package body "<schema name>.ASO_UTILITY_PVT" has errors (Doc ID 1573038.1)

Last updated on AUGUST 03, 2016

Applies to:

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

Symptoms

Worker fails during upgrade to R12.

Excerpt of the log information shows the following:


Loading data using FNDLOAD function.
FNDLOAD <Custom schema name>/***** 0 Y UPLOAD @ASO:patch/115/import/asodepmp.lct @ASO:patch/115/import/US/asodepmp.ldt -

Connecting to APPS_FND2......Connected successfully.

Calling FNDLOAD function.

Returned from FNDLOAD function.

Log file: <.........>/US_asodepmp_ldt.log
Error calling FNDLOAD function.

.
.
.

Dumping LDT file <....>asodepmp.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (ASO_DEPENDENCY_MAPPINGS 10000 , ASO_DEPENDENCY_MAPPINGS 10108 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
 Error loading seed data for ASO_DEPENDENCY_MAPPINGS:  DEPENDENCY_ID = 10000,  ORA-04063: package body " <Custom schema name>.ASO_UTILITY_PVT" has errors
 Error loading seed data for ASO_DEPENDENCY_MAPPINGS:  DEPENDENCY_ID = 10001,  ORA-04063: package body " <Custom schema name>.ASO_UTILITY_PVT" has errors


Changes

 Using custom schema name rather than APPS

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