Oracle e-Business Suite Daily Business Intelligence

Oracle e-Business Suite Daily Business Intelligence

Goal:

To Set up Daily Business Intelligence for Oracle e-Business Suite Modules

Step 1:

•  Profile Options :
• OM: DBI Installation – Y (Site Level)
• EDW : Degree of Parallelism on the source – 1 (Site Level)
• ISC: Shipping/Transportation Execution DBI Installation – Yes (Site Level)

Step 2:

• Setup Global Parameters
• Daily Business Intelligence Administrator -> Global Parameters

Step 3:

Grant Organization Access to Daily Supply Chain Intelligence, Daily Business Intelligence Administrator and Development Manager Responsibility

Inventory -> Set up -> Organizations -> Organization Access ->

Step 4:

To use dashboards effectively, you must ensure that the Enterprise Calendar has periods defined from the Global Start Date to any future dated transactions that you will report on.

For example, if you are reporting on future dated transactions such as budgets and forecasts, periods must be defined for all possible future and back dated transactions.

GL - Setup- Financials - Calendars- Search for Accounting Query for the calendar value you found in the DBI Global Parameters for enterprise calendar Check for missing periods or lacks between periods

Step 5:

• Setup Reporting UOM
• Navigation - > Setup->Supply Chain -> Reporting Units of Measure

Step 6:

• Assign the Item Category to the Item in Item Master
• Run the Initial or Incremental Load in DBI