Change Controlled Attribute Value Is Showing the Same Value in OPLA MDS ITEM_F Table
(Doc ID 2203263.1)
Last updated on FEBRUARY 09, 2021
Applies to:Oracle Product Lifecycle Analytics - Version 3.5.0 and later
Information in this document applies to any platform.
For Page Two/Page Three Change Controlled attributes, all the revisions for the Document/Part subclass is showing same records in ITEM_F Table
To be able to get historical changes for Page Two/Page Three Change Controlled attributes of each Document/Part subclass revisions using the sql
Steps to Reproduce
The issue can be reproduced at will with the following steps:
- Login to Agile Java Client, and make below attributes of Document/Part subclass a change controlled attribute:
Field A: PAGE_THREE.DATE31
Field B: PAGE_THREE.DATE32
Field C: PAGE_THREE.DATE34
- From Configurator, map the Page Three attributes to MDS table:
Field A: -> Mapped to ITEM_USRDEF_DATE1
Field B: -> Mapped to ITEM_USRDEF_DATE0
Field C: -> Mapped to ITEM_USRDEF_DATE5
- Run Full ETL
- Run MDS Load
- Login to sqlplus as MDS schema, and run sql to check the ITEM_F table
- See ITEM_USRDEF_DATE1, ITEM_USRDEF_DATE0 and ITEM_USRDEF_DATE5 are all showing the same attribute for all the revision of Document/Part
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