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 AUGUST 01, 2016

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.
*** Checked for relevance 10-Sep-2014 ***

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms