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 JANUARY 30, 2022

Applies to:

Oracle Materials Requirement Planning - Version and later
Information in this document applies to any platform.


11.5.10 in Production and Test

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.

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.

Line would be processed.

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


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

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