My Oracle Support Banner

OPLA 3.6 'ITEM_F' COLUMN ITEM_USRDEF_NUMBER17 DATA TYPE NUMBER(22,0) HAS ISSUE (Doc ID 2547959.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Product Lifecycle Analytics - Version 3.6.0 to 3.6.1 [Release 3.6.0]
Information in this document applies to any platform.

Symptoms

On : 3.6.0 version, MDS Load for Agile PLM 9x

ACTUAL BEHAVIOR
---------------
Data is getting loaded into MDS schema in 'ITEM_F' OOTB table through OOTB procedure 'mds_com_item_f_pro' from agile and getting loaded after rounding off to the value.

EXPECTED BEHAVIOR
-----------------------
Correct (Original) data without rounding off to the value should show in MDS schema in 'ITEM_F' OOTB table.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
OPLA version is 3.6
Recently have upgraded OPLA from 3.5.0.0.8 to 3.6.
After upgrading OPLA facing this issue and before it works as expected.

Incorrect data is getting loaded into MDS schema from Agile for one Page Three attribute (name: Print Weight)(Type: Numeric & Scale 4).
Data is getting loaded into MDS schema in 'ITEM_F' OOTB table through OOTB procedure 'mds_com_item_f_pro' from agile and getting loaded after rounding off to the value.
For Example:
In agile attribute value is 'Print Weight' = 1.357 and in MDS table it is getting updated as 'Print Weight' = 1 (rounded off)

Changes

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.