Problems With New Non Dimension Custom Attributes Created With Incorrect Dimension ID
(Doc ID 1328663.1)
Last updated on OCTOBER 27, 2011
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2.6
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.2
Expect the attribute dimension ID should be the same as the dimension the attribute is created on.
This incorrect attribute creation creates additional issue as during the T2T dimension drmloader, there is a check on the financial element b table which is then incorrectly tied to the new attribute.
The issue can be reproduced at will with the following steps:
1. Financial Services Applications -> Master Maintenance -> Dimension Management -> Attributes
2. Choose Dimension: Product
3. Click Add
4. Code = 5055, Name = COKI_PROD_ATTR, Data Type = VARCHAR2
5. Click Save
Run the following query:
from rev_dim_attributes_b aa,
where aa.dimension_id = bb.dimension_id
and aa.attribute_dimension_id = cc.dimension_id
and aa.attribute_id = bb.attribute_id
and aa.dimension_id = '4';
select * from rev_dimensions_b cc where cc.dimension_id in (select attribute_dimension_id from rev_dim_attributes_b aa,rev_dim_attributes_tl bb where aa.dimension_id = '4' and
aa.attribute_id = bb.attribute_id);
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!