Missing Columns Error Running Cash Flow Edits on Table (Doc ID 863758.1)

Last updated on AUGUST 19, 2009

Applies to:

Oracle Financial Services Applications (OFSA) 4.5
Oracle Financial Data Manager - Version: 4.5 to 4.5.39
Oracle Balance and Control - Version: 4.5 to 4.5.39
This problem can occur on any platform.
Data Correction Processing ID

Symptoms

In Oracle Balance and Control (BC) 4.5, you cannot run the Cash Flow Edits on a table using a Data Correction Processing ID.  The following error appears on the screen and in the ofsbc.xxxxx file:

MB(Missing Columns) Table: <Table Name> is missing columns:

amrt_term, amrt_term_mult, amrt_type_cd, lrd_balance, org_payment_amt
rate_decr_cycle, rate_incr_cycle, rate_set_lag, rate_set_lag_mult, remain_no_pmts_c

As a result, Cash Flow Edits cannot be run against the table.

Steps To Reproduce:

  1. Log into Balance and Control
  2. Open a Data Correction Process ID with the CASHFLOW_EDITS.<ORACLE> rule selected
  3. Select the instrument table
  4. Run

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