Overview

A customer wants to reset the usage of a customer account as the postpaid customer was wrongly activated with billing day set to "0". The below article provides steps to perform this action

Solution

• Open the PCRF GUI and query the SPR for the account.
  • The SQL Query to run will be:

    • select * from tblm_subscriber;

• Check for the Billing Day in the given user’s SPR.
• Change the Billing Day to the current “System date+1”. This resets the Billing Cycle from midnight.
  • You can select the option Edit to change the Billing Day from the GUI.
• Ask the customer to verify the usage on the following day as seen below:
•