3 Replies Latest reply on May 25, 2016 3:43 PM by J Reinhart

    Requisition Import and  PO_REQUISITIONS_INTERFACE_ALL

    SQL_Users

      Hello,

       

      I have noticed that after successful importof Requisition Import, PO_REQUISITIONS_INTERFACE_ALL table is getting deleted.

       

      How can I make sure that PO_REQUISITIONS_INTERFACE_ALL will have records evenafter successful importof Requisition Import.

       

      Appreciate any insight.

       

      Regards

       

      PranitSaha

      J Reinhart

      Jagadekara

        • 1. Re: Requisition Import and  PO_REQUISITIONS_INTERFACE_ALL
          J Reinhart

          Requisition Import clears the table of successfully imported records.  You could turn on auditing on the table, but if you have a high volume of records, that could have a performance impact.   Another idea is to write an alert to copy the requisitions to a custom backup table (test for possible performance impacts on this as well)

          1 person found this helpful
          • 2. Re: Requisition Import and  PO_REQUISITIONS_INTERFACE_ALL
            SQL_Users

            In of the instance,PO_REQUISITIONS_INTERFACE_ALL table is getting purged in every 5 minutes.

             

            Any idea what could be the reason?

             

            Regards

            • 3. Re: Requisition Import and  PO_REQUISITIONS_INTERFACE_ALL
              J Reinhart

              Hi Chacks,

               

              If its being cleared every 5 minutes, chances are there's a concurrent request that's running, and restarting itself every 5 minutes.   In your concurrent manager, query for %Purge% to check for all purges that may be out there.   If you find one running or pending, check the parameters for repeating itself.    Purge Purchasing Open Interface Processed Data is one you can check for, but if there's one purge out there, other modules may have similar things running, so I like to check in general.

               

              Similarly, if Requisition Import is set to run every 5 minutes, it would clear the table after importing.

               

              Another to check for is Requisition Import Exceptions Report -- this one has a parameter for clearing the interface tables.

               

              If none of that works, have your sys admin check for anything that's running every 2-10 minutes.  They can check for requests set to repeat themselves a few minutes after they start, after they finish, based on clock time, etc.   If you have Inventory, Cost Manager may be running every few minutes, and that's fine, its costing your inventory transactions and you want that to be frequent.   There can be other things that you want to run that often, but the list of things that do run that often shouldn't be very long.   Review everything on the list, and see if you find what's clearing your interface. 

               

              Regards,

               

              J  


              .