Create Manufacturing Work Order and Transaction Reports with a UDI Using OTBI

Oracle Transactional Business Intelligence (OTBI) lets you create reports using real-time transactional data from Oracle Fusion Cloud Manufacturing to analyze work orders and view transaction history. In this update, you can view the Unique Device Identifier (UDI) of a manufactured medical device that's assigned to or transacted in a work order (at product completion) by adding this new column to your manufacturing reports in OTBI. The UDI is a series of numeric or alphanumeric characters that's assigned to uniquely identify a medical device.

The Unique Device Identifier attribute has been included in both the Lot Number and Serial Number dimensions of the Manufacturing - Actual Production Real Time subject area to help you analyze production reported in manufacturing work orders.

Unique Device Identifier attribute in Manufacturing - Actual Production Real Time subject area

Unique Device Identifier Attribute in the Manufacturing - Actual Production Real Time Subject Area

  • Enhanced Traceability: The ability to view the UDI in manufacturing reports significantly improves product traceability. This is crucial in the medical device industry for tracking the lifecycle of a product from production to end user.
  • Compliance with Regulations: By incorporating UDI in the reports, businesses can ensure compliance with global regulatory requirements, which often mandates the use of UDIs for medical devices.
  • Decision Support: Access to detailed transactional data, including UDI, supports better decision-making by providing a holistic view of the manufacturing process and product lifecycle.

Steps to Enable

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

Key Resources

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

  • Manufacturing Execution Analysis Duty (FBI_MFG_EXECUTION_ANALYSIS_DUTY)
  • BI Author Role (BIAuthor)

These privileges were available prior to this update.