TRANSACTION_ID For Receive Is Higher Than TRANSACTION_ID For Deliver In RCV_TRANSACTIONS Though Receive Happened Before Deliver (Doc ID 2061628.1)

Last updated on SEPTEMBER 30, 2015

Applies to:

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

Symptoms

After performing 'Deliver' from Mobile/telnet, It was observed that Transaction_id for 'Deliver' transaction was less than 'Receive' Transaction_id in RCV_TRANSACTIONS though both of these transactions were using the same sequence and 'Receive' transaction has definitely happened before 'Deliver' based on the 'Creation_date' timestamp.

Receiving was done from Forms and Deliver was done from Mobile Scanners.

RCV_TRANSACTIONS (may look like):

TRANSACTION_ID LAST_UPDATE_DATE REQUEST_ID TRANSACTION_TYPE TRANSACTION_DATE QUANTITY UOM SHIPMENT_HEADER_ID SHIPMENT_LINE_ID
59376402 5/25/2015 11:35 79980080 RECEIVE  5/25/2015 11:35 200 Each  46252001 47012077
59376304          5/26/2015 16:42 80090458 DELIVER          5/26/2015 16:42 200 Each  46252001 47012077

Changes

 <None>

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