My Oracle Support Banner

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 and later
Information 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)


Post PFT upgrade from 8.0.7 to 8.1 fn_drmDataLoader function failed:

[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.




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.