RM Internal Error: ORA-01400: Cannot Insert NULL into OFSA_PROCESS_CASH_FLOWS.ID_NUMBER (Doc ID 361750.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

When running a Risk Manager (RM) Process that includes new business records generated by a Forecast Balance ID, the process ends with an "Internal Error" and the following error is found in the ofsrm.xxxx file in the OFSA log directory:

Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:

OCI Function: [4] - oexec(), oexn()
SQL Function: [3] - INSERT
Oracle Error: ORA-01400: cannot insert NULL into ("owner"."OFSA_PROCESS_CASH_FLOWS"."ID_NUMBER")

Driver Function: drv_oci::Execute()

SQL Statement: insert into OFSA_PROCESS_CASH_FLOWS (
result_sys_id,record_sequence,cash_flow_sequence,scenario_num,financial_elem_id,id_number,cash_flow_date, cash_flow_cd,float_value,product_leaf_node,org_leaf_node,iso_currency_cd,calc_source_cd)
values ( :result_sys_id, :record_sequence, :cash_flow_sequence, :scenario_num, :financial_elem_id,
:id_number, :cash_flow_date, :cash_flow_cd, :float_value, :product_leaf_node, :org_leaf_node,
:iso_currency_cd, :calc_source_cd )

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