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.


 

14 comments:

  1. You saved my day :) Thank you

    ReplyDelete
  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.

    Thanks!
    Nagesh

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

    ReplyDelete
  4. 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.

    ReplyDelete
    Replies
    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

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

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

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

    ReplyDelete
  8. nice blog thanks for such a useful information
    click here

    ReplyDelete
  9. Nice blog thanks for sharing such a useful information
    For more details <a href="https://www.calfre.com/UAE/Dubai/Deira/Oracle-ASCP-Online-Training/listing”>click here</a>

    ReplyDelete
  10. Good information for more details
    <a href="https://www.calfre.com/UAE/Dubai/Deira/Oracle-SQL-And-PL-SQL-Online-Training/listing”>click here</a>

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

    ReplyDelete
  12. Nice information. Thanks for sharing such an amazing article. For online training and Self Paced courses visit our site click4learning.com/product/oracle-ascp/

    ReplyDelete