Transfer Pricing Rule Is Blank After Re-opening the Rule (Doc ID 2912095.1)

Last updated on DECEMBER 14, 2022

Applies to:

Symptoms

In Funds Transfer Pricing, you reviewed settings in a Transfer Pricing Rule.  Later, when you re-open the Transfer Pricing Rule, it is blank.  The rule contains no definitions and the last modification date is from several months ago.

Additionally, no rows exist in FSI_M_TRANSFER_PRICE_RULE for the rule.

Reviewing the ftpapp.log, you find the following delete statements:

[11-10-22 15:19:34,637 GMT PM] [DEBUG] [WEB] DBManager::executeUpadte() for Batch execution :infodom= INFODOM
[11-10-22 15:19:34,637 GMT PM] [DEBUG] [WEB] Query=DELETE FROM FSI_M_TP_REDEMPT_CURVE_DTL T WHERE T.TRANSFER_PRICE_SYS_ID = ? AND T.PRODUCT_ID IN(SELECT DISTINCT PRODUCT_ID FROM FSI_M_TRANSFER_PRICE_RULE R WHERE R.TRANSFER_PRICE_SYS_ID = ? AND R.PRODUCT_HIERARCHY_ID = ?)
[11-10-22 15:19:34,637 GMT PM] [DEBUG] [WEB] DBManager::wrapQuery() Param : {1=218600, 2=218600, 3=204746}
[11-10-22 15:19:34,641 GMT PM] [DEBUG] [WEB] Query=DELETE FROM FSI_M_TP_UNPRICED_ACCT_DTL T WHERE T.TRANSFER_PRICE_SYS_ID = ? AND T.PRODUCT_ID IN(SELECT DISTINCT PRODUCT_ID FROM FSI_M_TRANSFER_PRICE_RULE R WHERE R.TRANSFER_PRICE_SYS_ID = ? AND R.PRODUCT_HIERARCHY_ID = ?)
[11-10-22 15:19:34,642 GMT PM] [DEBUG] [WEB] DBManager::wrapQuery() Param : {1=218600, 2=218600, 3=204746}
[11-10-22 15:19:34,642 GMT PM] [DEBUG] [WEB] Query= delete from FSI_M_TRANSFER_PRICE_RULE where transfer_price_sys_id = ? and product_hierarchy_id= ?
[11-10-22 15:19:34,642 GMT PM] [DEBUG] [WEB] DBManager::wrapQuery() Param : {1=218600, 2=204746}
[11-10-22 15:19:34,664 GMT PM] [INFO ] [WEB] dependenciesHandler successful executed

You do not understand what caused the Transfer Pricing Rule to lose its definitions.

Cause

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