FTP Ledger Stat Migration Output No Rows to Ledger Stat Table Even Though Rows Are Written to FSI_LS_MIGRATION_RESULTS (Doc ID 1411530.1)

Last updated on FEBRUARY 10, 2012

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version: 5.6 and later   [Release: 5 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x

Symptoms

On Oracle Financial Services Funds Transfer Pricing (FTP) 5.6, when attempting to run Ledger Stat migration, no FE 170 Average Transfer Rate or FE 450 Charge/Credit rows are written to the Ledger Stat table. All the steps in How to Get FTP Results Posted to Ledger Stat Using Migration Option (<Note: 1397072.1>) are correctly followed and the correct rows are written to the fsi_ls_migration_results table.

ACTUAL BEHAVIOR
No FE 170 / FE 450 rows are output to Ledger Stat.

EXPECTED BEHAVIOR
Expect rows to be inserted into ledger_Stat for ledger migration.

STEPS
The issue can be reproduced at will with the following steps:
1. Follow all steps in How to Get FTP Results Posted to Ledger Stat Using Migration Option (<Note: 1397072.1>) .
2. Check the FSI_LS_MIGRATION_RESULTS table for output rows.
3. Check LEDGER_STAT for output FE 170 / FE 450 rows.

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