Skip to main content

FAQs on Oracle Requisition Change Order(RCO)

1. Can I change or cancel a requisition placed in a purchase order or release?
 A:   Requester can change or cancel a requisition if the purchase order or release is approved. Check iProcurement  Implementation Guide - section Requisition Changes - Implementation Considerations  for details and exceptions.

2. Why is Purchase Order approved but preparer/requester can not change the requisition?
A. Check if function View My Reqs Change Order is excluded in the responsibility. Also, check in the Purchasing Responsibility  > Setup > Purchasing > Document Type > Purchase Requisition if the flags are checked for Owner Can Change.

3. Can the Requester change the requisition with emergency Purchase Order?  
A: If the purchase order is approved and there is no menu or function exclusions and the owner can change the document, then the Requester can initiate the change request process. 

4. How can I restrict the approval process while executing the changes?
A: There is a Workflow Process PO Change Request Tolerance Check -  poxrcoa.wft where the tolerances can be set to restrict when the change needs to go to approval process or not.
In release 12 the tolerances are available in Purchasing responsibility > Setup > Tolerances and Routings.

5. Why the changed  Need By Date tolerance is not taking effect?
A: The Need By Date tolerance is in days not percentage. 

6. When attempting to change a requisition that has closed to receiving and or closed to invoicing shipment line, the change does not occur.

A:  Change profile PO: Allow Retroactive Pricing of POs  to "ALL RELEASES".  If not using encumbrance, the change process will go through.
7. Requisition change is completed and forwarded to an approver. Approver has not yet approved the change. Meanwhile, the buyer changes the purchase order and is also submitted for approval.   Approver has not yet approved the first change. 
     a. Is the requisition change approved first and then the purchase order change?
     b. Is the purchase order change approved first and then the requisition change?
    What is the approval workflow order? 

 A:  In case a. after the requisition change is approved, there will be a buyer FYI notification sent to
       buyer, and RCO workflow will end. After the PO change is approved, that PO will appear in  
       ‘Pending PO change’ ( since it has pending changes coming from requester ) and buyer can 
        respond to the change from user interface (UI). Notice in this case, buyer can not respond to 
         pending RCO through notification; he/she has to go to UI ( pending PO changes ) to respond. 
        The FYI notification serves just as a reminder. Also, PO will not appear in ‘Pending PO          
        changes’ queue until it gets approved.

       In case b. once the requisition change is approved, there will be a buyer FYI notification sent to
       buyer, and this RCO will be automatically rejected. Requester can raise the RCO again if he/she
       wants the change.

       Technically, inside the workflow, after RCO gets approved, we check ‘If PO has changed after 
        requisition change submitted’; if this is the case, RCO does not include the most updated 
        information about the PO and it is rejected by RCO.

       Also, please notice that if RCO gets approved first, and then po change request gets  
       REJECTED, the underlying RCO will get auto rejected.
8. When a buyer receives a FYI notification, should it have a note to navigate to 'Pending Purchase Order Changes' form to approve or reject the change made by Requester since the purchase order has been modified from a core application?
A:.  Currently, the buyer can receive FYI in both case (a ) and case (b).
       In case (a), there will be ‘Pending PO changes’ after the purchase order is approved. In case (b),  
       the  RCO is auto-rejected and there will not be ‘Pending PO changes’.

9. When buyer goes to 'Pending Purchase Order Changes' form, can they view the changes on the PO that they have done earlier?
A: No, they can not view the changes they did earlier.


Popular posts from this blog

SQL Query to extract Oracle Purchase Order Information

SELECT   poh.po_header_id,    poh.type_lookup_code PO_TYPE,   poh.authorization_status PO_STATUS,   poh.segment1 PO_NUMBER,   pov.vendor_name SUPPLIER_NAME,   povs.vendor_site_code Location,   hrls.location_code Ship_To,   hrlb.location_code Bill_to,   pol.line_num ,   msib.segment1 Item,   pol.unit_price,   pol.quantity,   pod.amount_billed Amount,   pod.destination_subinventory,   ppf.full_name Buyer_Name,   poh.closed_Code  FROM   PO_HEADERS_ALL poh,   PO_LINES_ALL pol,   mtl_system_items_b msib,   PO_LINE_LOCATIONS_ALL poll,   PO_DISTRIBUTIONS_ALL pod,   po_vendors pov,   po_vendor_sites_All povs,   hr_locations_all hrls,   hr_locations_all hrlb,   per_all_people_f ppf,   po_line_types polt WHERE   1                         =1 AND polt.line_type_id    = pol.line_type_id AND povs.vendor_site_id     = poh.vendor_site_id AND pov.vendor_id           = poh.vendor_id AND pol.item_id             = msib.inventory_item_id AND msib.organization_id  

Query to find Operating Unit, Business Group and Legal Entity Information

SELECT   DISTINCT   hrl . country ,                  hroutl_bg . name              bg ,                  hroutl_bg . organization_id ,                  lep . legal_entity_id ,                  lep . name                    legal_entity ,                  hroutl_ou . name              ou_name ,                  hroutl_ou . organization_id   org_id ,                  hrl . location_id ,                  hrl . location_code ,                  glev . flex_segment_value FROM     apps . xle_entity_profiles   lep ,         apps . xle_registrations   reg ,         apps . hr_locations_all   hrl ,         apps . hz_parties   hzp ,         apps . fnd_territories_vl   ter ,         apps . hr_operating_units   hro ,         apps . hr_all_organization_units_tl   hroutl_bg ,         apps . hr_all_organization_units_tl   hroutl_ou ,         hr_organization_units   gloperatingunitseo ,         apps . gl_legal_entities_bsvs   glev WHERE    lep . transacting_entity_flag   =   'Y'         AND   l

List of iExpenses Tables

List of iExpenses Tables  Table Name Description AP_EXPENSE_REPORT_HEADERS_ALL Expense report header information AP_EXPENSE_REPORT_LINES_ALL Expense report lines information AP_EXP_REPORT_DISTS_ALL Expense report distribution information. It contains the accounts against each expense report line. AP_CREDIT_CARD_TRXNS_ALL Table to store the corporate credit card transactions that are sent by the banks. These lines are saved as expense lines when the user creates the expense lines for credit cards AP_NOTES Table to store the comments entered by approvers and auditors     Setup tables   AP_EXPENSE_REPORTS_ALL This table contains the header level information about the expense templates AP_EXPENSE_REPORT_PARAMS_ALL This table contains the detail level information about the expense templates AP_POL_CAT_OPTIONS_ALL Table to store the policy options AP_POL_CONTEXT Table to store the policy context     AP_POL_LOCATIONS_TL Table