My Oracle Support Banner

Cash Flow Edit on Forward Rate Agreements Fails With Missing Columns (Doc ID 2689250.1)

Last updated on JULY 15, 2020

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Funds Transfer Pricing (FTP)
Forward Rate Agreements (FRAs)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

Cash flow Edit on Forward Rate Agreements fails with the following error on the batch monitor and there is no entry in FSI_PROCESS_ERRORS table. Missing Columns error is shown when running via the command line.

Error:
Batch Monitor shows:
[10105] Failed

Cash flow edit for Forward Rate Agreements ran via the command line shows the complete error below:

| strBatchId : OFSAAAIINFO_Task1_201071_1 | strComponentId : CFEDITS | Process ID : 201071 | User ID : <USERNAME>| App ID : ALM|
Connect to database atomic was successful.
Running Balance & Control: Process ID: 201071
SysID=[201071],Preview=[1],SelectedSource=[1],FilterId=[201070],ProductLeaf =[4]
Leaf_field for leaf_num_id=4 is PRODUCT_ID
FSI_CF_EDIT_PROC_TABLES
Product ID column = PRODUCT_ID
FSI_CF_EDIT_PROC_TABLES
Table name=FSI_D_FORWARD_RATE_AGMTS
MB(Missing Columns) Table: FSI_D_FORWARD_RATE_AGMTS is missing columns:
neg_amrt_eq_date, neg_amrt_eq_freq, neg_amrt_eq_mult, neg_amrt_limit, pmt_adjust_date
pmt_chg_freq, pmt_chg_freq_mult, pmt_decr_life, pmt_decr_cycle, pmt_incr_cycle
pmt_incr_life, t_rate_int_rate_cd, behaviour_type_cd, behaviour_sub_type_cd, offset_percent
expected_bal, residual_amount, maturity_amount 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.