5 Replies Latest reply on Jun 23, 2016 4:50 PM by JK2008

    PO Change History of Header amount

    JK2008

      User is requesting updates to the Standard PO Change History report that we will have to customized. What tables will the following be stored:

      Creation Date of PO

      Revision Date of Revision #

      PO Total

       

      The user is especially wanting to see the change history of the PO Header total. When I look at the Oracle Standard report, that is coming from a temp table. Is there an archived table that stores the header? I looked at PO_LINES_ARCHIVE_ALL and PO_HEADERS_ARCHIVE_ALL and I don't see where I can view the PO Header total of the PO at a specific Revision.

       

      Please advise.

        • 1. Re: PO Change History of Header amount
          Sergio F Oliveira

          Hi,

           

          I am assuming you are referring to a Standard Purchase Order. If this is the case, the PO total amount is not stored on the base table PO_HEADERS_ALL, hence you cannot find it on the archive table as well.

          The PO Header total amount is the sum of all lines amount. You cannot track the total amount at header level, because it simply does not exist. What you can track is the amount changes at line level.

           

          I hope it helps.

           

          Regards,

          Sergio.

          • 2. Re: PO Change History of Header amount
            JK2008

            Do you know the table where the amount changes at line level are tracked?  Is it stamped with a revision number?  I can then use that to sum up those lines at a certain revision number to get the PO Header at a certain point of time.

             

            Thanks,

            Jill

            • 3. Re: PO Change History of Header amount
              anasazii

              assuming you are archiving, the 4 main po tables also have corresponding archive tables

               

              Headers: po_headers_all - po_headers_archive_all

              Lines: po_lines_all - po_lines_archive_all

              Shipments: po_line_locations_all - po_line_locations_archive_all (summing price_override * quantity for all your uncanceled shipments here would get you total amount, based on your revision_num)

              Distributions: po_distributions_all - po_distributions_archive_all

              Releases (if you use): po_releases_all - po_releases_archive_all

               

              Each of the archive tables have REVISION_NUM as a column so you can link using that and the po_header_id to gather data for each revision. 

              I think for the header table the LATEST_EXTERNAL_FLAG = 'Y' is the most recent change.

              another thing to keep in mind - creation date of the header might be different from creation date of the lines/shipments so be sure to ask your user which date they want to drive the report.

              • 4. Re: PO Change History of Header amount
                JK2008

                Thank you for all of your information, especially the last point about checking the creation date of the header vs the lines.  Do you think it possible to sort the query (to support the report) by Revision Date? 

                • 5. Re: PO Change History of Header amount
                  JK2008

                  I do see Revised_date on the PO Header