R12 After Patch 13260124:R12.PJC.B PA_BUDGET_CHECK_PVT / PA_BUDGET_CORE Objects Are In INVALID (Doc ID 1455366.1)

Last updated on NOVEMBER 17, 2022

Applies to:

Symptoms

After applying <Patch 13260124> and <Patch 12996408> the following objects are invalid and will not compile:


APPS PACKAGE BODY PA_BUDGET_CHECK_PVT
APPS PACKAGE BODY PA_BUDGET_CORE

Manually compiling these encounters errors:

Errors for PACKAGE BODY PA_BUDGET_CHECK_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
478/8 PL/SQL: Statement ignored
478/65 PLS-00302: component 'GET_PROJECT_END_DATE' must be declared
SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE,STATUS from dba_objects where OBJECT_NAME like '%PA_BUDGET_CORE%';

and

Errors for PACKAGE BODY PA_BUDGET_CORE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
799/7 PL/SQL: SQL Statement ignored
799/45 PL/SQL: ORA-00904: "PA_TRX_IMPORT"."GET_PROJECT_END_DATE":
  invalid identifier

799/59 PLS-00302: component 'GET_PROJECT_END_DATE' must be declared

Another symptom would be the following error when uploading a  budget WEB ADI:

Error
The uploaded process has completed with errors.  Press Close to return to the document and fix the errors.

* No rows uploaded
* 0 rows were invalid
* An error has occurred while running an API import.
oracle.apps.bne.exception.BneTokenException: Hashtable token revolved was unable to retrieve the value within the Hashtable provided for key: x_success_msg

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.