Report New Item Attributes Using Oracle Transactional Business Intelligence

You can create OTBI reports by including packaging string. A packaging string shows the hierarchy of units that represent how an item is packaged when shipped or used by an enterprise.

OTBI Report Showing Packaging String

OTBI Report Showing Packaging String

You can also include item object identifier in OTBI reports. This attribute helps you to identify document items.

OTBI Report Showing Item Object Type

OTBI Report Showing Item Object Type

This feature helps to gain improved business insight on:

  • Key packaging string details that are important for downstream processes such as inventory, planning, warehousing, and many other downstream processes. 
  • Allows for more accurate analytics and reporting based on the type of products stored in your item master.

Steps to Enable

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

Tips And Considerations

  • You can find these attributes in the Item > Main folder of the Product Management related areas.
  • You can use filters on item object type to include or exclude document items in your reports.

Key Resources

  • Refer to the Oracle Fusion Cloud SCM: Creating and Administering Analytics and Reports for SCM guide, available on the Oracle Help Center.

Access Requirements

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

  • Transactional Analysis Duty (FBI_TRANSACTION_ANALYSIS_GENERIC_DUTY)
  • Product Transaction Analysis Duty (FBI_PRODUCT_TRANSACTION_ANALYSIS_DUTY)
  • BI Consumer Role (BIConsumer)

These privileges were available prior to this update.