My Oracle Support Banner

In EFPA, FSI_LEDGER_STAT_TRM Fails With "ORA-00957: duplicate column name" Error (Doc ID 2892042.1)

Last updated on DECEMBER 13, 2023

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA) previously known as Oracle Financial Services Profitability Analytics (PFTBI)
Oracle Business Intelligence Enterprise Edition (OBIEE)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)


On EFPA 8.0.x, Data Transformation (DT) task that runs FSI_LEDGER_STAT_TRM (to move data from LEDGER_STAT to FCT_LEDGER_STAT), fails with "ORA-00957: duplicate column name" error.


[14-07-22 07:16:07 GMT ][INFO][BACKEND][OFSAA][RUNPROCEDURE] Parameters : fsi_ledger_stat_trm,'INFODOM_FSI_LEDGER_STAT_TRM_20220714_1','20220714',3,3,2021,'','','Y','ZAR'
[14-07-22 07:16:07 GMT ][INFO][BACKEND][OFSAA][RUNPROCEDURE] Statement to execute : BEGIN :D := fsi_ledger_stat_trm('INFODOM_FSI_LEDGER_STAT_TRM_20220714_1','20220714',3,3,2021,'','','Y','ZAR'); END;
[14-07-22 14:50:18 GMT ][INFO][BACKEND][OFSAA][RUNPROCEDURE] Fetching the return status.
[14-07-22 14:50:18 GMT ][INFO][BACKEND][OFSAA][RUNPROCEDURE] Return value From the Stored Procedure : 0
[14-07-22 14:50:18 GMT ][SEVERE][BACKEND][OFSAA][RUNPROCEDURE] Error code returned : 904278173
[14-07-22 14:50:18 GMT ][INFO][BACKEND][OFSAA][RUNPROCEDURE] execPackage : return val : 0
[14-07-22 14:50:18 GMT ][INFO][BACKEND][OFSAA][RUNPROCEDURE] After Calling execProc
[14-07-22 14:50:18 GMT ][SEVERE][BACKEND][OFSAA][RUNPROCEDURE] Stored procedure execution failed


FSI_MESSAGE_LOG output returned:

Starting FCT_LEDGER_STAT load
Re-run Selected
#38546297records deleted from FCT_LEDGER_STAT
Fatal error occured :ORA-00957: duplicate column name


ORA-00957: duplicate column name


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.