2 Replies Latest reply: Jan 29, 2013 4:46 AM by 984976 RSS

    No requisitions were created

    984976
      Hey

      I used this script:

      INSERT INTO PO_REQUISITIONS_INTERFACE_ALL (INTERFACE_SOURCE_CODE,
      ORG_ID,
      DESTINATION_TYPE_CODE,
      AUTHORIZATION_STATUS,
      PREPARER_ID,
      CHARGE_ACCOUNT_ID,
      SOURCE_TYPE_CODE,
      UNIT_OF_MEASURE,
      LINE_TYPE_ID,
                               ITEM_DESCRIPTION,
      QUANTITY,
      DESTINATION_ORGANIZATION_ID,
      DELIVER_TO_LOCATION_ID,
      DELIVER_TO_REQUESTOR_ID,
      ITEM_ID,
      NEED_BY_DATE)
      VALUES ('EAM',
      81,
      'EXPENSE',
      'INCOMPLETE',
      681,
      4000,
      'VENDOR',
      'Couple',
      1200,
           'Test',
      1,
      186,
      525,
      219,
      13002,
      SYSDATE + 2
      );

      Row is inserted into table, but when I use Requisition Import Program, request completed and I get:

      Requisition Import Run Report Date: 28-JAN-13
      -------------------------------------------------

      No requisitions were created
      Number of interface lines in error = 0

      -------------------------------------------------

      End of Report

      Requisition Import Exception returns:

      Transaction Column Name Error Message
      ------------ ------------------ ---------------------------------------


      ***** No Data Found *****



      What can be a problem?

      Best regards,

      Matej

      Edited by: 981973 on 28.1.2013 7:36
        • 1. Re: No requisitions were created
          Sanjay Desai
          Hi,

          check whether any error exists in table : PO_INTERFACE_ERRORS ?

          Ensure that whether Distribution interface tables : PO_REQ_DIST_INTERFACE_ALL , required to populate or not ?

          Also, check the following link.

          http://www.oracleappshub.com/oracle-purchasing/what-is-in-requisition-import/
          http://oracleappsdetails.blogspot.in/2009/10/requisition-open-interface.html
          http://www.confluentminds.com/Trainings/SCM/Topic1.1_Ch1_Part4.html

          regards
          Sanjay
          • 2. Re: No requisitions were created
            984976
            There are no errors in table PO_INTERFACE_ERRORS.

            I set GroupBy All in Group-By method in the Default region.

            Customer is also associate with deliver to location.

            When I try to submit a request to run the Requisition Import and when I try to select from the list of values in the parameter field for Import Source, I do not find any value and receive the error message: "List of Values contains No Entries ". The field INTERFACE_SOURCE_CODE in interface table is populated.

            Best regards,
            Matej