My Oracle Support Banner

Batch with POPULATE_PM_TRANS_RATE_TABLE Fails with 'No Data Found in FSI_PM_GENERATED_INSTRMTS Table' (Doc ID 2653050.1)

Last updated on MARCH 31, 2020

Applies to:

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 (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)

Symptoms

When running the FTP Rate Card batch, it fails on the Task that calls POPULATE_PM_TRANS_RATE_TABLE.  When you check FSI_MESSAGE_LOG for the Batch, the following error is returned:

No Data Found in FSI_PM_GENERATED_INSTRMTS Table

FSI_PM_GENERATED_INSTRMTS is populated by running the executable tpol.sh in a prior Task.  The log file for this task, tpol_<Infodom>_<BatchName>_20200220_2_20200220.props from $FIC_DB_HOME/bin, contains the following at the end:

[TPOL-InstrumentCreator]instrumentTableName is :::FSI_PM_GENERATED_INSTRMTS
mLeafFieldColumn is at constructor:::::
SQL Query is ::::::: INSERT INTO FSI_PM_GENERATED_INSTRMTS (ID_NUMBER, DETAIL_RECORD, AS_OF_DATE, ..........................) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?............................)
[TPOL-InstrumentCreator]going to prodTerms loop...
done


There is nothing in the log after this point.  No products are processed.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.