Oracle Project Analytics for E-Business Suite includes a Project Commitments subject area that provides the ability to report on project commitments. Project commitments include total raw and burdened amounts for requisitions, purchase orders, and supplier invoices for organizations, projects, tasks, resources, suppliers, and associated hierarchies. The subject area provides the ability to track commitments at the commitment document level.
Oracle Business Analytics Warehouse includes a star schema to support the Project Commitments subject area. This star contains metrics to report on total commitments and its components, which includes quantity and amount (raw and burdened) for requisitions, purchase orders, and supplier invoices.
The W_PROJ_COMMITMENT_F fact table at the center of the star schema stores the latest commitment data, sourced from the transactional source PA_COMMITMENT_TXNS.
Configuration of Commitment Snapshot
Commitment data being transient, a snapshot table W_PROJ_COMMITMENT_SNP_F is populated. The grain of data in the snapshot table is controlled by ETL parameter PROJ_COMMITMENT_GRAIN. This parameter is set in the FSM and can have values WEEK, MONTH, QUARTER and YEAR. Example: PROJ_COMMITMENT_GRAIN = 'WEEK' would mean that the snapshot table stores one snapshot per week. So if the ETL is run multiple times within a week, the last snapshot will keep overwriting the older one until the end of the week. The Friday record will be kept, and a new record will be generated next Monday for the new week. This Grain is specified using a Task in FSM. The default is set to 'Month'.
Set the value for this variable in the FSM by navigating to Manage Data Load Parameters section'; filter for offering Oracle Project Analytics.