Deferred Cogs Balance Is Not Clearing After The Revenue Recognition
(Doc ID 2442659.1)
Last updated on AUGUST 27, 2023
Applies to:
Oracle Cost Management - Version 12.1.3 and laterInformation 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
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.
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:
- Create Sales Order and shipment
- 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 |