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 24, 2023

Applies to:

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

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