Getting Internal Error and ORA-04068 Running Allocation (Doc ID 146437.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle Profitability Manager - Version 4.5 to 4.5.39 [Release 4.5]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Oracle Performance Analyzer - Version: 4.5 to 4.5.39

Symptoms

In Oracle Performance Analyzer (PA) 4.5, when running an Allocation ID, you get an Internal Error in the Server Status Update screen.  This screen also contains the message "9000 Error Running ID!".

The following error exists in the ofspa.xxxx file:

OCI Function: [4] - oexec(), oexn()
SQL Function: [34] - PL/SQL EXECUTE
Oracle Error: ORA-04068: existing state of packages has been discarded

ORA-04063: package body "<dbname>.OFSA_DBA" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "<dbname>.OFSA_SQL", line 60
ORA-06512: at line 1

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