BI Publisher
Discussion List
-
Issue with Text file output for eText Template with Data Model with 2 Data Sets in OTBISummary Issue with Text file output for eText Template with Data Model with 2 Data Sets in OTBIContent I have a report using a Data Model that uses 2 data sets. I use an…DavidBlake 166 views 13 comments 0 points Most recent by Gregg Vadasz Reporting and Analytics for HCM -
Need help for building Confirmation Letter after probationContent Dear All, I am new to report development in oracle fusion HCM cloud. It would be really helpful if someone can post Confirmation Letter after Probation & Extensi…User_2025-02-06-14-37-05-233 100 views 1 comment 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Embed a BI Publisher Report link in the Goals page to fetch data for the searched employeeSummary Approach to embed a link to run a BI Publisher report to fetch Goals details for that employeeContent Hi, Apologies if I had missed any existing thread/post on t…Kalyan Amaravathi 71 views 4 comments 0 points Most recent by Kalyan Amaravathi Reporting and Analytics for HCM -
Email address not accepted in scheduled BI Publisher reportSummary & in email address is preventing scheduling of BI Publisher ReportContent Hi, A colleague is trying to schedule a report but he is unable to enter an email addre…User_2025-02-05-22-44-35-842 30 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Passing values from report to an oracle fusion pageSummary Passing values from report to an oracle fusion pageContent I have a BIP report with bursting to email, which will be sent to the manager for individuals. Now in …User_2025-02-06-10-22-06-460 36 views 1 comment 0 points Most recent by Laksh Kapoor Reporting and Analytics for HCM
-
BI Publisher Termination ReportSummary Can a fix I made to the analysis version be applied to the Data Model version?Content Hi, Can someone please add the following Action Codes to this Data Model & …User_2025-02-05-22-44-35-842 48 views 10 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Analyses report to fetch Supervisor Level 2 and aboveSummary Analyses report to fetch Supervisor Level 2 and aboveContent Hi, I am looking to fetch the following using Analyses. * A list of Supervisors with Level 1 (not ma…Manoj.Gupta 48 views 6 comments 8 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Reporting Requirement to Find Employee's VP or above Manager Level in Reporting ChainSummary Reporting Requirement to Find Employee's VP or above Manager Level in Reporting ChainContent Hi, I am not sure this is possible within a single select statement …
-
Pending Workflow Notifications DashboardSummary Dashboard to be created for pending workflow notiifcationsContent Hi all, We are trying to create a dashboard which will display the number of pending workflow n…User_U7T4G 115 views 11 comments 0 points Most recent by Ankush Rode Reporting and Analytics for HCM
-
BI Publisher Report not runningSummary ORA-01476: Divisor is equal to zero error messageContent Hi, A user has contacted me saying they are unable to run this report and they see the following error m…User_2025-02-05-22-44-35-842 30 views 5 comments 0 points Most recent by User_2025-02-06-08-02-11-890 Reporting and Analytics for HCM
-
Benefit Eligible - Working Hours ChangesContent Hi all - we have requirements for our benefit eligible population: Person Type = Regular Employee, Limited Term Employee, Casual/Seasonal Employee Assignment Cat… -
BI Publisher ReportSummary Column FormattingContent Hi, I have a BI Publisher report and everything works well but there are 2/3 columns that are not formatted correctly which makes the re…User_2025-02-05-22-44-35-842 39 views 3 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Calculation cards Federal Start date and End DateContent Hi All, In which table/column holds the Federal Start Date and End date values. Thanks, Visu
-
Current and Previous Employment detailsSummary I need BI report to fetch Current and previous employment details.Content Hi Team, I need a BI report (Not OTBI) to fetch current and previous employment details…User_OWH0W 110 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BI report or OTBI report to list out ALL Pending vacation requests for a managerSummary BI report or OTBI report to list out ALL Pending vacation requests for a managerContent Hi Experts, My manager would like to know if there’s a way to view all th…
-
How to schedule a BI Publisher Report on a particular Day Every hourlySummary How to schedule a BI Publisher Report on a particular Day Every hourlyContent Hi All, We have a requirement to schedule a Bi publisher report every Tuesday and e…PankajRK 41 views 4 comments 0 points Most recent by User_2025-02-06-08-02-11-890 Reporting and Analytics for HCM
-
How can I find out winch report we created and have at HCM & is which are active?Summary I need to have a list of all our reports in HCM BIP (and/or)OTBIContent Hello How can I find out winch report we created and have at HCM & is which are active? I…Orit Dekel 28 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
How to split element input values into separate columns in BI ReportSummary How to split element input values into separate columns in BI ReportContent Hi Experts, Currently, in my BI report, all element input values are showing under on…Mahendra 112 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Etext Template in csvSummary Etext template in csv drops leading 0's from reportContent when we export the file as text, the ID's keep leading 0's, but when it goes to csv leading 0's are dr…Mike Borghoff 28 views 2 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
How to get Custom CSV output with E-Text Template TypeSummary How to get Custom CSV output with E-Text Template TypeContent Hi, we require CSV report output in e-text template format. when we choose csv output format its cr…User_MC37Q 166 views 6 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM -
Create a Bursting Email with TemplateContent Does anyone have any user guides or instruction templates for setting up a BI Report that is bursting a custom memo to the recipients on the list. We have a repo…Katie.Buchanan 80 views 4 comments 0 points Most recent by Mihaela M Reporting and Analytics for HCM -
BI Publisher vs OTBI? Any guidance/recommendations on when to use each solution?Content Hello, I have tried searching but cannot see anything as focused - query is, are there any recommendations or guidance from Oracle around when to use BI Publishe… -
report to get list of direct reports for a managerContent Hi Experts, I am looking for a query where the manager can get the output as the name of all direct report specific to them, I am able to achieve it in analysis …GauravSushant 968 views 3 comments 1 point Most recent by User_2025-03-07-00-53-57-686 Reporting and Analytics for HCM -
Analysis or Report not returning any resultsContent I'm hoping there is something obvious I'm not doing right, but every time I try and run an Analysis or Report in BI Publisher, it returns No Results as per the s…User_2025-02-05-23-39-39-057 56 views 6 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Headcount in Fusion ProfileSummary Do you know what table does Headcount belong to in Fusion>Person Management>Manage Person.Content Do you know what table does Headcount belong to in Fusion>Perso…Mark kristan De los Reyes 29 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
OTBI Report Shared to Supervisor does not show parameterContent Hello Everyone, I have added a tab to 'My Team' to show reports to Line Managers. I have added an OTBI report to this tab using personalization. However, when ru…Hetal Vaghela 28 views 2 comments 2 points Most recent by Hetal Vaghela Reporting and Analytics for HCM -
Has anyone seen custom reports timing out after 20A upgradeSummary BIP Reports timing outContent We have a custom BIP report built off a SQL data model. It used to run about 15 minutes. After upgrading to 20A in all our developm…TonyWo 38 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Workforce Map - ReportSummary Looking to see if the Workforce Map we use can be replicated in OTBI or BIPContent Hello We are soon to move from a partial cloud installation to a full cloud of…Andrew Braid 56 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BIP Report: Converting multiple row & multiple column values into single row and multiple column valSummary BIP Report: Converting multiple row & multiple column values into single row and multiple column valueContent Dear Experts I am working on a BIP report (SQL quer…Karthik K-Oracle 307 views 1 comment 0 points Most recent by Karthik K-Oracle Reporting and Analytics for HCM -
Changing Security on A BIP Report so that it displays whole organization data instead of just the daContent Hi All, Does anyone know the best way to modify a BIP report that's built to show manager's hierarchy view only so that the report shows full organization data? …Lauren Owen 20 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM