My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

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)


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


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

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