Errored Receiving Transactions Are Not Shown In Transaction Status Summary Form

(Doc ID 2127128.1)

Last updated on OCTOBER 18, 2017

Applies to:

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

Symptoms

On :  12.1.3 version, Receiving Functions

ACTUAL BEHAVIOR  
---------------
After applying patches to install the new Enhancement Request functionality to query errored ROI transactions on the Transaction Status Summary form per the following notes:
<Note 1610656.1> - New ROI Enhancement on RCVTXVTX Transaction Status Summary Form
<Note 1610653.1> - Delete Icon Is Disabled / Greyed Out on RCVTXVTX Transaction Statuses Form For Pending / Running Transactions After RUP 7 / or Release 12.2.x

The Transactions are still not shown.


EXPECTED BEHAVIOR
-----------------------
Expect to see all errored receiving transactions that exist in the rcv_transaction_interface table to appear in the Transaction Status Summary form.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create records in the receiving interface tables (RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE)
2. Run the Receiving Transaction Processor
3. Records are in error status.
4. Navigate to the Transaction Status Summary form, do a blind query.
5. No records appears.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see all records in the form, and associated errors.

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