Setup Project Status Report : Sqlexception: Ora-04068: Existing State Of Packages Has Been / java.sql.SQLException: ORA-00600: internal error code (Doc ID 1389370.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.
Checked for relevance on 28-MAR-2016

Symptoms

Setup Project Status Report gives error:

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure "APPS.PA_ACTION_SET_UTILS"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.PA_ACTION_SET_UTILS"
ORA-06512: at "APPS.PA_PROGRESS_REPORT_PUB", line 585ORA-06512: at line 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to: Project Super User > Search Project > Projects > Reporting > Go to : Set Up > Click On ‘Status Report’
2. Click on Setup
3. Setup project status report errors on save.

 

The following error can also be thrown in same Setup Project Status Reports:

Exception Details:
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (select report_name, report_type_id, override_page_layout
, page_name, page_id
, NVL(approval_required,'N') approval_required
, reporting_cycle_id, report_offset_days, next_reporting_date
, billing_cycle_id, billing_cycle_name
, object_id,object_type, page_type_code, record_version_number
, approval_description
, effective_from
, effective_to
, approver_source_id
, approver_source_type
, approver_name
, action_set_id
, object_page_layout_id
, DECODE(NVL(approval_required,'N'),'N','N','Y') checkbox_ar
, DECODE(NVL(approval_required,'N'),'A','Y','N') checkbox_ap
, generation_method
from pa_progress_report_setup_v) QRSLT  WHERE ((generation_method is null or generation_method ='MANUAL') and object_id = :1 and object_type = 'PA_PROJECTS' and page_type_code = 'PPR')

...

## Detail 0 ##
java.sql.SQLException: ORA-00600: internal error code, arguments:

 

 

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