Inconsistency In Length Of Attribute Name Between STG_PRODUCTS_ATTR_INTF[VARCHAR2(30)] And REV_DIM_ATTRIBUTES_TL[VARCHAR2(80)]
(Doc ID 2642930.1)
Last updated on FEBRUARY 28, 2020
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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)
Oracle Financial Services Analytical Applications (OFSAA)
OOTB - Out Off The Box
UI - User Interface
During the upload process of Product dimension members and attributes using the standard OFSAA Dimension Loading procedure customer is unable to load the corresponding attribute values in STG_PRODUCTS_ATTR_INTF as the length of the attribute name (34 characters) exceeds the precision:
One of the predefined (seeded) Product attributes is “Interest Rate Sensitivity Category” (34 characters).
- In STG_PRODUCTS_ATTR_INTF the datatype of V_ATTRIBUTE_VARCHAR_LABEL is VARCHAR2(30)
- In REV_DIM_ATTRIBUTES_TL the datatype of ATTRIBUTE_NAME is VARCHAR2(80)
Steps to reproduce the issue:
1. Prepare insert statements for the Product members
2. Run insert statements
The data will not be inserted due to the fact that the “Interest Rate Sensitivity Category” value exceeds the precision of the corresponding attribute name from STG_PRODUCTS_ATTR_INTF
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