SQL Query To Troubleshoot Revenue Reversal For A Subscription Closed With Full Refund Method
(Doc ID 2853996.1)
Last updated on AUGUST 08, 2023
Applies to:
Oracle Fusion Subscription Management Cloud Service - Version 11.13.22.01.0 and laterInformation in this document applies to any platform.
Symptoms
On : 11.13.22.01.0 version,
ACTUAL BEHAVIOR
---------------
Revenue reversal is not happening for a Subscription closed with Full refund method when Closed Date is higher than Start Date.
Credit memo needs to be created for the full credit of NRC charges amount and FLOW THROUGH TO RMCS with a negative balance for the same amount to cancel out the amortized NRC charge.
EXPECTED BEHAVIOR
-----------------------
In RMCS Contract, Revenue reversal should happen and all values changes to 0.00.
STEPS
-----------------------
1-Identify a Subscription with products. Make sure all the products has both MRC and NRC charges.
2-Duplicate the Subscription in Subscription Management.
3-Run all ESS processes required to Interface data to AR/RMCS.
4-Navigate to SM and Close the corresponding subscription number with Full Refund, Closed Date is higher than Start Date.
5-Run all ESS processes required to Interface data to AR/RMCS.
6-Navigate to RMCS - Manage Contracts page and search for the subscription number.
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 |