BI Publisher
Discussion List
-
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 22 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 127 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 147 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 130 views 1 comment 2 points Most recent by David Rabalais Reporting and Analytics for HCM -
Report on BI Publisher Bursting RecipientsSummary Extracting details of bursted email recipients over set periodContent Hello, We have a nightly bursted email report inviting employees leaving our business to co…RebeccaAult1799 48 views 4 comments 9 points Most recent by Tom John Bontoyan Reporting and Analytics for HCM
-
Can we update a column after BI report bursting for person levelSummary Can we update a column after BI report bursting for person levelContent Hi , We have a requirement in compensation module to avoid the letter bursting multiple t…User_MC37Q 47 views 2 comments 0 points Most recent by Tom John Bontoyan Reporting and Analytics for HCM -
Bursting HistorySummary Need to find the table for bursting report hisotryContent Hi Guys, I found a table for BIP Bursting report history but seem that the only usable column is the US…User_2025-02-05-11-53-59-507 80 views 9 comments 2 points Most recent by Tom John Bontoyan Reporting and Analytics for HCM -
when using HTML2FO function to convert HTML enabled text in rtf template output is not coming with tSummary when using HTML2FO function to convert HTML enabled text in rtf template output is not coming with the font and size defined in RTF templateContent Hi All, In a …
-
Need help on OTBISummary Sum of Balances in OTBI reportContent Hi Team, We are creating one report. Our requirement is to print the balance value in such a way that balance value of A an…
-
Date fields using excel templatesContent Is there a way to print date fields on excel based BI publisher reports where excel can recognize it as an actual date field? Is this the only solution https://d…User_2025-02-10-08-27-16-805 26 views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Using .xlsx template instead of .xlsContent Is there a way to load .xlsx file as a template instead of .xls file? I am trying to create a BI publisher report with slicers and I run into compatability issue…User_2025-02-10-08-27-16-805 44 views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
SQL query to get offering start date and end date in learn module in fusion HCMContent Hi All, I am working in a requirement where I need the following details: Offering Name, Offering start date, Course Name, Person number enrolled in the offering…Mani Venkataraman 1.1K views 1 comment 0 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM
-
Dependents not enrolled in Benefits SQL HelpSummary Dependents not enrolled in Benefits SQL HelpContent Hi All, I have a query that I use in a BIP report that is supposed to be determining if a dependent is going …User_2025-02-04-08-51-08-912 117 views 1 comment 0 points Most recent by Nagaraj Hunur-Oracle Reporting and Analytics for HCM
-
Custom Performance Document TemplateSummary Changing the fonts in Performance Document templateContent Hi, Has anyone successfully customized the RTF in template in: Path: /Human Capital Management/Career/…Janine Dorongon 33 views 2 comments 0 points Most recent by Janine Dorongon Reporting and Analytics for HCM
-
Change Font of Delivered Performance Management ReportSummary Change Font of delivered - Performance Document Worker And Manager Ratings ReportContent Hello Experts, I am planning to change font (to Arial) for the delivered…Anil Pillaresetty 43 views 9 comments 0 points Most recent by Janine Dorongon Reporting and Analytics for HCM -
Oracle SQL - Display rows as columns - Many to Many RelationshipSummary Oracle SQL - Display rows as columns - Many to Many RelationshipContent Good day! I need some guidance if I want to do is actually possible in Oracle SQL. I have…Raymund Jerome 36 views 2 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
"Insufficient Privileges" in Fusion CloudContent Hi All, We have a requirement to find the approver name of a particular transaction. I did some research and found that may be we can get relevant data in hcm_fu…
-
Role Change Reflect to AnalyticsSummary When you change roles in Fusion, does it also get changed at the same time in Analytics?Content We encounter scenarios where we cannot see a report and then we a…Pernel Dela Pena 27 views 6 comments 0 points Most recent by Matt Nease Reporting and Analytics for HCM
-
How to report on "lineouts" and "ergonomic injuries" within OTBI / OSHASummary How to report on "lineouts" and "ergonomic injuries" within OTBI / OSHAContent How to report on "lineouts" and "ergonomic injuries" within OTBI I think this data…Andrew_Schmitz 29 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Need SQL Query/ table names to get Source System ID for person's areas of responsibilitySummary Need SQL Query/ table names to get Source System ID for person's areas of responsibilityContent Hi All, What I need is to get Source System ID for person's areas…Dhanuka Chamal 3.1K views 6 comments 2 points Most recent by Dhanuka Chamal Reporting and Analytics for HCM -
How can we pass a table prompt selected in the main report to the table prompt in the drilldown repContent We have a dashboard with a drill down to a detailed report. The main dashboard has a report that shows the rollup counts of documents by task status. When you cl…Tom_Giarratano12 30 views 3 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
Looking for the Table for assignee Details from Service RequestSummary Table for the Assignee Details to whom the SR is assign to in the Helpdesk.Content Table for the Assignee Details to whom the SR is assign to in the Helpdesk. Ve…Preethi nair 25 views 3 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Cannot Find Category Name in Service RequestsSummary Looking for Category Name in the CRM Service ModuleContent Hey everyone, We recently installed HCM and we use the service model to act as our HR Help desk. I hav…
-
Organization Chart Custom ReportContent Hi All, I customized the DirectoryPrintReport report in /xmlpserver. I have kept only Custom as Default and Active. But the system is still printing the delivere…Mohit Sinha-Oracle 41 views 2 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM