Change Controlled Attribute Value Is Showing the Same Value in OPLA MDS ITEM_F Table (Doc ID 2203263.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Product Lifecycle Analytics - Version 3.5.0 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior

For Page Two/Page Three Change Controlled attributes, all the revisions for the Document/Part subclass is showing same records in ITEM_F Table

Expected Behavior

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:

  1. 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
  2. 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
  3. Run Full ETL
  4. Run MDS Load
  5. Login to sqlplus as MDS schema, and run sql to check the ITEM_F table
  6. See ITEM_USRDEF_DATE1, ITEM_USRDEF_DATE0 and ITEM_USRDEF_DATE5 are all showing the same attribute for all the revision of Document/Part

Cause

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 hundreds of Community platforms