My Oracle Support Banner

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:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.


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

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.



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

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