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

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
Goal
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.