New OFSA Allocation ID Causes ORA-00942 Error

(Doc ID 340485.1)

Last updated on MAY 06, 2010

Applies to:

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

Checked for relevance on 06-May-2010.

Symptoms

When running newly created Allocation IDs against the LEDGER_STAT table, an Internal Error is received on the Server Status screen. The results of the Allocation ID are correctly written to the LEDGER_STAT table, however, in the IDENTITY_CODE column, rather than the Identity Code of the Allocation ID, a 0 is written.

The OFSA_DATA_IDENTITY also has a record with 0 for IDENTITY_CODE, however this only reflects the last Allocation ID that was run.

The ofsapa.xxxx log file shows the following error:

ERROR
OCI Function: [4] - oexec(), oexn()
SQL Function: [0] - SQL function not found!
Oracle Error: ORA-00942: table or view does not exist

Driver Function: drv_oci::Execute()

SQL Statement: SELECT ofsa_identity_SEQ.NEXTVAL FROM DUAL
done.

Previously existing Allocation ID (which already have an Identity Code on the Ledger Stat table) are functioning without error, however, if they do a Save As, the new Allocation ID is displaying the same behavior.

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