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 126.96.36.199 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
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