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 FEBRUARY 24, 2023
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)
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...
There is nothing in the log after this point. No products are processed.
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