My Oracle Support Banner

Items DFF Attributes That Are Imported Via Import Items Do Not Display In Master Items DFF Window (Doc ID 1939411.1)

Last updated on FEBRUARY 02, 2023

Applies to:

Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Item Issues


Items Descriptive Flexfield (DFF) attributes (attribute1 through attribute30) that are updated in mtl_system_items_b using the Import Items process do not present in the Items DFF form even though they exist in the data base.

HOWEVER, if the customer updates the Items DFF from the Master Items Form, ONCE, the updates present to the form and all subsequent updates to that items Items DFF ( via the Import Items process ) present to the form, as well.


Expect that all populated DFF attributes in the mtl_system_items_b table will present appropriately in the Items Descriptive Flexfield on the Master Items Form.


The issue can be reproduced at will with the following steps:
1. Using Import items, populate specific (attribute1 through attribute30) DFF attributes in mtl_system_items_interface and process changes
2. Attributes are updated in the mtl_system_items_b table
3. However, Attributes do not present in the DFF of the Master Items form.


 Customer upgraded from 11i.  Issue presents for historical (upgraded) items, but not new items.


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

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