Changing the Inventory Org Valuation Accounts (Doc ID 1469836.1)

Last updated on APRIL 20, 2017

Applies to:

Oracle Cost Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Goal

Need to update the inventory organization valuation accounts

Client's Oracle COA has 10 segments.  Segment #2 was associated with client's old ERP & reporting system.  Several years have passed since the Oracle implementation, and client 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.  Client 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

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 hundreds of Community platforms