My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

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.


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,
   :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 )


Updated the configuration ID and changed the modeling bucket definition.


To view full details, 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 a vibrant support community of peers and Oracle experts.