Allocation with Table ID Fails with 'ORA-01452: Cannot CREATE UNIQUE INDEX; Duplicate Keys Found' on Temp Table Index (Doc ID 1504773.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

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

Symptoms

In Oracle Performance Analyzer (PA) 4.5.38, you are trying to run an Allocation on an instrument table that uses a Table ID to perform a calculation.  When you run the Allocation, you get the following errors after processing for several minutes:

(203105) Oracle drv_oci error:

OCI Function: [4] - oexec(), oexn()
SQL Function: [34] - PL/SQL EXECUTE
Oracle Error: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
ORA-06512: at "<dbowner>.OFSA_DBA", line 1293
ORA-06512: at "<dbowner>M.OFSA_DBA", line 2034
ORA-06512: at "<dbowner>.OFSA_SQL", line 327
ORA-06512: at line 1

Driver Function: drv_oci::Execute()

SQL Statement: declare begin ofsa_sql.create_index('USER','CTI7DC96AB791402F10 on
CTI7DC96AB791402F10(COMMON_COA_ID), 'NO', 'UNIQUE');end;


(203105) Oracle drv_oci error:

OCI Function: [4] - oexec(), oexn()
SQL Function: [34] - PL/SQL EXECUTE
Oracle Error: ORA-00942: table or view does not exist
ORA-06512: at "<dbowner>.OFSA_DBA", line 1293
ORA-06512: at "<dbowner>.OFSA_DBA", line 1928
ORA-06512: at "<dbowner>.OFSA_SQL", line 304
ORA-06512: at line 1

Driver Function: drv_oci::Execute()


1059  Failed to create compiled Table ID for bulk.


The errors prevent the Allocation from generating the calculation results.

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