My Oracle Support Banner

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

Last updated on MAY 24, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.