My Oracle Support Banner

Why Does T2T_LOAN_CONTRACTS Data Mapping Join References Non-existent Attribute Values? (Doc ID 2432589.1)

Last updated on AUGUST 17, 2018

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.6 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Goal

For Oracle Financial Services Profitability Management (PFT) 8.0.6, why do the out-of-the-box (OOTB) Data Mapping T2Ts like T2T_LOAN_CONTRACTS reference attribute values - 5556 and 5557 - that do not exist? (see below)  Would this cause the T2T load to fail?

left outer join dim_customer_attr ON dim_customer_attr.customer_id = dim_customer_b.customer_id
AND dim_customer_attr.attribute_id = 5556
left outer join fsi_customer_type_cd
ON fsi_customer_type_cd.customer_type_display_cd = dim_customer_attr.dim_attribute_varchar_member
left outer join dim_products_attr ON dim_products_b.product_id = dim_products_attr.product_id
AND dim_products_attr.attribute_id = 5557

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.