FSI_LEDGER_STAT_TRM Completes with 0 Rows Inserted into FCT_LEDGER_STAT (Doc ID 1434389.1)

Last updated on NOVEMBER 10, 2015

Applies to:

Oracle Financial Services Profitability Analytics - Version: 5.5 and later   [Release: 5 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For Oracle Financial Services Profitability Analytics (PFTBI), when you run the FSI_LEDGER_STAT_TRM program to move data from LEDGER_STAT into FCT_LEDGER_STAT, the program completes successfully but no rows are inserted into FCT_LEDGER_STAT.  The following messages exist in FSI_MESSAGE_LOG:

Starting FCT_LEDGER_STAT load
Completed Successfully Inserted #0 records into FCT_LEDGER_STAT

This issue prevents you from completing a required step of the PFTBI implementation.

Steps to Reproduce:

1. Go to Operations > Batch Maintenance
2. Create a new Batch
3. Add a Task to the Batch with TRANSFORM DATA and the rule FSI_LEDGER_STAT_TRM
4. Add the following parameters for the rule:

null,null,2011,12345,null,'N'

5. Execute the batch

The batch is successful but no rows are loaded.

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