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 APRIL 04, 2025
Applies to:
Oracle Inventory Management - Version 12.2.4 and laterInformation in this document applies to any platform.
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
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 |