3 Replies Latest reply on Jan 18, 2011 11:36 AM by 832049

    Partial PO Requisition Import

    Rishi-Agrawal-Oracle
      Gurus,

      Is ther any way to control import of requisition lines only when complete group is valid. In my case I am using group by as ALL and out of 5 lines 3 lines are imported and group under one requistion but 2 are left out due to some error.

      I was these 2 should be added to already imported requisition wth 3 lines or none of 5 lines should be imported.

      Any ideas???

      Thanks
        • 1. Re: Partial PO Requisition Import
          S.PDASH
          Hi,
          Welcome to forum !!!

          Your question - 1 --> : Is ther any way to control import of requisition lines only when complete group is valid. In my case I am using group by as ALL and out of 5 lines 3 lines are imported and group under one requistion but 2 are left out due to some error.

          Ans : We believe this is not possible through oracle standard program... You can customize requsition import program and import requistions once all the requsition lines are valid, else reject the whole batch.

          You can check the requistion exception reports to get info on failed requistion lines.
          e.g. sample of requistion import report is as below...

          ==============================================
          Requisition Import Exceptions Report Report Da: 14-APR-2010
          test by 11g team Page : 1 of **
          EU_SW6_SEK
          Report Parameters
          Import Source:
          Import Batch :
          Delete Except: No

          Transaction Column Name Error Message
          ------------ ------------------ ---------------------------------------
          813 ITEM_ID Item is missing, invalid, or not stock-
          enabled for the source organization

          Cause: The item is missing,
          invalid or not stock-enabled for the
          source organization. The item is
          required for a source type of
          'INVENTORY'.

          Action: Enter a valid, stock-
          enabled item for the source
          organization.


          Hope this will help.

          Regards,
          S.P DASH
          • 2. Re: Partial PO Requisition Import
            Rishi-Agrawal-Oracle
            I have done it by putting my custom logic in PO_REQIMP_PKG package. Code in this package will be executed after all seeded validations are over.
            • 3. Re: Partial PO Requisition Import
              832049
              Hi,

              Could you please let me know on how to compile this custom hook (po_reqimp_pkg)?

              Thank you in advance.