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

Last updated on MARCH 15, 2022

Applies to:

Symptoms

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:

 

Cause

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