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 MARCH 08, 2017

Applies to:

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

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms