Sev1: Auto invoice stopped working after applying SEPA patches due to Invalid objects
Hi,
Apps 11.5.10.2
Customer has applied SEPA patches and auto invoice stopped working
AS per our investigation, the following two packages are became invalid.
AR_DEPOSIT_API_PUB PACKAGE BODY APPS
AR_PURGE PACKAGE BODY APPS
When our DBA's trying to validate the package , getting the following errors
==========================
SQL> alter package AR_PURGE compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY AR_PURGE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4/15 PLS-00323: subprogram or cursor 'DRIVE_BY_INVOICE' is declared
in a package specification and must be defined in the package
body
SQL> alter package AR_DEPOSIT_API_PUB compile body;
Apps 11.5.10.2
Customer has applied SEPA patches and auto invoice stopped working
AS per our investigation, the following two packages are became invalid.
AR_DEPOSIT_API_PUB PACKAGE BODY APPS
AR_PURGE PACKAGE BODY APPS
When our DBA's trying to validate the package , getting the following errors
==========================
SQL> alter package AR_PURGE compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY AR_PURGE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4/15 PLS-00323: subprogram or cursor 'DRIVE_BY_INVOICE' is declared
in a package specification and must be defined in the package
body
SQL> alter package AR_DEPOSIT_API_PUB compile body;
Tagged:
0