0 Replies Latest reply on Feb 3, 2015 12:01 PM by user12863742

    For only 'Deliver' transaction when one step receiving is done.

    user12863742

      Hello,

       

      per clients business process, client performs one step receiving transaction manually.

      So this act produces 'Receive' entry in rcv_transactions table. So technically now we want to perform only 'Deliver' transaction.

      So, per Oracle Note 731097.1, I only populated rcv_transactions_interface table and didn't populated rcv_header_transaction table.

      Now,

      After population of a test record in rcv_transactions_interface I ran 'Receiving transaction processor.'

      Every time I run the program, it isn't processing the record[ PROCESSING_STATUS_CODE - ERROR].

      When checked in PO_INTERFACE_ERRORS table, following error I'm getting;

      "Error: The SOURCE_DOCUMENT_CODE specified is invalid.  The value specified (PO) does not match the expected value (INVENTORY)."

      Where as actually my SOURCE_DOCUMENT_CODE is PO.


      Here is the insert statement for reference;

      INSERT INTO rcv_transactions_interface

                  (interface_transaction_id, parent_transaction_id, GROUP_ID,

                   last_update_date, last_updated_by, creation_date, created_by,

                   last_update_login, transaction_type, transaction_date,

                   processing_status_code, processing_mode_code,

                   transaction_status_code, po_header_id, po_line_id, item_id,

                   quantity, unit_of_measure, po_line_location_id,

                   auto_transact_code, receipt_source_code, to_organization_code,

                   source_document_code, header_interface_id, validation_flag,

                   org_id, subinventory, locator_id

                  )

           VALUES (585715, 662634,185818,

                   SYSDATE, 3625, SYSDATE, 3625,

                   0, 'DELIVER', SYSDATE,

                   'PENDING', 'BATCH',

                   'PENDING', 379023, 491608, 3,

                   10, 'EACH', 483726,

                   'DELIVER', 'VENDOR', 'K04',

                   'PO', NULL, 'Y',

                   82, 'DMATERIAL', 8

                  );

       

      Can anyone please guide me How shall I over come this error?

       

      -SaurabhDJ