Post PFT 8.1 Upgrade, DT Fails for fn_drmDataLoader Function
(Doc ID 2740568.1)
Last updated on FEBRUARY 26, 2023
Applies to:
Oracle Financial Services Profitability Management - Version 8.1.0.0.0 and laterInformation in this document applies to any platform.
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Analytical Application Infrastructure (OFSAAI)
Oracle Financial Services Enterprise Performance Management (EPM)
Data Transformation (DT)
Symptoms
Post PFT upgrade from 8.0.7 to 8.1 fn_drmDataLoader function failed:
ERROR
-----------------------
[12-12-20 01:16:29 GMT AM][INFO][BACKEND][OFSAA][DTCPP] Stmt : update AAI_DMT_PLC_EXECUTE set v_status='F' where v_Infodom_Code='<Infodom Name>' and v_obj_id='XXXXXX'
[12-12-20 01:16:29 GMT AM][INFO][BACKEND][OFSAA][DTCPP] Task status : 1
[12-12-20 01:16:29 GMT AM][INFO][BACKEND][OFSAA][DTCPP] Task Failure
Also executing the procedure directly in SQL*Plus as the atomic user:
Gives no info in the fsi_message log and following error in SQL*Plus console:
Oracle Error User-Defined Exception
PL/SQL procedure successfully completed.
Changes
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 |
Changes |
Cause |
Solution |
References |