3 Replies Latest reply on May 11, 2012 9:12 AM by 919822

    How to copy DFF value from FRQ to PO

    914809
      Hi,

      Please suggest how to copy DFF value entered in RFQ ( in sourcing module) to Purchase order DFF ?

      Is there any way to update/populate PO headers after PO creating engine workflow triggered with RFQ DFF values ?

      Requirement is need to maintain one common number is all related documents like Auction, RFQ, Quote and PO.

      Thanks,
      Venkat.

      Edited by: 911806 on Feb 2, 2012 2:30 AM
        • 1. Re: How to copy DFF value from FRQ to PO
          Sandeep Gandhi, Consultant
          Oracle does maintain a link between RFQ and Quote and PO if you use the TOOLS > Copy Document to convert RFQ to Quote and Quote to PO. You can see that link in the source document field.

          If you must have the same number, you can consider making numbering for these documents = MANUAL. But users typically don't like that option.

          Hope this helps,
          Sandeep Gandhi
          • 2. Re: How to copy DFF value from FRQ to PO
            PranitSaha
            Note that, RFQ and PO header share the same DFF in Oracle Applications.

            Thanks,

            PS.
            • 3. Re: How to copy DFF value from RFQ to PO
              919822
              Hi,

              When RFQ created from sourcing module, data will be stored in PO_ACUTION_HEADERS_ALL table not in po headers table. So PO DFF will be different from RFQ DFF in this case, i.e they dont share same table data.

              Now the problem is how can we copy/populate RFQ DFF values (created from sourcing module) to PO DFF when sourcing RFQ is awarded?

              I checked in PO creation code, oracle inserting only few columns into po_headers_all table from interface table. That means even we populate attribute1(2,3..) values in po headers interface table, oracle is not considering them when inserting into po headers table.

              Iis there any way to achieve this?

              Thanks,
              Venkat.

              Edited by: 916819 on May 11, 2012 2:12 AM