Reports
Discussion List
-
Payroll query that fetches results only if Archive and Generate Payslips is run post Payroll runSummary: We have a requirement to fetch the run result values only if the Archive Periodic Pay results and Generate Payslips processes have been run for the person post …Pinky Mukherjee 682 views 3 comments 0 points Most recent by Pinky Mukherjee Reporting and Analytics for HCM -
We have BI report but need to send custom schedule like 1st monday, 3rd monday in a monthSummary: Hi Team, We have BI report but need to send custom schedule like 1st monday, 3rd monday like this in a month how will send if through burshting how can we send …AjayKumar Maddipati 21 views 6 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
SQL Query - List Of Email-Notification DetailsContent We have a requirement to fetch all the Email-Notification Details (Recipient Email Address, Subject, Email Body Text., ) received by an employee. We have identif…Mano Haran-61126 1.6K views 4 comments 0 points Most recent by DevasishG Reporting and Analytics for HCM -
How can we send the report or notification BI or OTBI different languages based on country or personSummary: Hi Team, I'm new to above type of requirement to convert or send the resptive languaes , how can we achive this type of scanario? Thanks, Ajay Content (please e…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
which table can store the information about user's parent & child relationship roles in fusion hcmHi All, Thanks for looking into this issue. I am looking for table, which can store the current logged user parent -child roles(for Ex: One big role have more number of …Ravindr-Oracle 91 views 10 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
EEO-1 report output format in HCM CloudSummary: EEO-1 report output format in HCM Cloud Content (please ensure you mask any confidential information): We are in the process of generating EEO-1 reporting that …Parag Hiremath 21 views 6 comments 0 points Most recent by AlyssiaKing Reporting and Analytics for HCM -
When manager run the BI report only need to get the details of direct or indirect reportiesSummary: HI Team, When manager run the BI report only need to get the details of direct or indirect reporties how can we develop this requirement? Thanks, Ajay Content (…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
What is the diffrence between Date start and Orginal_Date_of_hire in PER_PERIODS_OF_SERVICESummary: Hi Team, we have to two columns for Hire_Date in PER_PERIODS_OF_SERVICE table what is difference between. if not why two columns given. Thanks, Ajay Content (pl…AjayKumar Maddipati 31 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
OTBI Report Job RequisitionWe have an OTBI report is the attached xml. I would like to add below fields in the report to show this information. Please suggest how we can add these fields and where…SauluriR 61 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there an OTBI Creation, Modification, Deletion Audit Report Available?Summary: Looking to know if there an audit report available that could be run to see reports and folders that have been created, modified, or deleted. Ideally, we would …G. Class-Peters 15 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to identify the tables that hold sensitive information using Oracle Cloud RecruitingSummary: I need to identify the any tables that hold sensitive information (PII). We have started using Oracle Cloud Recruiting and want to identify tables that have thi…
-
we would need a report with the previous and new cost center OTBI ?Summary: Hi Team, Hope all doing well ! we would need a report with the previous and the new cost center ? Could you please help me on ? Thanks, Ajay Content (please ens…AjayKumar Maddipati 31 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Adding multiple phone numbers to analysisSummary Add multiple phone numbers to an analysisContent Hi All, I just need some direction on adding multiple phone numbers for an employee in an analysis I am modifyin…User_2025-02-04-08-51-08-912 35 views 4 comments 0 points Most recent by Alexis PJ Reporting and Analytics for HCM -
OTBI report for learner count, count of learner according to number of courses completedSummary: I have to create a report to get the count of learners who have completed more than 1 course and learners who have completed more than two courses. Also I need …
-
Can you please provide us the details of the report which provides information about all the reportsSummary: Can you please provide us the details of the report which provides information about all the reports along with permission set to that particular report Can you…Shubham Bindal 11 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BI Reporting on BPM SetupSummary BI Reporting on BPM SetupContent Hi Team, Hope everyone is doing great ! We have a requirement to create a report on BPM Approval setup . Is there a table that s…
-
Logical SQL join condition for Recruitment and Transaction ConsoleHi, I have a report where I am using below tables for fetching recruitment and postion details like JobRequisitionNumber, RecruiterFullName,DepartmentName,RecruitingType…
-
Using dashboard prompts on multiple-subject area analysisSummary: Using dashboard prompts on multiple-subject area analysis Content (required): Hi all, I created an analysis to track a specific group of managers (narrower than…
-
How to enable audit for any personalization changes that are done via a sandbox in Oracle HCMSummary: We have a requirement to capture any personalization changes that are done via a sandbox in Oracle HCM application. Kindly let us know how to enable and track t…
-
Employee Names in Local LanguageSummary Employee Names in Local LanguageContent Hi All I need to display the Employee Names (Example: First, Middle and Last) in local Language (i.e. Arabic) I entered t…Shabrawi 129 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need assistance for bursting paramter4Summary: Hi Everyone, I need your assistance regarding the bursting report. I want to add a data source in my subject email but when I try to add it gives me an error. c…
-
How to get one object from a string in OTBI ReportsHi Team, We have a requirement where would like to get a particular object from a string which has _ in it. Example: This the string we have in one column Evaluation_OLC…Malla Pratibha 21 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM
-
Changes reportSummary All changes for specified fields in date rangeContent Hi, Is there a report that shows all changes in period: ID Name Effective Date Old Department New Departmen…Mike Borghoff 83 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Department Changes - BI ReportSummary Shows department changes for an associate for the current yearContent Hello, We are looking for a BI Report that shows department changes for the current year. I…Rebekah Gilday 60 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How to find the OTBI report last run history?Summary: Hi All, Need to find the history of the OTBI report last run, user-wise. Content (please ensure you mask any confidential information): Version (include the ver…Haripriya 40 views 3 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM -
Dynamically logos of the different legal employer dynamically in BIPSummary: I am trying to display the logos of the different legal employers dynamically on my BI report. I created a SubTemplate folder where I store the logos The Sub Te…Consultant Ian 21 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
Authorization error with REST API to move candidate between phases / statesSummary: Content (required): Hello everybody, We are trying to use the rest api made available by Oracle to move a cadidate present in the system in the ORC module betwe…Gerardo Peluso 221 views 5 comments 0 points Most recent by Stefan v. Glabbeek Reporting and Analytics for HCM
-
Embedded content for dashboardSummary: Embedded content for dashboard Content (please ensure you mask any confidential information): Hello experts, we would like to have a page in oracle that allows …Oriana L. 14 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Query to get a data dump for a Benefit planSummary: We have a requirement to identify last updated by name and time stamp for Beneficiary related information on Life insurance plans. This is for legal reason we w…
-
Which table stores bip reports scheduled history data.Summary: Which table stores bip reports scheduled history data. Content (please ensure you mask any confidential information): Hi Team, Can some one will help me to find…