Self Service Procurement

Get Involved. Join the Conversation.

Topic

    Ashok
    Quick Tip: Can you copy Requisition DFFs to a Purchase Order
    Topic posted February 21, 2019 by AshokBlack Diamond: 60,000+ Points, tagged FAQ, Requisition Processing, Tip 
    332 Views, 6 Comments
    Title:
    Quick Tip: Can you copy Requisition DFFs to a Purchase Order
    Summary:
    Can you copy descriptive flexfields from a requisition to a purchase order?
    Content:

    Support and Customers

    Just this last week, I have noted at least 2 occasions where this question was brought up:

    a) Can we copy requisition DFF values to a purchase order

    b) Can we group requisitions / requisition lines when doing so?

    The answers in summary are a) Yes and b) No.

    NOTE: This is Purchasing functionality per se. I am providing references to illustrate the concept because these questions I felt were worth addressing through an article albeit in Self Service Procurement.

    Here are some additional details that I have culled out from the Purchasing documentation.

    A. This table lists the profile options you can use to control the copying of descriptive flexfields from requisitions to purchase orders.

    Profile Option Code

    Profile Option Name

    Description

    PO_COPY_REQ_HDR_DFF_TO_PO

    Requisition Header Descriptive Flexfields Copied to Purchase Order Headers

    Enable descriptive flexfields to be copied from a requisition header to the corresponding purchase order header.

    PO_COPY_REQ_LINE_DFF_TO_PO

    Requisition Line Descriptive Flexfields Copied to Purchase Order Lines

    Enable descriptive flexfields to be copied from a requisition line to the corresponding purchase order line.

    PO_COPY_REQ__DFF_TO_PO

    Requisition Distribution Descriptive Flexfields Copied to Purchase Order Distributions

    Enable descriptive flexfields to be copied from a requisition distribution to the corresponding purchase order distribution.

    B. When you enable these profile options:

    • Copying of descriptive flexfields is enabled in the automated and manual requisition to purchase order creation flows.

    • Grouping of requisitions and requisition lines on a purchase order is prevented.

    • If either the header profile (PO_COPY_REQ_HDR_DFF_TO_PO) or the line profile (PO_COPY_REQ_LINE_DFF_TO_PO) is set, requisition line grouping is prevented.

    • If the header profile (PO_COPY_REQ_HDR_DFF_TO_PO) is not set, requisition grouping is allowed.

    • Grouping requisition lines on a single PO line is prevented in all cases

     

    Comment

     

    • Ramesh Radhakrishnan

      Thanks Ashok. We implemented this functionality after the 18B upgrade and business is happy with this automation.

      • s k

        Hi Ramesh,

        I created a DFF at requisition distribution level.

        On requisition it is visible and we are populating values.

        The profile option PO_COPY_REQ_DFF_TO_PO is set to YES at site level.

        I cannot see the DFF information on the Purchase order distribution.

        Do i need to do any mapping between Purchase order  and requisition descriptive flexfields ?

        Thanks in advance

         

    • Sridhar Tumati

      Hi Ashok,

      Thanks for sharing the information.

      Regards,

      Sridhar

    • Aditya Singh

      Hi Ashok,

      Thank you for sharing the document, usually many customer are having this type of requirement.

      Also Adding to your point just a note I want to add in this document.

      For requisition you can't directly see the DFF after doing the setup in Manage Descriptive Flexfields.

      You have to go into Sandbox mode and enable those fields on enter requisition page to see the changes.

      Also if you can transfer the Same DFF to AP Invoice although this is enabled for only Req distribution DFF.

      Thanks

      Aditya Singh

    • s k

      Hello Gurus,

      Please confirm, if we can transfer the Purchase order DFFs to Invoices and then to Assets ?

      If it is possible, please let us know how.

      Thank you

    • Ashok

      M K

      I would advise you to post this question on the Purchasing forum: https://cloudcustomerconnect.oracle.com/resources/0920f58093/summary

      They are best equipped to guide you as appropriate.