Reports
Discussion List
-
Need query to pull finalised or processed pay period namesSummary Need query to pull finalised or processed pay period namesContent Need query to pull only finalised or processed pay period details?ViswanathaReddyKetireddy 30 views 2 comments 0 points Most recent by ViswanathaReddyKetireddy Reporting and Analytics for HCM -
call Dashboard from HCM page -how to keep BIP paramsContent MY BIP report has two params (one dependent on another). I need to create a dashboard and display the dashboard under 'My Client Groups'. I did it all. However, …
-
Last Update Date in OTBIContent Hi, Can someone help me to find where to get Last Update Date for "About This Record" in Person tab for "Extra Information". Flow will be go to Person=> Extra In…User_2025-02-07-19-03-14-525 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Current Performance Task by Org TreeContent Hello, I feel like this is a tough one to figure out. I have an analysis where I isolate the current performance task on a performance document. I'm trying to en…Rob F 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
New hire report - Need to remove Global Transfers with changes afterwardsContent Hello, We are creating a new hire report that would show employees with a work relationship start date within the past year but we do not want to include global …Shanna Oppenheim 41 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
-
BI Publisher - tracking of an email notificationSummary Schedule Report JobContent Hi All, One of users has complained about some of their scheduled processes not sending email notification even though she filled up t…Alvaro Couto 80 views 6 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Log for emails sent through scheduled Reports jobContent Hi, We have scheduled a report job. So some are going under failed. Can i know how to fetch log daily how many reports are successfully sent and how many were fa…User_2025-02-10-17-13-07-021 40 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
HR Help Desk report availabilitySummary Looking for recommendations and examples of reports for managing HR Help DeskContent Does anyone have any tips or suggestions for creating reports for HR Help De…Len M. 39 views 10 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
How to calculate next Anniversary date in OTBISummary How to calculate next Anniversary date in OTBIContent Hi All, How to calculate next Anniversary date based on the employee hire date? Example: Number Hire date N…Reddykrishna 243 views 3 comments 0 points Most recent by Reddykrishna Reporting and Analytics for HCM -
HCM Audit tablesSummary Need to find a table where audit information will be stored.Content Hi All, I need to find the tables where audit data is stored. Columns such as Data, User, Eve…User_2025-02-10-16-28-01-402 1.5K views 2 comments 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM
-
Multiple rows converted to columns grouped by employeeSummary Would like to display multiple phone types by column instead of having separate rows for each oneContent Hi - I am creating a report that shows specific phone ty…
-
SQL query to get net pay amount of an employee on the monthly basisContent Hi All, Creating an outbound interface where need to fetch the employee's monthly net amount. Hence, need SQL query for the same. Context: Employee have multiple…Arti P 3.5K views 8 comments 0 points Most recent by Gopikrishna Nerella Reporting and Analytics for HCM -
How to convert numbering format from Indian currency to Dutch (10.13 t0 10,13) to OTBI Report.Summary How to convert numbering format from Indian currency to Dutch (Amount 10.13 to 10,13) to OTBI Report.Content Hi All, We have a requirement to convert amount/curr…User_2025-02-10-16-28-01-402 40 views 5 comments 0 points Most recent by Ninja Reporting and Analytics for HCM
-
Disclosure for DiversitySummary Diversity TrendContent Hi Experts, We are trying to track diversity eg. Gender , ethnicity, Sexual Orientation, Disability etc over time Has anyone attempted thi… -
Reporting on "In Progress" Talent Review MeetingsSummary Talent Review ReportingContent Is it possible to pull talent review meeting data on meetings that are still "In Progress"? Right now all of our meeting notes and…User_2025-01-28-08-47-04-905 112 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Date & time of SubmissionSummary Date & time neededContent Hi, Is there a way to know the exact time and date the 360 review and performance review was submitted?Thanks AndrewVersion 20BUser_2025-02-05-22-44-35-842 20 views 4 comments 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
Is it possible to create a BI report to search for a string in all the log files for the parent scheContent We submitted a Synchronize Person Assignments from Position and it internally spawned 25 processes. Instead of looking into the individual log files, we wanted t…User_2025-01-22-19-57-39-723 29 views 2 comments 0 points Most recent by User_2025-01-22-19-57-39-723 Reporting and Analytics for HCM
-
Employee Headcount by Business Unit BI Publisher reportSummary Employee Headcount by Business Unit BI Publisher reportContent Hi Experts, I'm looking BI Publisher ( not OTBI since Headcount is not properly setup in our organ…User_2025-02-07-19-03-14-525 40 views 6 comments 0 points Most recent by Ninja Reporting and Analytics for HCM
-
OTBI agents - update mass recipients list?Summary OTBI agents - update mass recipients list?Content Hello , In OTBI agents is it possible to update by an upload the recipients list of a mass of agents ? (Since w… -
Neel help schedule a BI reportContent How Can I schedule a BI report on daily basis and deliever it to an email address provided? Any help/Guidance will be much appreciated. Version 20BMegha Patel 26 views 12 comments 0 points Most recent by Megha Patel Reporting and Analytics for HCM
-
Need to know KFF Deployed person nameContent Hi All, We have "Deploy Flexfield" option in cost Allocation Key Flexfiled. We need to know the person name who deployed the flex field. In "FND_KF_FLEXFIELDS_VL…
-
BIP user based logicSummary filtering population based on running userContent Hi all. My salary and payroll report is a BIP one and currently i have 7~8 versions of the same data model with… -
Employee Salary ReportContent Is there a seeded report (or a custom report you would share), that includes the wages for a period (entire year), including the employee name, date of hire, tot…Annette M 258 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Creating a ReportSummary I am looking to create a report in OTBI for when a Domestic Partner and/or Domestic Partner Child is added to the following coverages: -Medical -Dental -VisionCo…User_2025-02-11-00-58-38-371 25 views 3 comments 1 point Most recent by User_2025-02-11-00-58-38-371 Reporting and Analytics for HCM
-
Download approval rule reportContent Good day colleagues! Could you please tell if it is possible to download file with this address: hcm/hrc/db/data/HcmCommonTop/HcmCommonTransaction/ApprovalCompos…Kristina Serikova 24 views 2 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM -
Dashboard is empty when selected option Printable PDF or Printable HTMLSummary Dashboard run empty when selected the option export entre dashboard or printable PDF or Printable HTMLContent Hello, I have a dashboard build out of BI Publisher…
-
BI report to extract Status information for Absence ManagementSummary Any pre build report to extract absence type and status information for Absence Management?Content Hello, If anyone has any pre build report/query to fetch the d…
-
Need help on Logical SQLSummary Need help on Logical SQLContent Hi , I have added three columns to existing logical sql OTBI, After adding the three new fields report format has changed, Can an…Reddykrishna 51 views 4 comments 1 point Most recent by Reddykrishna Reporting and Analytics for HCM
-
OBIEE SQL and Listagg functionSummary Need to display a list of degrees and certifications in a list for a reportContent Hi all, I am trying to produce a list of certifications and degrees for each e…User_2025-02-04-08-51-08-912 54 views 2 comments 1 point Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM