AR_BUS_EVENT_SUB_PVT Package body invalid state after applying the patch14736094
Hi,
Apps 12.1.3
AR_BUS_EVENT_SUB_PVT Package body invalid state after applying the patch14736094
Error message:
AR_BUS_EVENT_SUB_PVT
PLS-00323: subprogram or cursor 'REFRESH_AT_RISK_VALUE' is declared in a package specification and must be defined in the package body
Looks the package body and spec are not in synch.
I can see that there is a later version of ARBESUBS.pls
I assume this is a test/clone instance. If so, please try compiling the spec and body manually and see what errors are returned:
cd $AR_TOP/patch/115/sql
Log in to SQLPLUS as the APPS user / password
Apps 12.1.3
AR_BUS_EVENT_SUB_PVT Package body invalid state after applying the patch14736094
Error message:
AR_BUS_EVENT_SUB_PVT
PLS-00323: subprogram or cursor 'REFRESH_AT_RISK_VALUE' is declared in a package specification and must be defined in the package body
Looks the package body and spec are not in synch.
I can see that there is a later version of ARBESUBS.pls
I assume this is a test/clone instance. If so, please try compiling the spec and body manually and see what errors are returned:
cd $AR_TOP/patch/115/sql
Log in to SQLPLUS as the APPS user / password
Tagged:
0