Wednesday, January 8, 2014

How to Release Oracle ASCP Planned order as Purchase Requisition

Release Oracle ASCP Planned order as Purchase Requisition

Navigation:  Comcast_Advanced Supply Chain Planner Responsibility > Supply Chain Plan > Workbench

Choose organization.

On the Workbench Navigator window, set “View By” to “Organizations” and expand “MasterPlan” under the “Plans” tree.

Select an org for which you want to release and right-click to select -- Supply and Demand > Supply and Demand


When the “Find Supply/Demand” pop-up window appears, enter the following filter conditions to shortlist the planned orders for release:


The filter condition should look like the following:


The Planners Workbench (PWB) should open up listing the planned orders for the selected item/org combination.
Order tab lists all the details for the item, org, suggested due date and quantity

Sourcing Tab gives details of the vendor and the vendor site.

To release a planned order, select the row and check the “For Release” button.

Go to the “Release Properties” tab and make any changes needed to the “Implement Date” and/or “Implement Quantity” values.

Once all the desired changes have been made, click “Save” button from the menu bar save the changes.  The font color will change to pink to show that the planning recommendation is ready to be released.


To release the recommendation, go to “Plan” > “Release”.  This will kick off the release process.  All the planned orders with “For Release” flag checked for the current user will be released.


Once the planned orders are released, the following summary will show up giving the number of New Requisitions created.

On the source side (11i TRAINING instance) two concurrent programs are kicked off to create the PRs:
1. Requisition Import
2. Create Releases


IMPORTANT: For the Requisition Import, the source type will be “MSC” which will indicate that the source of the requisition is ASCP module.



  1. You saved my day :) Thank you

  2. Hi Sagar,

    this is Nagesh i have a query about Released orders.

    : i have released the 3 planned orders from ASCP planner work bench . after the Requisition import and create release programs kicked off with normal status in OLTP instance.

    no requisitions were created. i can see in the log:

    Requisition Import Run Report Date: 29-MAY-15

    No requisitions were created
    Number of interface lines in error = 0

    po_requisitions_interface_all also i can see the related records.

    Plase advise what causes for not creating requisiton created.


  3. Is there a possibility to auto create purchase orders out of these requisitions?

  4. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.

  5. Is there a reference link from the individual planner order line to the requisition line? I cannot find one and this seems to be good audit trail/traceability to be able to link the specific planned order to the specific requisition line, especially for reporting and troubleshooting.

    1. Hi Don, I know this is very old but I'm wondering if you found an answer to this question as like you I don't see any link between the ASCP release line and the created requisition apart from the user, item, org details etc.. which is probably enough but it would be good to know if there are any additional links held elsewhere. Thanks

  6. nice blog thanks for sharing such wonderfull information about Oricle for more details pleas visit oursite
    Oracle ASCP Online Training in Deira, Dubai

  7. nice nlog thanks cor sharing such a good information for more details please visit our site
    click here

  8. nice blog thanks for sharing such a useful information
    for more details visit our site
    Oracle ASCP Online Training in Deira, Dubai

  9. nice blog thanks for such a useful information
    click here

  10. Nice blog thanks for sharing such a useful information
    For more details <a href="”>click here</a>

  11. Good information for more details
    <a href="”>click here</a>

  12. Please let me know if we have any script or API to do same requirement like above