Reports
Discussion List
-
Query to Pull List of Candidates and Their Supporting DocumentsSummary Query to Pull List of Candidates and Their Supporting DocumentsContent Hi Experts! Looking for some guidance. We need to build a query that lists all candidates …Lindsay Lamont 70 views 7 comments 0 points Most recent by Lindsay Lamont Reporting and Analytics for HCM -
Dinamically printing contents in a RTF templateSummary does not work in one caseContent Hi, I am using a RTF template for a Report that should display different contents on the basis of the field named "ANNO", whose… -
Possibility to notify an employee when dashboard updated with new dataContent Hello All, I will appreciate your support in the following issue: We have configured the following dashboard (PFA). Can you please advise if possible to notify t… -
Could not able to find the "Sequence" field in Checklist Real Time subject areaContent Hi Experts, I am trying to build a OTBI report using Checklist Real Time subject area but i cannot able to see the "Sequence" Field. Has anyone faced this issue?…HarishVummidi 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Output file is not getting multiple records using EText template.Summary Output file is not getting multiple records using EText template.Content Hi Experts, Output file is not getting multiple records using EText template. I am attac…Bala Kasineedi 46 views 3 comments 0 points Most recent by Bala Kasineedi Reporting and Analytics for HCM
-
How to capture page overflow in rtf template - BI PublisherSummary I need to display the sum of a particular field for all the Invoices in the current page only even if the Invoices overflow to the next pageContent Hello, I have…Nalinee Uppiah 40 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
how to restrict infolet user wise?Summary how to restrict infolet user wise?Sidhartha Wadhwa 40 views 5 comments 0 points Most recent by Sidhartha Wadhwa Reporting and Analytics for HCM -
Replace Dynamic SQL with Explicit SQL notificationSummary Notification received from OracleContent Hi There, Since yesterday we have received many notifications stating "Replace BI Publisher Dynamic SQL with Explicit SQ…
-
Profile Option for OTBI user settingsSummary Profile Option for OTBI user settingsContent Is there a profile option to set the default locale in OTBI? Global User settings get reset each day. It would be di…User_2025-02-05-23-02-10-916 20 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Exclude a column in XML Report output formatSummary My select query has two columns. I want to have only one column in my report output which is in XML format. Is there wa we can achieve this.Content My select que…Karishma Mungara-Oracle 92 views 5 comments 0 points Most recent by Karishma Mungara-Oracle Reporting and Analytics for ERP
-
How to fetch invoice_no and invoice_date from wsh_ tablesSummary Need to fetch invoice_no and invoice_date from wsh_ tablesContent Need to fetch invoice_no and invoice_date from wsh_ tables or from doo_ tablesNageshwaran1 24 views 3 comments 1 point Most recent by Nageshwaran1 Reporting and Analytics for ERP -
OTL Approved time cards details with Reported hours and Calculated Hours BI Report QuerySummary OTL Approved time cards details with Reported hours and Calculated Hours BI Report QueryContent Dear Team, We need Oracle Fusion OTL Approved time cards details …VenkatReddy Pulichintha 882 views 4 comments 0 points Most recent by VenkatReddy Pulichintha Reporting and Analytics for HCM -
Denmark country specific HR reports and analyticsSummary Denmark country specific HR reportsContent Hi, Are there any Denmark specific HR reports available? Denmark is Tier 1 localization and expecting some seeded HR r…Anuradha T 16 views 1 comment 0 points Most recent by Deneen Burrows-Oracle Reporting and Analytics for HCM -
Absence OTBI reportSummary Absence OTBI reportContent Hi Team, Can you please share if we have any OTBI report or analysis/dash board to fetch carry over, accrual and vacation balance ? (F…
-
Rating ChangesSummary Rating ChangesContent Hi, I have created analysis, we have date parameter based on the passed date it will show the rating changes , But we need to add another c…Reddykrishna Chidella-Oracle 29 views 5 comments 0 points Most recent by Reddykrishna Chidella-Oracle Reporting and Analytics for HCM -
Scheduling Report to Respective Line ManagersSummary Scheduling Report to Respective Line ManagersContent Hi Team, We have a requirement that respective line managers should receive a report on weekly basis about p… -
Is it possible to Hide columns in List of Values used in a PVO ?Summary Is it possible to Hide columns in List of Values used in a PVO ?Content We have defined a number of custom Reports and ESS Definitions. We try to use the standar…Balachander G-Oracle 28 views 0 comments 0 points Most recent by Balachander G-Oracle Reporting and Analytics for ERP
-
Probation Questionnaire ReportSummary I wanted to develop a probation questionnaire report using BIContent I couldn't find the table in which probation evaluation is found while developing a probatio…Michael Nega Gebrehawariyat 47 views 0 comments 0 points Most recent by Michael Nega Gebrehawariyat Reporting and Analytics for ERP -
Get the list of persons included in an Access for a Learning OfferingSummary Access Group Details For each Offering name and EmployeeContent Hi Every One, for an Offering in the Learning Catalog I have created an Access Group. I would lik…Ashok Naramsetty 24 views 2 comments 0 points Most recent by Ashok Naramsetty Reporting and Analytics for HCM
-
Cross posting this idea in ERP Reporting and Analytics forum - ability to Audit OTBI report configurSummary Cross posting this idea - ability to Audit OTBI report configurationsContent Here is an Idea posted in Financials - General that I thought would be of interest t…Jeff Hare CPA CISA CIA 31 views 0 comments 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
LSQL Newbie questionSummary Trying to learn to write LSQL. Need assistance with the errorContent Hello all, I just started learning to write LSQLs. After going thro the training materials, …User_2025-02-04-15-06-22-759 41 views 2 comments 1 point Most recent by User_2025-02-04-15-06-22-759 Reporting and Analytics for HCM
-
Pre-built standard reports in TRCSSummary Pre-built standard reports in TRCSContent Hi, I would like to know if there are any pre-built standard reports available in TRCS? Thanks, PradeepPradeep Kumar-230381 36 views 4 comments 1 point Most recent by Pradeep Kumar-230381 Tax Reporting (Direct Tax)
-
Extract Content Id for the attachment from Document of RecordsSummary Extract Content Id for the attachment from Document of RecordsContent As per the Oracle document https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=…Sowdha Murugan 50 views 3 comments 0 points Most recent by AvishekNandi Reporting and Analytics for HCM -
Prior manager issue in OTBISummary Prior manager issue in OTBIContent I have created analysis with Assignment Event Real Time subject area and manager name' in assignment event details folder i ha…Reddykrishna Chidella-Oracle 35 views 2 comments 0 points Most recent by Reddykrishna Chidella-Oracle Reporting and Analytics for HCM
-
How to move OTBI Report options (Export/Print/Refresh ) from Middle to either left or right on a DaSummary How to move OTBI Report options (Export/Print/Refresh ) from Middle to either left or right on a DashboardContent Hi Team, I want to move OTBI Report options (Ex…Mahendra 58 views 8 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report Batch Scheduler IssueContent Hi all, We encounter some issues with the FR Batch Scheduler when we execute (scheduled) multiple batches at the same time. In short what we are doing: - Start 8…
-
Which subject area has the SUI Employee Rate in Oracle HCM?Summary Please see the navigation for getting this rate in UI.Others > Setup and Maintenance -> Tasks Icon on righthand side > Search -> Define Legal Entities for Human …pratyushak 45 views 3 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
ORC analysis - Time to Approve?Summary I am looking for a way to report on the time to approve a job requisition in ORC using OTBIContent Hello, I have a need to report on the Time to Approve an ORC j…User_2025-02-04-23-22-13-274 84 views 4 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Not able to create dynamic Password PDF DocumentSummary Not able to create dynamic Password PDF DocumentContent Hello Everyone, we followed below steps: 1)Open the .rtf fil 2)Go to File - > Properties 3)Create a new c…User_2025-02-05-02-11-29-794 36 views 3 comments 0 points Most recent by MandeepKGupta Reporting and Analytics for HCM
-
Worker Age in Workforce TrendsSummary What to use to calculate age in Workforce TrendsContent Hello! I've been calculating the Age Bands by using a formula to gather the difference between the date o…