Correct Receiving With ROI and Correcting Form Have Different MTL_TRANSACTION_LOT_NUMBERS Records (Doc ID 2048235.1)

Last updated on DECEMBER 08, 2015

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Problem Statement
Correct Receiving Transaction with Receiving Open Interface, MTL_TRANSACTION_LOT_NUMBERS data difference with correcting standard form.

Actual Behavior
  Correct Receiving Transaction with ROI
  ------------------------
    There are two records in MTL_TRANSACTION_LOT_NUMBERS
    Record 1, transaction_source_id is not null, transaction_quantity is minus value
    Record 2, transaction_source_id is null, transaction_quantity is plus value and transaction_source_name = 'PO'

  In the Correcting Form
  ------------------------
    There is only one record in MTL_TRANSACTION_LOT_NUMBERS
    Record 1, transaction_source_id is not null, transaction_quantity is minus value

Expected Behavior
  Do not create transaction_source_id is null, transaction_quantity is plus value and transaction_source_name = 'PO' record

Steps to Reproduce

  1. Create a PO with a LOT control item
  2. Receive and delivery it
  3. Insert RCV_TRANSACTIONS_INTERFACE and MTL_TRANSACTION_LOTS_INTERFACE data (correct delivery)
  4. Run the receiving transaction processor
  5. Confirm MTL_TRANSACTION_LOT_NUMBERS
    transaction_source_id is not null, transaction_quantity = -1, that is correct
  6. Insert RCV_TRANSACTIONS_INTERFACE and MTL_TRANSACTION_LOTS_INTERFACE data (correct receiving)
  7. Run the receiving transaction processor
  8. Confirm MTL_TRANSACTION_LOT_NUMBERS
    1) transaction_source_id is not null, transaction_quantity = -1
    2) transaction_source_id is null, transaction_quantity = 1 and transaction_source_name = 'PO'       -- this is difference record with Correcting form

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms