My Oracle Support Banner

SQL Query To Troubleshoot Revenue Reversal For A Subscription Closed With Full Refund Method (Doc ID 2853996.1)

Last updated on MARCH 08, 2022

Applies to:

Oracle Fusion Subscription Management Cloud Service - Version and later
Information in this document applies to any platform.


On : version,


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.


In RMCS Contract, Revenue reversal should happen and all values changes to 0.00.


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.


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

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