Risk Manager 4.5 Transform and Consolidation Process Failed with Unable to Process Error 20713 (Doc ID 313336.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Risk Manager - Version 4.5.39 to 4.5.41
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

When attempting to run Risk Manager Process ID using Transformation and Consolidation options failed with error.

Error:

Error Message from OFSA_MESSAGE_LOG:
RM Transformation: Error: No data was found to transform. 20771
Unable to process 20713

Error Message from ofsrm.log:
Oracle Error: ORA-00904: "PRODUCT_ID": invalid identifier
Driver Function: drv_oci::Execute()
SQL Statement: insert into ofsa_consolidated_master

Expect to see results in RES_DTL_xxx, CONS_DTL_xxx, and ofs_rpt_res_dtl_xxx$C tables.

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