My Oracle Support Banner

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 11.5.10.2 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

On 11.5.10.2 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
transaction type.


EXPECTED BEHAVIOR
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.


STEPS
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.

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.