Missing Mapping for Product dimension in T2T for FSI_D_INST_SUMMARY (Doc ID 2280066.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.4 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.4 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Table to Table (T2T)
Data Mapping

Symptoms

On PFT 8.0.4, unable to load data into the target FSI_D_INST_SUMMARY due to missing mapping for Product dimension in the T2T_INS_SUMM_LOANS T2T.

ACTUAL BEHAVIOR
Unable to load data into the target FSI_D_INST_SUMMARY. Noticed that the PRODUCT_ID is a mandatory column in the target table. T2T which populates the target table has no mapping for this column T2T: T2T_INS_SUMM_LOANS

EXPECTED BEHAVIOR
Expect mapping for T2T for FSI_D_INST_SUMMARY for PRODUCT_ID

The issue can be reproduced at will with the following steps:
1. Run T2T for FSI_D_INST_SUMMARY

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