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

Last updated on MARCH 08, 2017

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

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