Changing the Inventory Org Valuation Accounts (Doc ID 1469836.1)

Last updated on JULY 06, 2023

Applies to:

Goal

Need to update the inventory organization valuation accounts

COA has 10 segments.  Segment #2 was associated with client's old ERP & reporting system.  Customer now wishes to stop using (make all 0000s) Segment #2 since the 3rd party systems have been phased out.

The Inventory Organization Valuation accounts include various codes for Segment #2.  Customer would like to change all Segment #2 values to 000000.  

Standard functionality appears to lock down the valuation accounts on the organization setup form.  Is there a way to manually revise these accounts?  If not, is there a script available to update these accounts?  There are ~800 inventory orgss / distribution centers so it is not practical to create new orgs.

Solution

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