R12: AP: Issue While Applying A Patch - Executing Grants On AP_PAYMENT_HIST_DISTS_S To APPS - An Error is Received: PLS-00302: Component 'APPS_DDL' Must Be Declared
(Doc ID 2932254.1)
Last updated on JUNE 14, 2023
Applies to:
Oracle Payables - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
Issue while applying EBS RUP(12.2.11) Patch 31856789.
The below error is found in one Adworker logs
Sequence AP.AP_PAYMENT_HIST_DISTS_S exists in database.
Sequence(s) in xdf-file & database match. No changes required.
Executing grants on AP_PAYMENT_HIST_DISTS_S to APPS
GRANT ALL ON AP.AP_PAYMENT_HIST_DISTS_S TO APPS WITH GRANT OPTION
Exception occured : ORA-06550: line 1, column 10:
PLS-00302: component 'APPS_DDL' must be declared
ORA-06512: at "APPS.AD_INST", line 191
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "APPS.AD_INST", line 180
ORA-06512: at line 1
Sequence(s) in xdf-file & database match. No changes required.
Executing grants on AP_PAYMENT_HIST_DISTS_S to APPS
GRANT ALL ON AP.AP_PAYMENT_HIST_DISTS_S TO APPS WITH GRANT OPTION
Exception occured : ORA-06550: line 1, column 10:
PLS-00302: component 'APPS_DDL' must be declared
ORA-06512: at "APPS.AD_INST", line 191
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "APPS.AD_INST", line 180
ORA-06512: at line 1
Steps:
- Apply EBS RUP(12.2.11) Patch 31856789.
Changes
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 |