MRP Planned Order Release For Requisition - Req Import Completes Successfully But Does Not Create Requisitions
Last updated on MARCH 08, 2017
Applies to:Oracle Materials Requirement Planning - Version 126.96.36.199 and later
Information in this document applies to any platform.
***Checked for relevance on 18-Jun-2014***
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.
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