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 laterInformation in this document applies to any platform.
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA) previously known as Oracle Financial Services Profitability Analytics (PFTBI)
Reporting
Oracle Business Intelligence Enterprise Edition (OBIEE)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Symptoms
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.
From <FTPSHARE>/logs/<MISDATE>/<INFODOM>/TRANSFORM DATA/TRANSFORM DATA_<INFODOM>_<BATCH_RUN_ID>_<Task#>_RUNPROCEDURE.log:
[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
ERROR
ORA-00957: duplicate column name
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |