New OFSA Allocation ID Causes ORA-00942 Error
Last updated on MAY 06, 2010
Applies to:Oracle Profitability Manager - Version: 4.5.38
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.
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:
OCI Function:  - oexec(), oexn()
SQL Function:  - 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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms