My Oracle Support Banner

Deferred Cogs Balance Is Not Clearing After The Revenue Recognition (Doc ID 2442659.1)

Last updated on APRIL 04, 2020

Applies to:

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

Symptoms

Deferred cogs balance is not clearing after the revenue recognition in average costing organization.

First user performed Sales Order ship issue for Qty:100.
Then entered RMA for the SO line for Qty:-1.

As the results, COGS recognition was generated as 100 qty correctly, but return of COGS Recognition was also generated as 100 qty.
Customer think since the RMA Order is created for partial quantity, system should revers only the RMA order value.

MTL_MATERIAL_TRANSACTIONS for COGS return

MTL_MATERIAL_TRANSACTIONS
TRANSACTION_ID
Qty
ACCT_LINE_TYPE TRX_DATE
15670620 -100 35(COGS) 01-JUL-18
15670620 100 36(DCOGS) 01-JUL-18


According to CST_COGS_EVENTS table Data in the output of COGS_Diagnose.sql,
EVENT_TYPE: COGS Rec. Percentage Adjustment and RMA Placeholder are generated as EVENT_QUANTITY:100 on Trx date of RMA.

CST_COGS_EVENTS
EVENT_TYPE EVENT_DATE COGS_PERCENTAGE EVENT_QUANTITY CREATION_DATE
SO Issue 28-JUN-2018 00 : 17 : 38 0 100 08-JUL-2018 08 : 56 : 04
RMA Receipt 01-JUL-2018 19 : 54 : 00 0 -5 08-JUL-2018 08 : 56 : 15
COGS Recognition 28-JUN-2018 23 : 59 : 59 1 100 08-JUL-2018 08 : 57 : 58
COGS Rec. Percentage Adjustment 01-JUL-2018 19 : 54 : 00 0 100 08-JUL-2018 08 : 57 : 58
RMA Placeholder 01-JUL-2018 19 : 54 : 00 0 100 08-JUL-2018 08 : 56 : 15


Is the behavior of RMA as partial quantity a intended behavior?

Steps:

  1. Create Sales Order and shipment
  2. Create RMA

Cause

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
Symptoms
Cause
Solution
References


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