My Oracle Support Banner

No Data Found In Procurement DBI Reports: Missing Security Setup (Doc ID 316829.1)

Last updated on MARCH 15, 2022

Applies to:

Oracle Procurement Intelligence - Version to 12.1.2 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.


Upgraded  to 11.5.10 or 12 or 12.1.

Execute the setup steps  in <Note 286936.1> - DBI Setup Steps.

Run the initial load. Later run again the load with option clear and load all summaries.

The load process finishes with no error. But there is no data in any report.  Due to this issue, users are not able to see the data in the reports for data analysis.

Steps to reproduce

1. Enabled the DBI pages:

1.1 Go to Business Intelligence Administrator responsibility > Setup: Global> Parameters > Overview Pages
1.2 Choose the reports to use:
  Commodity Spend Management
  Commodity Supplier Management
  Procure-to-Pay Management
  Procurement Management

2. Set profile options:

FII: DBI Payables Expenses Implementation to yes
FII: DBI Payables Operations Implementation to yes

3. Set the parameters:

3.1 Go to Business Intelligence Administrator responsibility > Setup:Global > Parameters
3.2 Enter the parameters
Enterprise Calendar, Global Start Date are required.

4. Set the Financial Dimensions:

4.1 Go to Business Intelligence Administrator responsibility > Setup: Financial Intelligence >
Financial Dimension Setup.
4.2 Click Source Ledger Groups tab.
4.3 Add a ledger for the operating unit in Financials Intelligence Group.

5. Set the commodities:

5.1 Go to Purchasing responsibility > Setup > Items > Commodities > Commodities
5.2 Click Enter Commodity
5.3 Enter Commodity Code, Name and Description
5.4 Click Assign Categories
5.5 Select the categories
5.6 Click Apply

6. Create a Initial Request Set:



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.