The way rates are uplifted via overnight jobs has been a longstanding feature, especially in the production (Prod/Live) environment.
On the Mosprod instance, rates are uplifted overnight to avoid clashing with day work done by finance staff. Attached below is the documentation you can view via the link, showing which finance jobs run overnight, what they do, and their typical schedules:
đNote: To access the link, you'll be redirected to the Access Portal.
Any uplifts that create locks in the system while work is open and in progress can risk corrupting data, which is why all rate uplift work is done in the early hours of the morning.
The overnight jobs are scheduled and configured so that they fire off the following procedures in the order as displayed below:
p_uplift_rates
apply_changed_rates
apply_charge_rates
update_rates_daily
p_weekly_suspensions
batsummary
You can uplift multiple elements overnight, but Mosaic canât handle multiple rate periods within the same element type.
You can set up multiple rate periods on an element, but youâll need to tick the âDo not apply yetâ checkbox on the later periods. You have to go âone at a time, one evening at a time,â starting with the earliest period first. The next day, that rate period will have applied overnight, and you can untick the next earliest period to apply it that night, and so on.
You can find out more on the whole rates process on Chapter 6 of the link below:
You may be able to test rates and run these procedures manually in order from a test database on your side, so you donât have to wait overnight and can run them more freely. But youâll need to request permissioned access to the test database via a new case, which our DBA team will review. This wonât be available for a Prod environment for the reasons mentioned above.
In urgent cases, if youâre a hosted customer, we may be able to run the procedures for you on test environments through a service request case sent to the support team.
If you have a large number of rates to uplift, you might want to check if the project SQL team can handle it as a project. If you want the project team to take on any specific requests, raise a new case, and weâll forward it to them for consultation and scoping.
If you need to make any requests or queries based on the information above, please raise a new case online and reference this articleâs title.