My Oracle Support Banner

Txns Struck In Mtl_material_transactions_temp , Needs To Be Cleared Before Inv Period Close (Doc ID 1568195.1)

Last updated on AUGUST 09, 2018

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Transactions

There are four errored records in mtl_material_transactions_temp table.
Those are WIP Issue transactions that will not process due to the following errors.

ERROR
-----------------------
ERROR_CODE ERROR_EXPLANATION
Transaction processor error Negative balances not allowed
Transaction processor error |Child O2370 already has a parent CCCBTCQLOCC1TRV MTR NORTH from 12-NOV-2012 08:17:37; the open period from 06-MAR-2013 09:36:00 overlaps with it.|Chi
Transaction processor error |Child 6638347 already has a parent CCBBTCQLOCB2TRV MTR NORTH from 12-NOV-2012 08:10:04; the open period from 06-MAR-2013 09:36:01 overlaps with it.|C
Transaction processor error Status "&STATUS" of Locator &OBJECT disallows this transaction.


STEPS
-----------------------
The issue cannot be reproduced at will.


Cause

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.