This article serves as a supplementary guide to the main article on rates, titled Issues with rates and uplifts. For other issues related to rates, please refer to that document.
Errors related to rates and rate uplifts
You may find that you are picking up errors as part of a rate uplift process be that a manual rate uplift, a standard rate uplift, a supplier rate uplift etc.
Errors from overnight finance jobs are found in the error_log table and where this is the case you will often see a little error message pop up in the corner of the rates configuration window on your Admin Tool. They can also write to this table from other screens like the Manual Uplifts screens, and Mosaic front end although the latter can also come courtesy of the framework logs.
Below is a list of recent known errors which you may also have so please check through those. If your error is not present in the list, or a dedicated KB has yet to be created then please scroll to the 'Raising a case' section below the list.
Some of the known errors are listed below:
Usually via Admin Tool:
Step: Update regular rates; p_db_message: ORA-01400: cannot insert NULL into ("FW"."AUTHORISED_COMMITMENTS"."START_DATE") Step: Cancel commitments at older rate Rate_change_id: Dedicated Article: A separate article will be provided soon.
STEP: Initial Checks; p_db_message: Rate_Change_ID: [ID is different for each case] Initial_Checks failed. Rate not created for one or more purchased service types/service bands
Dedicated Article: A separate article will be provided soon.
May point to inconsistencies between the configuration from one rate period to the next. An example of this is if in one period, there was age banding or service banding, and then in the following rate period these were not ticked. Now the system doesn't know how it will uplift service users who have these provisions still current and so will error so that this can be sorted before it comes to that bridge.
STEP: Initial Checks; p_db_message: Initial_checks failed. Rate not created for one or more Day of Week for purchased services
Dedicated KB: A separate KB will be provided soon.
Usually via Mosaic:
UncheckedFrameworkException: Failed to recreate costs for an existing purchased element : Error occurred in application.
Dedicated KB: A separate KB will be provided soon.
Raising a case
For the instances where you're picking up known errors related to rates, hopefully the dedicated KBs where they exist will help lead to a resolution.
However, if your error is not listed or a dedicated KB is not present at this point in time, then please raise a new case online and reference the title of this article. Please provide if available the following information:
A screenshot for the rates window for the element type you are trying to uplift.
A screenshot for the rates windows of the supplier if it is a supplier rate.
Any error windows that are showing and their full message.
What rate you are expecting to see pull through, and what rate is currently showing.