Combine Subject Areas Using the Work Definition Common Dimension in Oracle Transactional Business Intelligence

You can now use a common dimension for work definition to create a report, analysis, or dashboard that combines OTBI subject areas for Manufacturing work definitions with Manufacturing work orders and transactions. For example, you can create an impact analysis report of work definition version changes or engineering change orders that affect unreleased or released work orders. You can also create a variance analysis report between the work definition and work order transactions for identifying potential continuous improvement opportunities and adjustments to the standards.

The following screenshot shows an OTBI analysis to review unreleased work orders with change orders in organization M1:

Work Orders with Change Orders Analysis

Using the Work Definition common dimension to analyze manufacturing work definitions provides greater visibility and accuracy in manufacturing master data setups and change management scenarios, which ensures correct work orders for execution.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

• Refer to the 25B feature Analyze Manufacturing Work Definitions Using Oracle Transactional Business Intelligence or OTBI for more information about the Manufacturing – Work Definitions Real Time subject area.
• Work definition OTBI-based KPIs and visualizations can be added to the Work Definition and Work Execution landing pages based on user privileges. Refer to the 25A features Redwood: Model Plant Setups and Work Definitions Using a New Home Experience and Redwood: Manage and Execute Production Using a New Home Experience for more information.

Key Resources

• Watch the Combine Subject Areas Using the Work Definition Common Dimension in Oracle Transactional Business Intelligence Demo.
• Oracle Fusion Cloud SCM: Refer to the Using Manufacturing guide, available on the Oracle Help Center.
• Oracle Fusion Cloud SCM: Refer to the Implementing Manufacturing and Supply Chain Materials Management guide, available on the Oracle Help Center.
• To learn more about creating a report URL in OTBI, refer to the product documentation.

Access Requirements

Users who are assigned a configured job role that contains these duty roles can use this feature:

• FBI_WORK_DEFINITION_TRANSACTION_ANALYSIS_DUTY
• FBI_MFG_EXECUTION_ANALYSIS_DUTY

These duty roles were available prior to this update.