Overview of OTBI for Oracle Fusion Manufacturing

Oracle Transactional Business Intelligence (OTBI) offers you real time, self-service reporting directly from Oracle Manufacturing. It's a dynamic reporting layer built keeping the business user in mind.

OTBI analysis can be created and viewed using Reports and Analytics from the panel drawer of the Work Execution work area within Manufacturing or using the native BI Analytics (Answers) application. The Reports and Analytics option can also be accessed from the Navigator by selecting it from Tools on the Home page.

If you've been assigned a job role your enterprise uses for production supervisor work, you can automatically access the manufacturing-related OTBI subject areas. The analysis can be performed only for those organizations that you've access to.

OTBI provides the following Manufacturing subject areas, which you can use to build modified analysis. These subject areas are:

  • Manufacturing - Work Order Performance Real Time

  • Manufacturing - Material Usage Real Time

  • Manufacturing - Resource Usage Real Time

  • Manufacturing - Actual Production Real Time

  • Manufacturing - Production Exceptions Real Time

  • Manufacturing - Purchased Item Usage Real Time

The previously mentioned subject areas support analysis of both in-house manufacturing and contract manufacturing-related work orders, their execution transactions, and operation start or stop metrics.

The dimensions and facts in these subject areas provide you visibility to work order management and work execution transactions.

You can use the common dimensions provided in the previously mentioned subject areas to cross join information between Manufacturing and subject areas belonging to other products such as Oracle Order Management, Oracle Inventory, Oracle Shipping and so on. For example, you can use the product item name information from Manufacturing and join the on-hand balance information from Inventory to create an analysis which provides visibility of work order product's availability.

The following predefined transactional analysis samples are provided for your use:

  • Cycle Time Performance: Can be used to analyze average total cycle time in addition to queue, run, and idle time components.

  • Work Orders Scheduled Today: Can be used to analyze work orders scheduled in your plant for the current date of the application.

Note: You can edit the predefined sample analysis provided to you and you can also create your own transactional sample analysis.