Check the below -
Document ID: TEC551863
Tech Document
Title: Clarity: How Should I Use The New Incremental Only Option For The Rate Matrix Extraction Job?
Description:
After applying the latest generic patch for 12.0.6 there is now an additional parameter "Incremental Only" for the Rate Matrix Extraction job, what does it do and how should it be used?
Solution:
The following subset of options are part of the job existing from older versions (12.0.6 base and prior):
Prepare rate matrix data - this only generates all pertinent records and puts it into a temporary table so the update can happen during non-production time.
Update rate matrix data - this just truncates the nbi_proj_res_rates_and_costs table and copies all records over from the temp table that got generated during Prepare.
With the latest generic patch on 12.0.6 a new job parameter called "Incremental Update Only" will be available when running the job
If the "Incremental Update Only" option is checked along with the Prepare and Update options, "Prepare rate matrix data" option will only pick the project if and only if any of the following is true after the last successful job run:
The project is active.
The project is updated. (* Based on Last Updated Date Field)
One or more tasks of the project are updated.
One or more team members are added or changed.
One or more assignments are added or changed.
One or more matrix associations within the project, changes (labor/material/expense/equipment - rate and cost source settings in the project's financial page)
One or more associated matrices change.
The entity associated with the project changes.
The matrix that is associated with the project's entity changes.
The Transaction Entry defaults change (System wide rate matrix setting).
Any matrix associated with the Transaction Entry Defaults changes.
Financial information of one or more team members on the project changes. (resource financials)
The following conditions will not trigger the RME to include the project:
The project is inactive.
One or more team members are deleted (removed).
One or more assignments are deleted(removed).
The matrix is deleted.
One or more resources attached to the project are deleted.
A full run will handle deleted tasks/resources/team members/assignments
Bottom Line:
Typically, you would run a 'full' extraction where all rates will be re-extracted by selection only the first 3 options and not selecting the Incremental Only option. If the 'full' extraction doesn't take too long to complete, you can ignore the 'Incremental Only' option.
This option is to be used to only update new changes made to rate matrix definition, so that the run time is shorter than the typical 'full' run. This option is useful if you have a large set of financial data (projects, resources, transactions, matrices, etc). If you have a large amount of financial data, the full run takes a long time (many hours) and rates get changed frequently, yet your users need new rates right away during the day, running the job with this option (with all 4 options checked) during the day would shorten the run time and impact users. Then during off hours you can set up another schedule to do a full run (without the Incremental Only option checked).
* NOTE: * If the 'Investment Allocation' job is executed in between incremental runs of the Rate Matrix Extraction, the Incremental Option will effectively behave in the same manner as a full execution because the 'Investment Allocation' job will update all projects. Please refer to the other technical articles mentioned below for more information on performance and the Investment Allocation job.
Further Readings:
Document ID: TEC439334
Title: On the 'Rate Matrix Extraction' job page, what do the parameters 'Prepare Rate Matrix Data' and 'Update Rate Matrix Data' do
Document ID: TEC439203
Title: On the 'Rate Matrix Extraction' job page, what does the parameter 'Extract Cost and Rate Information for the Scheduler' do
Document ID: TEC520261
Title: Clarity: Basic Steps to Improve Rate Matrix Extraction Job Performance
Document ID: TEC510858
Title: How often should I run the Investment Allocation Job?
NJ