5 Replies Latest reply on Feb 14, 2012 11:39 AM by wood_pusher

    RFQ and PO XSL-FO reports

    rmotiani
      Hello All,

      We are currently implementing R12 (Sourcing, Purchasing etc) for one of the customer in APAC region, and we have to modify standard
      RFQ and PO XSL-FO reports. We are able to modify XSL files.

      But if we have to add new fields, we need to modify base XML file.

      1. In case of PO, we can modify inline views. But after modifying view, how to generate new XML file which in turn will show the new fields?

      2. In case of RFQ, we didn't find any in-line view.
      We need to understand the mechanism how it works and how to change base XML file for new fields?

      Please send-in your inputs/pointers.

      Regards
      Rohit
        • 1. Re: RFQ and PO XSL-FO reports
          User781390-Oracle
          Hi Rohit,

          We are implementing same requirement for a client. Can you please let us know the technique you used to deploy your solution.

          Thanks,
          Gangadhar
          • 2. Re: RFQ and PO XSL-FO reports
            813340
            1. In case of PO, we can modify inline views. But after modifying view, how to generate new XML file which in turn will show the new fields?
            For the purpose of testing you can run the "PO Output for communication program in debug mode (test parameter as debug)", this will dump the XML and XSL in the log file.

            2. In case of RFQ, we didn't find any in-line view.
            I am not sure if you are talking of core Purchasing's RFQ or Sourcing's RFQ. Also I am not sure if you are running rdf report with XML output or if you are running the XML reports delivered in 12.1.1. Can you clarify?
            • 3. Re: RFQ and PO XSL-FO reports
              723245
              For R12
              =====

              1. In case of PO, you can modify inline views.
              After this modification, PO xml file will contain newly added fields.
              Create your custom XSLFO template for PO and attached it to PO document.

              2. In case of RFQ, you need to modify 'PON_PRINTING_PKG' package to add new fields.
              After this modification, RFQ xml file will contain newly added fields.
              Create your custom XSLFO template for RFQ and attached it to RFQ document.

              Before doing this changes keep in mind that both solutions are not advisable because you are going to update standard views and packages.

              ~ MS

              Edited by: MS on Feb 8, 2011 9:11 PM
              • 4. Re: RFQ and PO XSL-FO reports
                anasazii1
                MS,
                So there is no other way to add new fields, that would be supported by Oracle? What are the inline views that would need to be modified?

                Thanks!
                Janel
                • 5. Re: RFQ and PO XSL-FO reports
                  wood_pusher
                  Hi MS,

                  Where can i see/get/download the RFQ XML file?


                  Thanks,
                  Wood