Extra COGS Recognition MMT Record Is Generated as TRANSACTION_QUANTITY:0 When Receiving RMA in Another Accounting Period (Doc ID 2147032.1)

Last updated on AUGUST 27, 2023

Applies to:

Goal

Extra COGS recognition MMT(mtl_material_transactions table) record is generated as TRANSACTION_QUANTITY:0 rarely when receiving RMA in another accounting period month.

Steps:
The issue can be reproduced rarely with the following steps:

1. Create Sales Order as Order Quantity:100, Booking, Sales Issue, AutoInvoice and COGS Recognition.
2. COGS recognition transaction(transaction type id:10008) in MMT for the Sales Issue is created as TRANSACTION_QUANTITY :-100.
3. On next month(i.e. another accounting period), create RMA for all Quantity, Booking, RMA receipt and COGS Recognition.
4. Reverse COGS recognition transaction in MMT for the RMA receipt is created as TRANSACTION_QUANTITY :100. But another COGS recognition transaction in MMT is also created as TRANSACTION_QUANTITY:0 at the same time.

Solution

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