Labor Commitment Reporting in OTBI
This topic explains how enhanced OTBI reporting attributes support analysis of labor commitments and liquidation activity, comparison of commitments with actual labor costs, tracing of labor distributions, and improved visibility into project labor obligations for planning and cost control.
Use Oracle Transactional Business Intelligence (OTBI) to report on labor commitment information for project planning and control. These reporting attributes help you analyze future labor commitments, commitment liquidation, and related labor distribution costs so you can validate project spend and manage labor-related project costs more effectively.
These enhancements extend existing OTBI subject areas with additional labor commitment, payroll, person, assignment, and job attributes. You can use this data to compare labor commitments with actual costs and improve visibility into project labor obligations.
What is included
The following OTBI subject areas are enhanced for labor commitment reporting:
Projects – Labor Distribution Cost Analysis Real Time
In the Labor Cost Distribution Details folder, add:
- Commitment Transaction ID
- Liquidation
Project Costing Commitments Real Time
Add labor commitment and person-related attributes, including:
- Assignment ID
- Assignment Name
- Assignment Number
- Cost Action ID
- Cost Action Type
- Cost Allocation Key Flex ID
- Funds Status
- Job
- Job ID
- Labor Distribution Original Transaction Reference
- Payroll ID
- Payroll Name
- Pay Element
- Pay Element ID
- Person ID
- Person Name
- Person Number
- Person Type
- Adjusting Item
- Liquidation Flag
How these attributes help
Use these reporting attributes in OTBI analyses to:
- Identify labor commitment transactions
- Review liquidation activity
- Analyze commitments by employee, assignment, payroll, job, and pay element
- Compare commitment data with actual labor cost reporting
- Trace distributed costs back to their source commitment transactions
Examples
You can use these attributes to create analyses such as:
- Labor commitment trends by project and period
- Commitment liquidation reporting
- Commitment analysis by employee and assignment
- Payroll-based labor commitment reporting
- Comparison of labor commitments with actual costs
Access Requirements
Use the existing privileges required for labor distribution and commitment reporting. Access to the reporting data is controlled by the current OTBI subject-area privileges and related labor distribution access privileges.
Tips and Considerations
- Use the Liquidation or Liquidation Flag attributes to identify liquidation activity in reports.
- Use person, assignment, payroll, job, and pay element attributes to analyze commitments in detail.
- Compare labor commitment data with actual labor cost reporting to improve planning and control.
- Review the setup and security requirements for labor distribution reporting before using the OTBI attributes.