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

MOSC Banner

R12.1.3 : Invalid objects in AR

edited Dec 25, 2013 9:25PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓
Hi,
Invalid objects in AR
AR_CREDIT_USAGE_RULE_SETS_VL and AR_CREDIT_CHECK

1)select text from user_source where name='AR_CREDIT_CHECK' and line=2

TEXT
-- $Header: ARXCRCS.pls 110.4 2000/03/28 23:42:02 pkm ship        $
-- $Header: ARXCRCB.pls 110.10 2000/03/28 23:41:58 pkm ship        $

2)alter package AR_CREDIT_CHECK compile

3) select line,text from user_errors where name='AR_CREDIT_CHECK'


LINE    TEXT

1    PLS-00905: object APPS.AR_CREDIT_CHECK is invalid
1    PLS-00304: cannot compile body of 'AR_CREDIT_CHECK' without its specification
0    PL/SQL: Compilation unit analysis terminated
49 PLS-00201: identifier 'RA_CUSTOMERS.CUSTOMER_NUMBER' must be declared
42 PL/SQL: Declaration ignored
63 PLS-00201: identifier 'RA_CUSTOMERS.CUSTOMER_NUMBER' must be declared
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