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 AUGUST 08, 2023

Applies to:

Oracle Fusion Subscription Management Cloud Service - Version 11.13.22.01.0 and later
Information 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


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