RCA/Datafix: Negative TRANSACTION_SOURCE_ID In MTL_MATERIAL_TRANSACTIONS (Doc ID 803790.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
FORM:INVTTMTX.FMB - Inventory Transactions
FORM:INVTVTXN.FMB - View Transactions
This document includes all versions of 11i and R12 and later

Goal

Find transactions with 10+ digit negative numbers for the source id instead of a valid source id.

 



Example
Here is an example transaction source id found on one customer environment:

 

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