Not Able To Deliver RMA Stuck At Awaiting Return Disposition Status / Nothing Happens After Search on RCVTXERT Form / Form Hangs (Doc ID 1620098.1)

Last updated on MARCH 07, 2019

Applies to:

Symptoms

Find specific Return Material Authorization  with line status of " Awaiting Return Disposition " cannot be delivered.
When trying to find the RMA line on RCVTXERT Receiving Transactions form nothing happens as the Find screen fails to return the RMA line and the form freezes.

Steps
The issue can be reproduced at will with the following steps:

. Navigate to Receiving / Receiving Transactions RCVTXERT form
In Find Receiving Transactions form
In Customer tab
Search for RMA Number and clik on Find Button/
Nothing happens.

. Run  HTMomse11i.sql script from <Note 133464.1> or Receiving Data Collection Script from <Note 402245.1>
See
OE_ORDER_LINES  
LINE_ID 33779202
FLOW CODE AWAITING_RETURN_DISPOS
 
RCV_TRANSACTIONS
TRANSACTION_ID PARENT_TRANSACTION_ID TRANSACTION_TYPE  TRANS_TYPE  OE_LINE_ID SRC_DOC_CODE
10759956   -1             RECEIVE    33779202 RMA
10759962   10759956  ACCEPT     33779202 RMA
10802173   10759962  CORRECT  33779202 RMA

Changes

Cause

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