My Oracle Support Banner

Standard Datafix APP-INV-05357 Error While Trying To Change The Control Level Of Category Set From Organization to Master Level (Doc ID 1065131.1)

Last updated on MARCH 19, 2024

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
This document includes all versions of Oracle E-Business Suite 11i and Release 12


Goal

The system does not allow to change the control level of a category set from Organization (org) control to Master control through forms as this could result in data corruption.

Resolution: This generic datafix patch can be applied and run when the control level for a category set has to be changed from org controlled to master controlled. Data for the items in the child orgs is updated to reflect the category assigned in the master org for a particular category set.

Error which may be associated with changing the category set level.
Error: APP-INV-05357: Change rejected -- Category Set control level mismatch.
Cause: You cannot change the maintenance level to Master level from the organization level, altering the category set maintenance level will corrupt your data.

Please use this document in the following order:
A. Identification Scripts: This will confirm if you are having this data mismatch.
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 Instructions. It will provide steps for fixing the data mismatch and updating category set control level.

Solution

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
Goal
Solution
 A - Identification Scripts.
 B - Verifying your File Versions.
 C -  Root Cause Analysis.
 D - Datafix.
 1- Download and run the datafix script.
 Important NOTE :
 2- Check the data.
References

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