Installing Patch 30399999 Got Error Loading Seed Data For AME_RULE_USAGES ORA-06508: PL/SQL: Could Not Find Program Unit Being Called (Doc ID 2815278.1)

Last updated on MARCH 31, 2022

Applies to:

Symptoms

On : 12.2 version, Patch Application Issues

Find that workers stop in error with the same errors during <Patch 30399999> - ORACLE E-BUSINESS SUITE 12.2.10 RELEASE UPDATE PACK  installations and the following error is seen:

Error:
Error loading seed data for AME_RULE_USAGES RULE_KEY = SEED-1990742606:10610, RULE_KEY = SEED-1990742606:10610, APPLICATION_SHORT_NAME = INV, TRANSACTION_TYPE_ID = INVCCAP, ORA-06508: PL/SQL: could not find program unit being called


Replication Steps:
The issue can be reproduced at will with the following steps:
1. Apply upgrade 30399999 12.2.10 RUP
2. Error occurs in the adworkers handling the ldt's and the patch will not continue.

Example Failure -

Dumping from LCT/LDT files (PATCH/fs2/EBSapps/appl/ame/12.0.0/patch/115/import/amesrulk.lct(120.3.12020000.2), /PATCH/fs2/EBSapps/appl/cn/12.0.0/patch/115/import/US/cnamerule.ldt) to staging tables
Dumping LCT file PATCH/fs2/EBSapps/appl/ame/12.0.0/patch/115/import/amesrulk.lct(120.3.12020000.2) into FND_SEED_STAGE_CONFIG
Dumping LDT file /PATCH/fs2/EBSapps/appl/cn/12.0.0/patch/115/import/US/cnamerule.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (AME_RULES SEED-1990742606:10585 , AME_RULE_USAGES SEED-1990742606:10586 CN CNAMEDISPUTE ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for AME_RULE_USAGES: RULE_KEY = SEED-1990742606:10585, RULE_KEY = SEED-1990742606:10585, APPLICATION_SHORT_NAME = CN, TRANSACTION_TYPE_ID = CNAMEDISPUTE, ORA-06508: PL/SQL: could not find program unit being called
Error loading seed data for AME_RULE_USAGES: RULE_KEY = SEED-1990742606:10586, RULE_KEY = SEED-1990742606:10586, APPLICATION_SHORT_NAME = CN, TRANSACTION_TYPE_ID = CNAMEDISPUTE, ORA-06508: PL/SQL: could not find program unit being called

Worker Code Context Filename Status
------ -------- ----------------- -------------------------- --------------
1 Done AutoPatch R120 cnamerule.ldt FAILED
2 Done AutoPatch R120 eamwramul.ldt FAILED
3 Done AutoPatch R120 invccarul.ldt FAILED
4 Done AutoPatch R120 poigtamerule.ldt FAILED

Changes

 12.2.10 patching is being implemented.

Cause

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