R12 OPM Partial RMA Brings Full Qty Of COGS Rec. Percent Adjustment Instead Of RMA Qty (Doc ID 2164889.1)

Last updated on SEPTEMBER 21, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
SO issue (om_line_id 3134318) : -6000 units on 5/19/2016
SO issue (om_line_id 3143286) : -30 units on 5/27/2016 (replacement for defective product)
RMA receipt (om_line_id 3143292) : 30 units on 6/1/2016 (no credit memo for defective product)

Partial RMA Brings Full Qty of COGS Rec. Percent Adjustment instead of RMA, data in gmf_xla_extract_headers:
EVENT_ID ENTITY_CODE EVENT_CLASS_CODE EVENT_TYPE_CODE TRANSACTION_ID TRANSACTION_DATE TRANSACTION_QUANTITY
4939141 ORDERMANAGEMENT SHIPPING COGS_RECOGNITION 7163173 2016-5-19 6000
4929455 INVENTORY SUBINV_XFER SO_STAGING_XFER 7090742 2016-5-19 -6000
5031783 ORDERMANAGEMENT SHIPPING COGS_RECOGNITION_ADJ 7163678 2016-6-1 6000
4938741 ORDERMANAGEMENT SHIPPING SO_ISSUE 7091038 2016-5-19 -6000
4929245 INVENTORY SUBINV_XFER SO_STAGING_XFER 7139364 2016-5-27 -30
4939348 ORDERMANAGEMENT SHIPPING COGS_RECOGNITION 7166109 2016-5-27 30
4940586 ORDERMANAGEMENT SHIPPING SO_ISSUE 7139478 2016-5-27 -30

EXPECTED BEHAVIOR
Event of COGS_RECOGNITION_ADJ should only impact RMA quantity instead of whole original SO Issue quantity.

STEPS
The issue can be reproduced at will with the following steps:
1.) Transactions
SO issue (om_line_id 3134318) : -6000 units on 5/19/2016, this sales order is billed fully.
SO issue (om_line_id 3143286) : -30 units on 5/27/2016 (replacement for defective product)
RMA receipt (om_line_id 3143292) : 30 units on 6/1/2016 (no credit memo for defective product), referenced to the first Sales Order
2.) Run Actual Cost Process and Cost Update in OPM Costing
3.) Run 3 cogs program at the end of period
Record Order Management Transactions
Collect Revenue Recognition Information
Generate COGS Recognition Events
4.) Run OPM Accounting Pre-Processor, and Create Accounting
5.) Found the issue.

Cause

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