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:

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

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