No Data Found In Procurement DBI Reports: Missing Security Setup
Last updated on OCTOBER 10, 2017
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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms