Procure to Pay process

Unable to cancel rejected purchase order

Goal : how to cancel rejected purchase order ?

step :

1. Create Purchase order version 0
2. approve it
3. add new lines to the approver Purchase order
4. Get new version 1
5. try to cancel the purchase order

 user get error : unable to approve the PO

Solution : delete the new lines and try to cancel it agin.

How To Add Export Button In The Buyer Work Center For Requisitions?

The following personalization can be considered. 

1. Using System Administrator - Navigate - Profile - System 
 - Ensure the profile - Personalize Self Service Defn - is set to yes at the User level. 





2. Purchasing Super User - Navigate - Buyer Work Center - Requisitions



Choose the Personalize Page icon in the upper right hand corner. 






Look for the Line having Row Layout: (ActionRN) - scroll to the right and choose create item
- Choose the Expand All option - seen in the top left corner of the table - to ensure all elements are visible




For ID and Additional Text, you can enter desired value, example ExportReq.
 - Be sure to choose the Item Style as Export Button
 - The True and False decision boxes are fine as defaulted
 - Ensure Rendered decision box is True
 - For the Text box, give the desired button name
 - For view Instance - give ReqSearchVO
 - Choose Apply
 - You are returned to the personalize page screen previously seen above
 - Choose the Return to Application and you are returned to the Buyer Work Center



The button is now present and will export data in the current view that is selected. 

Oracle Purchasing (http://www.oracle.com/us/products/applications/ebusiness/procurement/053979.html)

Oracle Purchasing is the application for professional buyers that streamlines purchase order processing while strengthening policy compliance. It is a key component of Oracle Advanced Procurement

According to independent experts the key to achieving world class procurement performance lies in using technology to automate routine tasks. This frees procurement professionals to work on more strategic tasks related to sourcing and supplier management. Oracle Purchasing does just that. It automates purchasing to make buyers more productive, improves management of your supply base, and adapts to virtually any procurement process.

As the heart of the Oracle Advanced Procurement suite, Oracle Purchasing provides a rich store of policy and supplier information, an enterprise class automation platform, and a robust workbench for buying professionals.

Integrate and Streamline Your Procurement Processes
Oracle Purchasing is part of Oracle Advanced Procurement suite, and integrates seamlessly with other Procurement applications, including iProcurement, Payables, and iSupplier Portal.

BENEFITS

Automate the Entire Procure-to-Pay Cycle: Define suppliers and agreements; then automate your entire purchasing cycle from purchase order to settlement Improve Supply Base Management: Take central control of all supplier and item master information with an application that tightly integrate suppliers into your organization by leveraging advanced supply management capabilities Adapt to Any Purchasing Practice: Adapt the application to your organization's purchasing practices with uniquely configurable policies and an open architecture that integrates legacy and supplier systems

PO:How to link Purchase order and Purchase Requisition

you can use this table to join PO tables with PR Tables
PO_HEADERS_ALL
PO_DISTRIBUTION_ALL
PO_REQ_DISTRIBUTION_ALL

Form Personalization : How to make security in PO Forms using DEFAULT WHERE

Property Object Type - Block  
Target Object - The block from
Property Name - DEFAULT_WHERE 
Value :  PO_HEADER_ID in (1,2,3)

How to add custom workflow : PO Receipt