PA OFSA Ledger Stat Allocations Failing With ORA-01418 And ORA-00957 Errors (Doc ID 268357.1)

Last updated on OCTOBER 30, 2012

Applies to:

Oracle Profitability Manager - Version 4.5.39 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 30-Oct-2012.

Symptoms

You are receiving the following errors running an Allocation ID:

ORA-06512: at "OKOFSA.OFSA_DBA", line 1293
Oracle Error: ORA-01418: specified index does not exist

Oracle Error: ORA-00957: duplicate column name
ORA-06512: at "OKOFSA.OFSA_DBA", line 1293
ORA-06512: at "OKOFSA.OFSA_DBA", line 2034
ORA-06512: at "OKOFSA.OFSA_SQL", line 327
ORA-06512: at line 1
Driver Function: drv_oci::Execute()

SQL Statement: declare begin ofsa_sql.create_index('OKOFSA', 'ALLOC_107835_5894 on
ALLOC_107835_5894 (IDENTITY_CODE, IDENTITY_CODE, YEAR_S ,YEAR_S, ACCUM_TYPE_CD, ACCUM_TYPE_CD, CONSOLIDATION_CD, CONSOLIDATION_CD, FINANCIAL_ELEM_ID, FINANCIAL_ELEM_ID, ORG_UNIT_ID, ORG_UNIT_ID, GL_ACCOUNT_ID,  GL_ACCOUNT_ID, COMMON_COA_ID, COMMON_COA_ID, PRODUCT_COA_ID, PRODUCT_COA_ID, OFFICER_ID, OFFICER_ID)','NO',NULL); end;

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