12.1.3 : After Applying Patch#14081004 one invalid object increases
Hi,
After Applying Patch#14081004 one invalid object increases
while applying 1st pre- requesite patch of PSA the invalid object increases , PACKAGE BODY "PA_INV_ON_ACCOUNT_CM" get invalid.
Package error and versin are :
select text from user_source where name='<PACKAGE NAME>' and line=2
output:
/* $Header: PAIOACMS.pls 120.0.12010000.1 2011/08/31 09:37:06 rdegala noship $ */
/* $Header: PAIOACMB.pls 120.0.12010000.1 2011/08/31 12:05:41 rdegala noship $ */
2)select line,text from user_errors where name='<PACKAGE NAME>'
LINE TEXT
85 PLS-00302: component 'GET_TRXN_LINE_BALANCE' must be declared
85 PL/SQL: Statement ignored
129 PLS-00302: component 'GET_TRXN_LINE_BALANCE' must be declared
129 PL/SQL: Statement ignored
3)select a.line,a.text
After Applying Patch#14081004 one invalid object increases
while applying 1st pre- requesite patch of PSA the invalid object increases , PACKAGE BODY "PA_INV_ON_ACCOUNT_CM" get invalid.
Package error and versin are :
select text from user_source where name='<PACKAGE NAME>' and line=2
output:
/* $Header: PAIOACMS.pls 120.0.12010000.1 2011/08/31 09:37:06 rdegala noship $ */
/* $Header: PAIOACMB.pls 120.0.12010000.1 2011/08/31 12:05:41 rdegala noship $ */
2)select line,text from user_errors where name='<PACKAGE NAME>'
LINE TEXT
85 PLS-00302: component 'GET_TRXN_LINE_BALANCE' must be declared
85 PL/SQL: Statement ignored
129 PLS-00302: component 'GET_TRXN_LINE_BALANCE' must be declared
129 PL/SQL: Statement ignored
3)select a.line,a.text
Tagged:
0