Referrenced RMA'S Not Interfacing To AR With Correct CUST_TRX_TYPE_ID
(Doc ID 420184.1)
Last updated on JANUARY 03, 2023
Applies to:Oracle Order Management - Version 126.96.36.199 to 188.8.131.52 [Release 11.5.10]
Information in this document applies to any platform.
On 184.108.40.206 in Production:
1.A Return Order Type is created with AR Transaction type attached.
2.RMA has been created for the Return Order Type by copy function.
3.When Auto invoice program is run , transaction(Credit Memo) is generated with a Wrong AR
Transaction type (wrong credit memo type) which is not attached to OM RMA Transaction type . In the
Receivables Interface table column CUST_TRX_TYPE_ID is populated with the AR Transaction Type
from the original Sales Order instead of the AR Transaction Type that is attached to the RMA
Expected is that In the Receivables Interface table column CUST_TRX_TYPE_ID should be populated
with the AR Transaction Type that is attached to the RMA transaction type and not from the original order from which RMA is copied.
The issue can be reproduced at will with the following steps:
1.Query a closed and invoiced Sales Order and perform the Copy function to create a new Sales Order
2. Make sure to change the OM - Transactions type to that of an RMA
3.The RMA references the original Sales Order from which it was copied.
4.Book the RMA.
5. Run Workflow Background Processor to process deferred invoice interface lines.
6. Check RA_interface_lines_all table to see value for CUST_TRX_TYPE_ID column. You would expect
it to be the AR - Transaction type which was on the RMA Transaction type but instead it will be AR - Transaction type from the original Sales Order.
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