My Oracle Support Banner

APP-INV-05479 Standard Datafix To Find Orphan Item Records (Doc ID 1065107.1)

Last updated on SEPTEMBER 30, 2021

Applies to:

Oracle Item Master - Version and later
Oracle Product Hub - Version 12.2.4 to 12.2.4 [Release 12.2]
Oracle Inventory Management - Version to [Release 11.5.10]
Information in this document applies to any platform.
This document includes all versions of Oracle EBS 11i and R12 and later


Records for an item exist in at least one of the the below tables but do not exist in the MTL_SYSTEM_ITEMS_B table, and are considered as orphaned records:

Because of the issue, Users are not be able to assign the orphaned items to a child organization.

The standard datafix in this note removes the orphaned records so that items can be assigned to child organizations.

The following error might occur when attempting to assign an item to an organization:
APP-INV-05479 Please commit or clear your changes first

Please use this document in the following order:
A. Identification Scripts: This will confirm if you are having this data corruption.
B. Verifying your file versions: This will allow you and Support to confirm if you are already using a known fixed version.
C. Root Cause Analysis. It shows all the relevant information about this issue Root Cause.
D. Datafix Intructions. It will provide steps for fixing the data corruption.


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
 A - Identification Scripts.
 B - Verifying your File Versions.
 C -  Root Cause Analysis.
 1. There are currently no identified root causes for this issue.
 2. New Root- Causes?
 D - Datafix.
 1- Dowload and run the datafix script.
 2- Check the data.

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