Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BI Publisher Report Inputs

Summary
BI Publisher Report Inputs
Content
Hello Guru,
Version: Obiee 12C (12.2)
Database: Oracle 11g
We have a report with Employee Id, Employee Name, Employee SSN and report is accessed by multiple users. (Example: User A, B, C..)
Prompt - SSN
We would like to capture what user entered in Prompt (i.e. we would like to track or create report with user id, ssn entered and store this in db table)
Please post your inputs and thoughts to meet this requirement.
Thanks.
Answers
-
You can enable BI publisher auditing, but not sure if it helps with your requirement. Take a look below if you haven't already.
https://blogs.oracle.com/xmlpublisher/entry/how_to_audit_and_monitor_bi_pu
0 -
If the underline database is oracle, then you can use DBMS_FGA - Oracle Fine Grained Auditing. That can log every query run against Employee table.
Thanks
Arijit
0