BI Publisher
Discussion List
-
Download Report FormulasContent Hi all - we have a requirement to do a lot of calculations within a compensation/reward report. One of the fields is the bonus estimate EX: Salary column X Incen… -
Password protection for BI Publisher Excel outputsSummary Password at report levelContent Hi Team, We are in 18C and I have seen an option in BI publisher, Report properties, where we can setup a password for the Excel …Alvaro Couto 101 views 12 comments 3 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Reporting on Late TermsContent Hi all - hoping you can help with how to report on a termination keyed late? My understanding is that a line manager keys in the termination 01SEP for 10SEP. The…
-
OTBI - Manager History ReportSummary Present and Past report(s) for a particular managerContent Hello All, I am looking for a Manager History report. Requirement is : If we give manager name as prom…User_2025-02-05-07-43-29-505 62 views 11 comments 0 points Most recent by User_2025-02-05-07-43-29-505 Reporting and Analytics for HCM -
Recreate BI Answers Direct Database Query reports using the OTBI subject areasSummary What is Direct Database Query Reports? Is this Datamodel OTBI? or what exactly?Content I received this email from Oracle and I want to know what's Direct Databas…User_2025-02-05-15-05-03-822 82 views 5 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Running BI Agent Going in ErrorContent Hi We have a requirement where we need to send email individually to employees based on the User Name, we have used SESSION VARIABLE in our Analytics but when th…User_X2ICD 33 views 1 comment 0 points Most recent by Shakher Sharma Reporting and Analytics for HCM -
Need inputs to display More than 65531 rows in excel output by using Excel templateContent HI All, As per the requirement we developed Data Model and Excel template. While running the report getting below error, Waiting Time: 0.4 seconds Data Fetch Tim… -
Open Enrollment ReportSummary Open enrollment report that indicates employees have not enrolledContent Hello Everyone, Do you know any OTBI Subject area or back end tables to create a open en…VarunG 99 views 11 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
It is possible add fields in HCM Cloud subject areas for analysis?Summary I want to add fields and tables in HCM subject areas to extend my dataContent Hi people :) anyone knows if its possible to add fields in standard HCM subject are…User_2025-02-04-20-32-05-757 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need help on BI Publisher ReportSummary Creation of Dashboard promptContent Hi Team, I am creating one report using data model and report with parameters. When I tried to create Dashboard prompt for th…SM-Oracle 81 views 14 comments 1 point Most recent by User720640-Oracle Reporting and Analytics for HCM
-
Productivity ReportSummary A Report from Oracle to provide site productivityContent Can i ask if a report like this is possible? They are looking to measure productivity in the sites, so t…User_2025-02-04-17-26-38-144 47 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Looking for Seeded report to identify campus candidates and to pull list of screening questions withSummary Looking for Seeded report to identify campus candidates and to pull list of screening questions with their responsesContent Hi Team, Is there any seeded report w…Harish Kumar Kovi 20 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table link between Profile attachments and UCM fileSummary Finding Profile Related attachment in UCMContent When you upload an attachment in your profile that goes to UCM as a file attachment. But the name of the file ne…Prateek Parasar - GTUK, ACE Pro 41 views 1 comment 8 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI Publisher report Export to CSV outputs the prompt values in file which are not neededContent We have report with prompt values start date end date and location. Now when we are trying to export the report as CSV data it is throwing the prompt values also…
-
Unable to run report in Oracle BISummary Unable to run report in Oracle BIContent Hi, We suddenly have issue with all our reports in Oracle BI Production. We are not able to run our reports at all. Does… -
BI Cross Report from External Source and HCM RecordsSummary Create a Report from external source file as XML or CSV data file in WCCContent Create a cross report with External data source file in Web Content Center and pe…Misael Gutiérrez-Oracle 43 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Active employees with no pay checkContent We have active, benefited employees that must meet a threshold of hours each pay period in order to maintain their benefits. Is there a way for me to report all …Annette M 57 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Creating report output as XML File in FusionSummary Creating report output as XML FileContent Hello - Has anyone created a report with output as xml file using OTBI or BIP? Please share any links/details you may h…User_2025-01-25-04-02-13-126 1.1K views 4 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to get the Offer accepted date of the person in BIP?Summary How to get the Offer accepted date of the person in BIP?Content Hello Team, We are looking for a table, where we will get the offer accepted date of the person. …Harish Kumar Kovi 42 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need tablenames to pull Valueset values in BI reportContent Hi, I have requirement to pull value set values in BI publisher report. I am not able to find the table names for the valueset in HCM. Can you please let me know…PankajRK 38 views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Adobe Flash to run reports/dashboards on browsersContent Hi All, Over the past few days while working in OTBI, I kept getting asked to run flash everytime I opened a report or dashboard- eventhough flash is already ena…PriyaPenugonda-SC 72 views 6 comments 4 points Most recent by PriyaPenugonda-SC Reporting and Analytics for HCM -
XPT Ouput(User Interface Layout) is running under ProgressSummary XPT Ouput(User Interface Layout) is running under ProgressContent HI Team, We have report which has XPT Layout output(User Interface Layout).We have given open p…nitin Sharma 21 views 7 comments 0 points Most recent by Shakher Sharma Reporting and Analytics for HCM
-
Accessing user-defined tables in OTBIContent Hi All, I have few user defined tables in HCM.Department ID and Department Name. Now I want to access this user defined table and user defined columns and put a …User_DYMHE 315 views 1 comment 0 points Most recent by MandeepKGupta Reporting and Analytics for HCM
-
Calling UDT in OTBISummary We need to get UDT values on OTBI AnalysesContent Hi All, I am working on an OTBI analyses where we need to derive values from UDT. I am not able to see these UD…Vibha Pandey - Oracle 642 views 19 comments 0 points Most recent by User_F1ZIP Reporting and Analytics for HCM
-
Sql to find Learn content without a course, Offering and Selfpaced ActivitySummary Sql to find Learn content without a course, Offering and Selfpaced ActivityContent It would be a great help if you can give me the sql which can find the Content…Mansur Khalil 82 views 2 comments 1 point Most recent by Akash Kiran Jana Reporting and Analytics for HCM -
Search Prompts for Direct Database AnalysesSummary How do you add filters to an analysis created from a direct database query?Content When putting search prompts / search parameters on an analysis based on the OT…User_2025-02-04-06-02-17-038 27 views 3 comments 1 point Most recent by User_2025-02-04-06-02-17-038 Reporting and Analytics for HCM
-
Audit for multiple open assignment-related transactions on same associateSummary Audit for multiple open assignment-related transactions on same associateContent Good afternoon. Wondering if anyone has built an audit (in either OTBI or BIP) t… -
Number of days left of vacationsSummary Number of days left of vacations for a person who's been let go or has resignedContent Hi, I'm trying to get the number of days left of vacations from a person w…User_2025-02-05-01-30-45-449 39 views 5 comments 0 points Most recent by User_2025-02-05-01-30-45-449 Reporting and Analytics for HCM
-
Query to find recent payroll actionSummary Query to find recent payroll actionContent For a particular employee, on the same day, they have processed payroll actions such as "Regular Normal" once and "Pro…SuryaMuralidharan 450 views 1 comment 0 points Most recent by Thiru Ch Reporting and Analytics for HCM
-
Date prompt is getting passed in invalid format to BI report used in Dashboard.Summary Date prompt is getting passed in invalid format to BI report used in Dashboard.Content Hello, We are facing an issue in while using dashboard as BIP as content. …~ GK ~ 340 views 4 comments 1 point Most recent by Vinod Andhavarapu Reporting and Analytics for HCM