ORA-00936, ORA-01418, ORA-06512 and Internal Error Running Allocation Id in OFSA PA 4.5 (Doc ID 352394.1)

Last updated on NOVEMBER 07, 2012

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) - Version: 4.5
Oracle Performance Analyzer (PA)- Version: 4.5 to 4.5.39

Checked for relevance on 07-Nov-2012.

Symptoms

The following error messages are received when running Ledger Stat Allocations in Oracle Performance Analyzer (PA) 4.5  when processing on either the client and server:

ERRORS

Internal error (in the Server Status Screen)

From the ofspa.#### and ofspa.####.log debug logs:

Oracle Error:   ORA-01418: specified index does not exist
ORA-06512: at "TSER.OFSA_DBA", line 1293  
ORA-06512: at "TSER.OFSA_DBA", line 2185
ORA-06512: at "TSER.OFSA_SQL", line 404
ORA-06512: at line 1
    
Driver Function:   drv_oci::Execute()
    
SQL Statement:   declare begin ofsa_sql.drop_index('OFSADEMO','ALLOC_126042_ac13','NO'); end;
done.

OCI Function:   [4] - oexec(), oexn()
SQL Function:   [34] - PL/SQL EXECUTE
Oracle Error:   ORA-00936: missing expression
ORA-06512: at "TSER.OFSA_DBA", line 1293
ORA-06512: at "TSER.OFSA_DBA", line 2034
ORA-06512: at "TSER.OFSA_SQL", line 327
ORA-06512: at line 1
   
Driver Function:   drv_oci::Execute()
   
SQL Statement:   declare begin ofsa_sql.create_index  ('OFSADEMO','ALLOC_126042_ac13 on
ALLOC_126042_ac13()','NO',NULL); end;

Changes

Changes made to the unique index for the LEDGER_STAT table.

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