A process creating a new Cost Plan. Cost Plan properties: Name Cost Plan created on: yyyy/mm/dd hh:mm:ss Grouping attributes Charge Code, Transaction Type Start Period The earliest fiscal period with Actuals (from PPA_WIP table) or current period, if there are no actuals Finish Period The latest fiscal period with a non-zero allocation (from PRJ_BLB_SLICES table, SLICE_REQUEST_ID = 6 Period Type Monthly Plan of Record True Planned Cost For periods in the past – from Actuals (Charge Code, Transaction Type, Quantity (Units), Cost (Amount) taken from Transactions (PPA_WIP & PPA_WIP_DETAILS); For current and future periods – from Allocations (Charge Code taken from the Project, Transaction Class from the Resource, Quantity from allocation slices, Cost from the Rate Matrix (NBI_PROJ_RES_RATES_AND_COSTS table) Pre-conditions: the Project must be financially enabled. if a new Team Member is added, Rate Matrix job must be run, so the rates are populated in the NBI table. if the Allocation changes, allow the timeslice job to finish before running the process. the Project should have the Charge Code set.

View Rate Matrix is a grid portlet that provides users a single place to view all the rates defined across multiple rate matrix without going to administration tab. Each Matrix may be defined with different columns (ex: Charge Code, Client, Department, Entity, Input type Code etc). This portlet dynamically brings only the columns associated with that rate matrix and provides the detailed information. User can view information related to one matrix at a time.

The Populate Prior Periods Forecast From Actuals in Cost Plans process updates Cost Plans for Active Projects, it updates the Forecast for previous months = Posted Actuals, to remove variances from past periods.   This is an On Demand process in Clarity named Populate Prior Periods Forecast From Actuals in Cost Plans and can be manually executed from the Organizer or scheduled through the “Execute a Process” job. If there are number of processes in the Organizer – Available Processes, this process can be filtered and then checked to Start. When the process is started it will be seen in the Initiated on the Processes tab. The process status can be monitored from Running to the Completed stage. The process is very flexible and supports Cost Plans with any given grouping and it also works without any dependency on timeslices or other jobs. The process fetches Cost plan of records for all active projects in the system that have Actuals transactions in WIP table. It then process those cost plans to update all of the prior monthly forecast periods with the corresponding monthly Actuals.

“Resources with No Basic Matrix Entry” portlet displays combinations of project and resource where the assigned resource does or does not have a rate established for that project.  Portlet is filterable by Projects, Project ID, Resources, and Missing Rate (Yes, No, All). How does this work?  The Rate Matrix Extraction job populates a record into the NBI_PROJ_RES_RATES_AND_COSTS table for every resource/project combination that meets any of the rate matrix criteria.  This portlet checks that table, and sets the Missing Rate attribu