Missing Records in Destination Table For Payment Schedule T2T Load (Doc ID 2221602.1)

Last updated on JANUARY 09, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Table to Table (T2T)
Data Mapping

Symptoms

On OFSAA 8.0.2, it appears that there are Missing Records in Destination Table for the FSI_D_PAYMENT_SCHEDULE Payment Schedule T2T Batch Load.

ACTUAL BEHAVIOR
Loading payment schedules for term deposits, from a STG table to the FSI_D table, through the standard T2T. Have loaded 38 records in the STG_PAYMENT_SCHEDULE, after running the T2T there are only 31 records in the FSI_D_PAYMENT_SCHEDULE table and no errors records into the FSI_D_PAYMENT_SCHEDULE$. This is for instrument type 230. It appears that 7 records were lost in the loading process, with no errors reports into de $ table for this instrument type.

EXPECTED BEHAVIOR
Expect to see either rejected records in the FSI_D_PAYMENT_SCHEDULE$ or expect all records successfully loaded to the target FSI_D_PAYMENT_SCHEDULE table.

The issue can be reproduced at will with the following steps:
1. Load the STG_PAYMENT_SCHEDULE table
2. Run the T2T loader for Payment Schedule
3. Check results.

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