My Oracle Support Banner

Discrete Job , EAM Work Order Pick Release Leaves Orphan Move Order Headers ( MTL_TXN_REQUEST_HEADERS ) Without Lines On Backorder (Doc ID 2564253.1)

Last updated on JULY 18, 2019

Applies to:

Oracle Inventory Management - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On :  12.2.7 version, Material Move Orders

ACTUAL BEHAVIOR  
---------------
EAM Work Orders Component Pick Release program is scheduled to run every 5 mins. Sometimes there is not enough quantity so the move order lines get backordered and deleted from the system. However, the headers are not deleted. This is causing increase in records in MTL_TXN_REQUEST_HEADERS with no lines in MTL_TXN_REQUEST_LINES.

EXPECTED BEHAVIOR
-----------------------
Even headers should be removed if there are no lines created / allocated.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Run EAM Work Orders Component Pick Release > Allow request to backorder due to insufficient qty > See move order headers created without any lines.

Changes

None

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
Changes
Cause
Solution
 A. Patch
 B. Datafix
 C. Reclaiming unused sequence post datafix
References


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