Troubleshooting OFSAA F2T Failures (Doc ID 2255254.1)

Last updated on APRIL 14, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.1 and later
Oracle Financial Services Asset Liability Management - Version 6.1 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 Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
F2T (File to Table)
Data Management
Data Mapping

Symptoms

On OFSAAI 7.3.5.2.0, when running an F2T batch, the batch is failing.

ERROR
The DS task log DS_OFSA_F2T_EDU_DRIVER_LOAD_20170410_1_Task1.log shows the failure:

Log Message here 1: Mon Apr 10 06:03:33 2017||INFO||Load : Executed loader command
Log Message here 1: Mon Apr 10 06:03:33 2017||DEBUG||Load : Number of Records Loaded : 0
Log Message here 1: Mon Apr 10 06:03:33 2017||DEBUG||Load : Number of Records rejected : 7
Log Message here 1: Mon Apr 10 06:03:33 2017||DEBUG||Load : Number of Records Discarded : 0
Log Message here 1: Mon Apr 10 06:03:33 2017||DEBUG||Load : Rejection Threshold is : 7
...
Log Message here 1: Mon Apr 10 06:03:33 2017||INFO||Load : Removed temp files - before freeing
Log Message here 1: Mon Apr 10 06:03:33 2017||INFO||Load : After freeing - returning
Log Message here 1: Mon Apr 10 06:03:33 2017||INFO||DmasServer, Error : Returning FAILURE

Other F2Ts are successful in this instance.

The EDU_DRIVER_csv.log SQLLoader log shows the actual root cause for failure:

value used for ROWS parameter changed from 64 to 36
Record 1: Rejected - Error on table REV_ADJ_LD, column ISOCRNCYCD.
Field in data file exceeds maximum length

...

Record 7: Rejected - Error on table REV_ADJ_LD, column ISOCRNCYCD.
Field in data file exceeds maximum length

Table REV_ADJ_LD:
  0 Rows successfully loaded.
  7 Rows not loaded due to data errors.

The issue can be reproduced at will with the following steps:
1. Run the F2T_EDU_DRIVER_LOAD batch.

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