Manufacturing Transaction Diagnostics - Functional User Sql Investigation And Repair

(Doc ID 801794.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle Cost Management - Version to 12.1 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance 29-Dec-2015***


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.


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