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

MOSC Banner

Invalid Objects after applying CLM RUP3

edited Aug 20, 2013 4:42AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered

Hi,
There are several packages that became invalid afer CLM RUP3.


POR_AMENDMENT_PKG
"[Error] PLS-00201 (317: 29): PLS-00201: identifier 'G_ORG_ID' must be declared
[Error] ORA-00904 (317: 38): PL/SQL: ORA-00904: : invalid identifier
[Error] ORA-00904 (507: 35): PL/SQL: ORA-00904: ""G_ORG_ID"": invalid identifier"

POS_SUPP_APPR
"[Error] PLS-00323 (91: 10): PLS-00323: subprogram or cursor 'CHECK_CURRENT_APPROVER' is declared in a package specification and must be defined in the package body
[Error] PLS-00323 (95: 10): PLS-00323: subprogram or cursor 'GET_APPROVER_NAME_IN_WF' is declared in a package specification and must be defined in the package body"

POS_VENDOR_REG_PKG
[Error] PLS-00323 (72: 11): PLS-00323: subprogram or cursor 'VALIDATE_REQUIRED_USER_ATTRS' is declared in a package specification and must be defined in the package 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