My Oracle Support Banner

RCV_TRANSACTIONS.Reason_Id Is Populated Even if RCV_TRANSACTIONS_INTERFACE.Reason_Id Is Null When Receiving IOT Through ROI. (Doc ID 2592776.1)

Last updated on SEPTEMBER 25, 2019

Applies to:

Oracle Inventory Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Actual Behavior
RCV_TRANSACTIONS.Reason_Id Is Populated Even if RCV_TRANSACTIONS_INTERFACE.Reason_Id Is Null When Receiving IOT Through ROI.

Expected Behavior
RCV_TRANSACTIONS.Reason_Id Should Be Null if RCV_TRANSACTIONS_INTERFACE.Reason_Id Is Null When Receiving IOT Through ROI.

Steps to Reproduce

  1. At Source Org, perform IOT Shipment
    Enter Reason and then save.

  2. At Destination Org, insert records into RHI and RTI
    RTI.Reason_Id is null.

  3. Run RTP

  4. See RCV_TRANSACTIONS.Reason_Id is populated.

    It is showing different behavior if doing receiving by Form:
  5. Perform receipt through Receipts form in any of Batch, Immediate and Online modes.
    Leave Reason field as null.

  6. RCV_TRANSACTIONS.Reason_Id is NOT populated.

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.