My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.