My Oracle Support Banner

Manufacturing Transaction Diagnostics - Functional User Sql Investigation And Repair (Doc ID 801794.1)

Last updated on NOVEMBER 27, 2018

Applies to:

Oracle Cost Management - Version to 12.1 [Release 11.5 to 12.1]
Information in this document applies to any platform.


This document was produced for an Oracle Premier customer that wanted a consolidated list of investigative / repair sql addressing manufacturing processes.   The idea was to include DEV specific suggestions not published in Metalink (MyOracle Support) as well as known solutions in one doc to save time.  The commentary is derived from DEV, myself and Global Support.

The following SQL is meant to assist in debugging transactional issues and in some cases repair such transactions.  This list is not exhaustive and not meant to address all transactional errors.  In some cases, Oracle development is reluctant to publish update SQL statements without having reviewed basic data.  The following €select-SQL statements are meant to be used to supply such data to Oracle development if so required OR enable customers to facilitate the repair on site.


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
 Best Practices Environment Initiation

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