Reports
Discussion List
-
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 Chidella-Oracle 239 views 3 comments 0 points Most recent by Reddykrishna Chidella-Oracle 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.7K 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…
-
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 121 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 28 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 39 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 261 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 24 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 25 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 Chidella-Oracle 50 views 4 comments 1 point Most recent by Reddykrishna Chidella-Oracle 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 56 views 2 comments 1 point Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Need inputs to display data in a single record for each employee if an employee is having multiple aContent Hi All, We have a requirement to display Person, Visa and assignment details through OTBI. As of now we are using below two subject areas to achieve this require…
-
Session Timezone in BI PublisherSummary BI publisher not using the timezone from the Account screenContent I've found that the CURRENT_DATE in BI Publisher isn't applying the timezone entered on the us… -
While scheduling setup name file based on parameter. Is that possible?Summary While scheduling setup name file based on parameter. Is that possible?Content Hello, is there a chance to have the file name dynamically setup based on parameter…Nicola Petri 19 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
OTBI Agents and BI publisher scheduling us there a Report displaying the active scheduling ?Summary OTBI Agents and BI publisher scheduling us there a Report displaying the active scheduling ?Content Hello , We would like to have a list of the existing active a…Revital Mefano 43 views 12 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM
-
SQL query help needed - Payroll tablesSummary Reporting on those employees who have had a garnishment added in the selected payrollContent Hi All, I hope someone is able to help me out. I am trying to debug …User_2025-02-04-08-51-08-912 19 views 1 comment 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Report by Performance Task countSummary Report by Performance Task countContent Currently have a query that reports out current status of performance task: Employee Self Evaluation, Manager Evaluation,…User_2025-01-29-19-46-35-367 77 views 2 comments 0 points Most recent by User_2025-02-06-15-04-02-124 Reporting and Analytics for HCM
-
BI Report - Need to display Date Time in User TimeZone in excel template - But always displaying UTCSummary Trying to display Report Run Time in User TimeZone, but unable to do itContent The requirement is to display the Date and Time in user Timezone. I came across fe…Rajesh Ravikumar 34 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Headcount by Age Band in Workforce Trends Real timeSummary Unable to count headcount by Age Band as compared to other attributesContent Hello Experts! I'm hoping this is an easy one! I'm trying to report Period End Headc…Rob F 85 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Scheduled Report Returning only 25k rowsSummary Scheduled Report Returning only 25k rowsContent I have an OTBI report that i am running that has output greater than 25k rows but less than 65k rows. I thought i…User_EQ8R5 84 views 4 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM