My Oracle Support Banner

Master Item Form(INVIDITM) Facing APP-INV-86696 Error Because of Attribute Dependency Conflict(Transactable=N, Check Material Shortage=Y) (Doc ID 2074552.1)

Last updated on MARCH 06, 2019

Applies to:

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

Symptoms

Problem Statement
Item attributes "Check Material Shortage" and "Transactable" are interdependent attributes. "Check Material Shortage" must be No if "Transactable" is set to No.

With the following steps,
Attribute Dependency Conflict(Item: Transactable=No, Check Material Shortage=Yes) happens.


Because of this data corruption(Attribute Dependency Conflict), user will face APP-INV-86696 error when updating any attribute.

Error
APP-INV-86696: Cannot propagate Master controlled attribute value of
Transactions Enabled Flag to child organizations.

Cause: This operation would result in attribute dependency conflict of Check
Shortages Flag (value: 'Y') and the Transactions Enabled Flag (value: 'N') in
one of the child organizations.

Action: Check the Attribute Control settings on these flags

Steps to Reproduce

    1. Navigate to Inventory: Setup > Items > Attribute Controls
      Set item attribute controls as below:
      Transactable : Org Level
      Check Material Shortage : Master Level

    2. Navigate to Inventory: Items > Master Items
      Create master item with following values:
      Transactable : Yes
      Check Material Shortage : Yes

    3. Assign item to both Master and Child Organizations

    4. Navigate to Inventory: Items > Organization Items
      Uncheck "Transactable"
      (Change the Item Status to Inactive will reach to the same result.)
      Save

    5. Attribute Dependency Conflict(Item: Transactable=N, Check MaterialShortage=Y) happens.
      NOTE: In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
    6. Because of this data corruption(Attribute Dependency Conflict), user will face APP-INV-86696 error when updating any attribute.

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


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