My Oracle Support Banner

Transfer Pricing Rate Not Getting Generated Due To Wrong Table Classification (Doc ID 2786820.1)

Last updated on APRIL 21, 2023

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.1.0.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)

Symptoms

Unable to generate Transfer Pricing rates for FTP process on FSI_D_LOAN_CONTRACTS table.

Error:
FSI_PROCESS_ERRORS shows:
No Direct TP method defined on leaf and No migration option for Table: FSI_D_LOAN_CONTRACTS to use

There is only one reference on FSI_D_LOAN_CONTRACTS table in the Transfer Pricing Engine log:

Transfer_Pricing_Engine_<INFODOM>_207572_EXEC_20181231_1_Task1.log:

select    REV_TABLE_CLASS_ASSIGNMENT.table_name,
    REV_TABLE_CLASS_ASSIGNMENT.owner,
    REV_TABLE_CLASS_ASSIGNMENT.table_classification_cd
from    REV_TABLE_CLASS_ASSIGNMENT
where    TABLE_NAME=UPPER('FSI_D_LOAN_CONTRACTS')
AND    TABLE_CLASSIFICATION_CD=50


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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