New Business Not Generated for a Particular RM Coa ID with ORA-01438 Errors (Doc ID 257161.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

When running RM process, the new business results are not being generated for a particular product. Other instruments appear to be generating results correctly.

Check of the ofsrm.XXXXX.log debug log shows ORA-01438 errors:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
   oexn() SQL Function: [3] -
INSERT    Oracle Error: ORA- 01438: value larger than specified
   precision allowed for this column Driver Function:
   drv_oci::Execute() SQL Statement:
insert    into RES_DTL_100170 ( ORG_UNIT_ID, GL_ACCOUNT_ID,
   COMMON_COA_ID, RM_COA_ID, iso_currency_cd, result_sys_id,
   financial_elem_id, scenario_num, start_date_index,
   result_type_cd, bucket_001, bucket_002, bucket_003, bucket_004,
   bucket_005, bucket_006, bucket_007, bucket_008, bucket_009,
...
   bucket_120)
values    ( :ORG_UNIT_ID, :GL_ACCOUNT_ID, :COMMON_COA_ID,
   :RM_COA_ID, :iso_currency_cd, :result_sys_id, :financial_elem_id,
   :scenario_num, :start_date_index, :result_type_cd, :bucket_001,
   :bucket_002, :bucket_003, :bucket_004, :bucket_005, :bucket_006,
...
   :bucket_117, :bucket_118, :bucket_119, :bucket_120 )

Changes

Updated the configuration ID and changed the modeling bucket definition.

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