My Oracle Support Banner

MRP Planned Order Release For Requisition - Req Import Completes Successfully But Does Not Create Requisitions (Doc ID 1518882.1)

Last updated on SEPTEMBER 04, 2018

Applies to:

Oracle Materials Requirement Planning - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 18-Jun-2014***

Symptoms

11.5.10 in Production and Test

PROBLEM
-------------
Release a planned order from standard MRP Workbench and it does not create a requisition as expected.

We can see that when we put Req Import on hold and do the release that the line is inserted correctly into po_requisitions_interface_all
But then when we release the hold on req import and it runs successfully, the line is not picked up and processed by the Req import.


STEPS
--------
Set profile Concurrent Hold Requests - Yes for user
1. Open MRP workbench and release the planned order
-- took SQL of lines before / middle (after save release flag) and End - after click release to send to PO -- see success in all steps.
2. took SQL of line when inserted into po_requisitions_interface_all and it matches the parameters for the submitted req import
3. release hold on Req import and see it run successfully
4. Check po_requisitions_interface_all again and see line still exists and no errors in PO interface error table
-- line was unchanged which shows req import did not select the line for processing.


EXPECTED BEHAVIOR
----------------------------
Line would be processed.


BUSINESS IMPACT
----------------------
cannot do any MRP planned order activity to release orders to create req supplies.

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


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.