2 Replies Latest reply: Feb 15, 2013 12:06 AM by 991015 RSS

    not able to create ASBN with payable Invoice

    991015
      Hello All,

      I am trying to create ASBN with the following details.

      RCV_Header_Interface.Transaction_type = 'NEW' and
      RCV_Header_Interface.Auto_transact_code = 'SHIP'

      RCV_Transactions_Interface.Transaction_type = 'SHIP' and
      RCV_Transactions_Interface.Auto_transact_code ='DELIVER'

      This is creating Shipping, Receive and Delivery transactions. However, Payables Invoice is not created.

      Please help.

      Thanks & Regards
      SM.
        • 1. Re: not able to create ASBN with payable Invoice
          Mahendra
          See if the below note..

          ASBN With Deliver Transaction Does Not Create Invoices [ID 742044.1]

          Mahendra
          • 2. Re: not able to create ASBN with payable Invoice
            991015
            Hi Mahendra

            Thanks for your quick response.

            However I am getting error while trying to populate the RCV_Headers_Interface and RCV_Transactions_Interface tables for the second time.
            My (2nd time) insert statements with ASBN related data as below :

            INSERT INTO RCV_HEADERS_INTERFACE
            (HEADER_INTERFACE_ID,
            GROUP_ID,
            PROCESSING_STATUS_CODE,
            RECEIPT_SOURCE_CODE,
            TRANSACTION_TYPE,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            CREATION_DATE,
            CREATED_BY,
            SHIPPED_DATE,
            VENDOR_NAME,
            EMPLOYEE_NAME,
            VALIDATION_FLAG,
            SHIP_TO_ORGANIZATION_ID,
            EXPECTED_RECEIPT_DATE,
            SHIPMENT_NUM,
            ASN_TYPE,
            AUTO_TRANSACT_CODE,
            INVOICE_NUM,
            INVOICE_DATE,
            TOTAL_INVOICE_AMOUNT))
            SELECT
            RCV_HEADERS_INTERFACE_S.NEXTVAL,
            RCV_INTERFACE_GROUPS_S.NEXTVAL,
            'PENDING',
            'VENDOR',
            'NEW',
            SYSDATE,
            0,
            SYSDATE,
            0,
            SYSDATE,
            'ABC Corp',
            'Emp123',
            'Y',
            6190,
            SYSDATE + 5,
            'TestASBN42.1',
            'ASBN',
            'SHIP',
            'TestASBN42.1',
            TRUNC (SYSDATE),
            13.62
            from dual;


            INSERT INTO RCV_TRANSACTIONS_INTERFACE
            (INTERFACE_TRANSACTION_ID,
            HEADER_INTERFACE_ID,
            GROUP_ID,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            CREATION_DATE,
            CREATED_BY,
            TRANSACTION_TYPE,
            TRANSACTION_DATE,
            PROCESSING_STATUS_CODE,
            PROCESSING_MODE_CODE,
            TRANSACTION_STATUS_CODE,
            QUANTITY,
            UOM_CODE,
            AUTO_TRANSACT_CODE,
            RECEIPT_SOURCE_CODE,
            SOURCE_DOCUMENT_CODE,
            DOCUMENT_NUM,
            DOCUMENT_LINE_NUM,
            SHIP_TO_LOCATION_id,
            NOTICE_UNIT_PRICE,
            VALIDATION_FLAG,
            TO_ORGANIZATION_id,
            ITEM_NUM)
            SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
            RCV_HEADERS_INTERFACE_S.CURRVAL,
            RCV_INTERFACE_GROUPS_S.CURRVAL,
            SYSDATE,
            0,
            SYSDATE,
            0,
            'SHIP',
            SYSDATE,
            'PENDING',
            'BATCH',
            'PENDING',
            1,
            'CA',
            'SHIP',
            'VENDOR',
            'PO',
            '300169',
            '1',
            146220, -- 'ship to location'
            13.62,
            'Y',
            204,
            '0905'
            FROM DUAL;

            The error : PO Shipment (NUMBER = 1) is not open.

            Please help.

            Regards
            SM.