This KB provides guidance on how to configure the rate matrix which can help avoid issues including the below:
Release: All Supported Releases
Component: Clarity PPM Financial Management
2. Up to 10 columns can be used, but it is best practice to keep it to a minimum. This is because as the higher the number of columns are configured, the higher chance that the Rate Matrix Extraction job will experience performance issues as more projects, resources, and tasks are added over time. Available columns below (From Date and To Date are default values for all rate matrixes)
3. The rate is determined by the date range, then proceeds to funnel left to right finding a match in each column. Once the match is found, that rate is assigned in the NBI_PROJ_RES_RATES_AND_COSTS table. That is why it is important to test rates and costs via the project > Financial Plans page to see if the correct rate is being retrieved before running the full Rate Matrix Extraction (with parameters Extract for Schedulers, Update, Prepare)
4. The rate matrix provides real-time rates to cost plans and the Post Transactions to Financials job, and Create WIP Adjustment.
See KB: MSP Rates missing: too many rates in NBI table that seem redundant with same rate different dates
See KB: Rate Matrix Extraction Job Performance - Rate Matrix Job Performance