My Oracle Support Banner

ORA-01403 When Updating Inventory Planning Method to Vendor Managed for Items in External Organizations (Doc ID 2731937.1)

Last updated on JULY 21, 2021

Applies to:

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


Receiving the error ORA-01403 when trying to update Inventory planning method to Vendor Managed for Items in External Organizations.

User should be able to update Inventory planning method to Vendor Managed for Items in External organizations without any error exceptions.


The following is just dummy data for the purpose of illustrating the steps that reproduced the issue. Any similarity with real data is just coincidence.


A.Responsibility / Organization: Manufacturing and Distribution Manager
Navigation: Inventory -> Items -> Master Items

1.Create an Item in Master org V1 Item_0331_plan

2.Assign item to any of the external organization, ex: B1 or B2

3.Change organization to child org, B1 or B2

4.Search for the item in child org
Inventory -> Items -> Organization items

Search with 'Item_0331_plan'
Go to General planning tab, try to update inventory planning method to
'Vendor Managed'

It shows ORA-01403 exception error

Note: Able to update Inventory planning method to all other values like
Min-Max, Reorder Point, Not Planned but issue occurs while updating to Vendor Managed.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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