ORA- 01400: cannot insert NULL into ("OFSATOMIC"."FSI_INTEREST_RATES_AUDIT"."PROCESS_DATE") Error Using ALM Interest Rates Audit (Doc ID 1494281.1)

Last updated on SEPTEMBER 26, 2012

Applies to:

Oracle Financial Services Asset Liability Management - Version 5.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.x
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On Oracle Financial Services Asset Liability Management (ALM) 5.6, when attempting to run an ALM process with Audit : Forecast Rate - Interest Rates, the following error occurs:

ERROR
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [3] -
INSERT Oracle Error: ORA- 01400: cannot
insert NULL into
("OFSATOMIC"."FSI_INTEREST_RATES_AUDIT"."PROCESS_DATE") Driver
Function: drv_oci::Execute() SQL Statement:
insert into FSI_INTEREST_RATES_AUDIT(PROCESS_SYS_ID,
CALC_SOURCE_CD, START_DATE, SCENARIO_NUM, INTEREST_RATE_CD,
INTEREST_RATE_TERM, INTEREST_RATE_TERM_MULT, BUCKET_NUM,
BUCKET_START_DATE, BUCKET_END_DATE, RATE)
values (:PROCESS_SYS_ID, :CALC_SOURCE_CD, :START_DATE,
:SCENARIO_NUM, :INTEREST_RATE_CD, :INTEREST_RATE_TERM,
:INTEREST_RATE_TERM_MULT, :BUCKET_NUM, :BUCKET_START_DATE,
:BUCKET_END_DATE, :RATE )


STEPS
The issue can be reproduced at will with the following steps:

1. Enable Forecast Rates Audit for Interest Rates: Audit : Forecast Rate - Interest Rates in ALM Process
2. Run the process
=> error occurs

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