Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Sev1: Auto invoice stopped working after applying SEPA patches due to Invalid objects

edited Aug 22, 2013 2:06PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered
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;
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center