My Oracle Support Banner

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 JUNE 25, 2019

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
***Checked for relevance on 18-JUN-2019 ***

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

 

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


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