BI Publisher
Discussion List
-
Joining iby_ext_bank_accounts_ audit table with the person recordSummary Joining iby_ext_bank_accounts_ audit table with the person recordContent Hi All, I am trying to create the audit report for the Bank Account Changes and want to …Dharmendra Jha 61 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
How to remove Extra blank lines in Excel output from BI Publisher RTF templateSummary How to remove Extra blank lines in Excel output from BI Publisher RTF templateContent Hi Experts, How to remove Extra blank lines in Excel output from BI Publish…Bala Kasineedi 69 views 4 comments 0 points Most recent by Bala Kasineedi Reporting and Analytics for HCM
-
Which table/view stores information of Data models / BI Reports / OTBI reports created or updatedSummary I need the table that stores the information of Data models / BI Reports / OTBI reports created or updatedContent I need the table that stores the information of…
-
Talent Review| Succession Plan| Career Development - All in One ReportSummary This report will give employees' Performance, Talent Review, Succession and Career detailsContent If your customer wants a detailed report on Talent management w…Mani Iyer-81826 115 views 6 comments 0 points Most recent by User_2025-02-08-07-12-44-872 Reporting and Analytics for HCM -
Precedence of security roles for custom BIP reportsContent If we have 2 roles attached to the BIP report, one of them should have Read, Traverse access and another one should not have access what would be the precedence …Prajna Hegde 31 views 2 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM
-
How to read Context Segment DFF and associate it to employee record?Summary How to read Context Segment DFF and associate it to employee record?Content Hello, I have information stored in the assignment attribute 2 of the PER_ASG_DF DFF …Nicola Petri 25 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a way to put a pause/hold on all the BI reports schedule in HCM and resume them after few dSummary We need to pause the schedules in PROD for few days and we don't know how many user schedule the BI/OTBI report jobs. We need to pause all the jobs at one go and…User_F89L9 85 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Impact of creating a Customer specific custom folder in parallel to seeded Shared/Custom folder inSummary what are the impact of creating new folder parallel to seeded Shared/Custom folderContent Hi Team, Do you see any impact, if we create a new custom folder direct…Alok Suraj-Oracle 23 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Query underlying UCM tableSummary Query underlying UCM tableContent Is there an available table or view that gives access to the UCM? I don't care about the actual attachment and the contents wit…
-
Parameterized Bi Report Within A Dashboard Is Not WorkingContent Hi Team, Greetings of the day!! I have created a dashboard with BI Report having one parameter. The report is working as expected with the same parameter but in …Divya Kollipara 42 views 4 comments 0 points Most recent by Divya Kollipara Reporting and Analytics for HCM
-
Oracle BIP DataModel -> Default views 'Table View' and '200' rows - PossibleSummary BIP Default ViewsContent Hello, Just wondering if there are any default settings available to achieve 'Table View' and '200' rows. Attached a picture. I don't an…SantoshKumarBhairi 79 views 10 comments 4 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
BI Data Model: finding all reports that this is attached toSummary How to know all the reports that use xyz data model?Content Hello, I have a data model in BI Publisher. I assume 3 reports are connected to it. But how can I be …User_2025-01-28-21-53-32-678 31 views 3 comments 2 points Most recent by User_2025-01-28-21-53-32-678 Reporting and Analytics for HCM -
BIP Report job's output in PDF format is not getting downloaded but opened in the browser.Summary BIP Report job's output in PDF format is not getting downloaded but opened in the browser.Content We have created a report with bursting logic to split a pdf fil…Mandavi Shrivastava 283 views 2 comments 1 point Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM
-
Conditional Logic in RTFSummary Conditional If-Then-Else and Looping logic in RTF TemplateContent Hi All, I am trying to add conditional logic, specifically using If-Then-Else statements, in an…Denise Izzi 367 views 6 comments 3 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
BIP Data Sources accessSummary BIP Data Sources accessContent Hi Experts, Does anybody know if it is possible to restrict access to the Data Sources in the BIP data model UI? I appreciate any …Volodymyr Faranosov 43 views 7 comments 1 point Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
Audit DahsboardSummary Need help finding Audit DashboardContent I remember seeing Audit Dashboard. I can't seem to find it. Does anyone know is there a Oracle delivered Audit Dashboard…User381997 67 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Edit Grand total in pivot tableContent Hi there, we made a Pivot table in OTBI analysis with pay elements in column. We have been able to add the Grand Total of them but we would like to exclude an el…Chiara Arcidiacono 22 views 7 comments 1 point Most recent by SimonTomey Reporting and Analytics for HCM -
Department HierarchyContent Hi all - I have a great report that we use for Department Hierarchy through OTBI, but we need this report through BIP. We have users that will pull this data the…Prudence K 66 views 12 comments 1 point Most recent by Nivya Mathire Reporting and Analytics for HCM -
Compensation Components table for BIContent Hello experts, do you know the Oracle tables to extract compensation components values and components name? Thanks in advance for your time! Kind Regards, ValerioValerio Curzi 36 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Table(s) that store Persons Language, Degree, Prior Work Experience, Licenses/Certificate InformatioSummary Looking for the hcm tables that store Person info such as Language, Degrees, Prior Experience, LicensesContent Hi, We want to create data model(s) to pull the Pe…
-
Query to fetch BIP report job historySummary Query to fetch BIP report job historyContent Hi Team, Is there any query from table to fetch the BIP report Job History. Thanks, Sourav
-
HCM Quarterly Changes Impact on Reporting and AnalyticsSummary HCM Quarterly Changes Impact on Reporting and AnalyticsContent Hi all, Is there any other references for Quarterly changes on HCM that affects reporting? I have …Raymund Jerome 23 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Tracking new line managersSummary Identify line managers who have managed employees less than a yearContent Is there a way to identify line managers who have managed employees less than a year? W… -
Query to exctract Person Email addressesContent Hello experts, do you know the query to simultaneously exctract the following information? EmailAddressId|PersonNumber|EmailType|EmailAddress|DateFrom|DateTo|Pri…Valerio Curzi 25 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Report Job History Page in OTBI IssueSummary Report Job History Page in OTBI Issue is BlankContent Is anyone else experiencing an issue accessing the Report Job History Page? I assume a browser issue, but h… -
List of all Scheduled BIP ReportsSummary List of all Scheduled BIP ReportsContent Hi Team Is it possible to extract the list of all scheduled BIP reports along with owner and schedule frequency? Which t…Karthik K-Oracle 129 views 6 comments 3 points Most recent by User_KM4LK Reporting and Analytics for HCM -
Need SQL query to fetch Balance Initialization/Balance AdjustmentContent Hi All, We are looking SQL query to fetch the Balance Initialization/Balance adjustment data. Please share SQL query if anyone is having in handy. Thanks, Visu
-
BI Bursting to SNOW - Postmaster issueSummary Emails are being blockedContent Hi Team, I've implemented a report to burst an emailt to ServiceNow Inbox with copy to my own email (Dev environment). I am getti…Alvaro Couto 37 views 6 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Employee/Manager Self-ServiceSummary How to report on effectiveness of ESS/MSSContent Hi all - checking in to see if any of you currently have a report that reports on the effectiveness of employee …Prudence K 149 views 9 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Help Building HCM Group Membership ReportSummary I need to build a report that pulls all employees HCM Group membershipContent It doesn't seem that there is an easy way to find out what HCM Groups an employee i…David Rabalais 122 views 1 comment 2 points Most recent by David Rabalais Reporting and Analytics for HCM