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

MOSC Banner

R12.1.3 : after applying patch 18154451, got PO_ASL_API_GRP and PO_ASL_API_PUB invalid

edited Mar 24, 2014 12:20PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered

hello,

after applying patch 18154451, PO_ASL_API_GRP and PO_ASL_API_PUB become invalid:

I tried to compile packages manually, getting the following errors:

SQL> alter package PO_ASL_API_PUB compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors;

Errors for PACKAGE BODY PO_ASL_API_PUB:

LINE/COL ERROR

-------- -----------------------------------------------------------------

1649/3   PL/SQL: SQL Statement ignored

1651/39  PL/SQL: ORA-00907: missing right parenthesis

1658/3   PL/SQL: SQL Statement ignored

1660/39  PL/SQL: ORA-00907: missing right parenthesis

SQL> alter package PO_ASL_API_GRP compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors;

Errors for PACKAGE BODY PO_ASL_API_GRP:

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