Records Not Getting Inserted Into FSI_PM_GENERATED_INSTRMTS in Pricing Manager After Running tpol.sh Batch (Doc ID 1669152.1)

Last updated on MAY 08, 2014

Applies to:

Oracle Financial Services Pricing Management, Transfer Pricing Component - Version 5.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
TPOL

Symptoms

On Oracle Financial Services Pricing Management, Transfer Pricing Component (PRICEMGMT) 5.6, when running the tpol.sh script, it appears that Records not getting inserted into FSI_PM_GENERATED_INSTRMTS.

ACTUAL BEHAVIOR
No records inserted into FSI_PM_GENERATED_INSTRMTS.  After completing the configuration in Pricing Manager, tpol.sh is executed from the batch.

tpol_OFSMMFTP_TPOLRUN_20140331_1_20140331.props log file showed insert statement:

[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, ISO_CURRENCY_CD, ACCRUAL_BASIS_CD, AMRT_TERM, AMRT_TERM_MULT, AMRT_TYPE_CD, COMPOUND_BASIS_CD, CUR_BOOK_BAL, CUR_GROSS_RATE, CUR_NET_BOOK_BAL_C, CUR_NET_PAR_BAL_C, CUR_NET_RATE, CUR_PAYMENT, CUR_PAR_BAL, DATA_SOURCE_CD, DEFERRED_CUR_BAL, DEFERRED_ORG_BAL, INSTRUMENT_TYPE_CD, INTEREST_RATE_CD, ISSUE_DATE, ISSUE_TERM, ISSUE_TERM_MULT, LAST_REPRICE_DATE, MARGIN, MARKET_VALUE_C, MATCHED_SPREAD_C, MATURITY_DATE, NEG_AMRT_AMT, NEG_AMRT_EQ_DATE, NEG_AMRT_EQ_FREQ, NEG_AMRT_EQ_MULT, NEG_AMRT_LIMIT, NEXT_PAYMENT_DATE, NEXT_REPRICE_DATE, ORG_BOOK_BAL, ORG_NET_BOOK_BAL_C, ORG_NET_PAR_BAL_C, ORG_PAYMENT_AMT, ORG_PAR_BAL, ORG_RATE, ORG_TERM, ORG_TERM_MULT, ORIGINATION_DATE, PERCENT_SOLD, PMT_ADJUST_DATE, PMT_CHG_FREQ, PMT_CHG_FREQ_MULT, PMT_DECR_CYCLE, PMT_DECR_LIFE, PMT_FREQ, PMT_FREQ_MULT, PMT_INCR_CYCLE, PMT_INCR_LIFE, RATE_CAP_LIFE, RATE_CHG_MIN, RATE_CHG_RND_CD, RATE_CHG_RND_FAC, RATE_DECR_CYCLE, RATE_DECR_LIFE, RATE_DECR_YEAR, RATE_FLOOR_LIFE, RATE_INCR_CYCLE, RATE_INCR_LIFE, RATE_INCR_YEAR, RATE_SET_LAG, RATE_SET_LAG_MULT, RECORD_COUNT, REMAIN_NO_PMTS_C, REMAIN_TERM_C, REMAIN_TERM_MULT_C, REPRICE_FREQ, REPRICE_FREQ_MULT, TEASER_END_DATE, TRANSFER_RATE, NET_MARGIN_CD, MARGIN_GROSS, MARGIN_T_RATE, T_RATE_INT_RATE_CD, CUR_TP_PER_ADB, PRIOR_TP_PER_ADB, LAST_PAYMENT_DATE, ADJUSTABLE_TYPE_CD, INT_TYPE, LRD_BALANCE, LEAF_NUM_ID, LEAF_NODE, TRAN_RATE_REM_TERM, IDENTITY_CODE, ORG_UNIT_ID, GL_ACCOUNT_ID, COMMON_COA_ID, PRODUCT_ID, LE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[TPOL-InstrumentCreator]going to prodTerms loop...
done


TP rules with 90001 and 90002 for "TPOL Queries" and "TPOL Worksheets" were generated.

TP Process name as "TP Queries" had nothing selected in Source or the TP rule.
TP Process name as "TP Worksheet " had nothing selected in Source, although it had TP Rule selected as "TPOL TP ID" but the generated TPOL TP ID has nothing defined.

EXPECTED BEHAVIOR

Expected operation was data to be inserted into FSI_PM_GENERATED_INSTRMTS.

Changes

New Pricing Manager installation and setup.

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