Reports
Discussion List
-
Query to extract the last update date for document record fieldsSummary: Query to extract the last update date for document record fields Content (required): Hello experts, please, could you share the query to execute in order to fin…Freddy_Cerron 324 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Oracle Analytics Cloud (OAC) - Briefing Books QuestionSummary: Briefing Books Update functionality Content (required): We are trying to create a briefing book that automatically updates itself whenever changes are made to t…Miguel Cardoso 42 views 2 comments 0 points Most recent by Miguel Cardoso Reporting and Analytics for HCM
-
What table is the values in "Payroll Transfer Status" and "Payroll Processing Status" stored?The screenshot below is accessible in Team Time Cards: I was looking for how could I get the values for "Payroll Transfer Status" and "Payroll Processing Status" -
BIP Report for batch monitoring of Scheduled HCM ExtractsSummary: Feasibility of BI Report for batch monitoring of Scheduled HCM Extracts. Content (required): Would like to know if it's possible to pull Scheduled HCM extracts …Kate Calderon 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Bursting body and pdf attachmentHello, I want the message body of an e-mail I prepared with bursting to appear as follows, and I also want to add a pdf to this e-mail. How can I do that?
-
Recruitment Requisitions in Draft Not Displayed in AnalyticSummary In OTBI Answers, when querying recruitment requisitions that are in draft in Fusion, they aren't not returned.Content Recruitment requisitions that are in draft …User_2025-02-05-17-23-19-130 36 views 5 comments 1 point Most recent by Tina T Reporting and Analytics for HCM -
Employee Roster Report using subject area-Compensation Real TimeSummary: We are in need of an employee roster report built off of the Compensation-Real Time subject area, but to pull the grade and range from the Job Details area, ins…Tammy Hemmingson 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Impossible to get report output for only some usersSummary: Impossible to get report output for only some users when launching them Content (required): Hello experts, we have been having problems since November 2022 for …Oriana L. 137 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
From which table can I add the Synchronization From Position field to the sql report?Hi, I want to bring the field where Synchronization From Position field returns 'Yes,No' on the assignment details page in the employee record to my report. Which column…Cansel Karasoy 33 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Incremental Date Parameters on a Scheduled OTBI ReportSummary Have scheduled report run every Monday, for data from previous 7 DaysContent I built an analysis that has a between date parameter off of HR Event Action Date. W…User_2025-01-28-08-47-04-905 163 views 6 comments 0 points Most recent by Gourabh Choudhary Reporting and Analytics for HCM
-
How to Prevent merging columns in excel using RTF template in Fusion BIP ReportsSummary How to Prevent merging columns in excel using RTF template in Fusion BIP ReportsContent Hi Experts, How to Prevent merging columns in excel output using RTF temp…Bala Kasineedi 1.2K views 6 comments 0 points Most recent by User_67JNL Reporting and Analytics for HCM
-
Performance Task Status subject area is not pulling data belongs to old org structure.Summary: Performance Task Status subject area is not pulling data belongs to old org structure. Content (required): We have created new organization structure version in…Swati U 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need a Query to Exclude the Terminated Record after 7 daysSummary: First 7 days , The Record should show with Status= Inactive Status and after 7 days The Record should not be shown in the Report. Content (required): Version (i…MilanMohanty 93 views 10 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How can I combine multiple templates in a publisher?I have a report that returns the absence records of the people I prepared from SQL and it will work according to the absence type parameter. The report will be prepared …Cansel Karasoy 46 views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM
-
Adding Hiring Manager worker number to ORC ReportingContent Is there a way to show the requisition Hiring Manager's (from Recruiting - Recruiting Real Time subject area, Job Requisition - Hiring Team) worker person number…Christine Hill 144 views 15 comments 0 points Most recent by User_RVOUN Reporting and Analytics for HCM -
Slicing data in Workforce Trend subject area by Sales RegionSummary: I am trying to measure period start and end headcount that lives in Workforce Mgmt - Workforce Trend subject areas. I need to be able to slice it by Sales Regio…Tracy Colon 32 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Employee Count - Snapshot in Time?Summary: Is there a way to pull an employee count during a specific period in time? Content (required): Is there a report or anyway to get an employee count from previou… -
Cross subject area analysis - ErrorSummary: Content (required): Hello everyone, We are trying to create a cross analysis in OTBI using the following subject areas: Workforce Management - Person Real Time …Agapi 91 views 6 comments 0 points Most recent by Nilanjan Biswas-Oracle Reporting and Analytics for HCM
-
Are the Goals and Performance Report Dashboards shown in the Oracle Demo available as delivered?Summary: Hi Peers, Our client attended an Oracle Talent Management Demo and was besotted by the Dashboards shown by the Oracle team. Now they expect us to have these sam…S Shree 41 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to fetch Arrear balance details for terminated EmployeesSummary: Content (required): Hello, Our requirement is to fetch the arrears details for the terminated employees, adjust them accordingly. Deduction report has a section… -
Looking for Report with Absence Type and it's corresponding Display Name on a TimecardSummary: Howdy, I'm looking for a report that will list the absence management type and corresponding display name by Timecard. See screenshot below. Content (required):…David Rabalais 41 views 1 comment 0 points Most recent by David Rabalais Reporting and Analytics for HCM -
Infolet / Reporting Issue - USER.ID matching to Manager Email AddressHi all, I'm currently working on some infolets for displaying learning information for the managers to use when they load up PeopleCloud and I appear to have run into a …
-
Need to report on Document Record attachmentsContent can we report on Document Records attachments count? Has anyone done it? Can anyone share a report or any with me? Thank you in advance! Version 21BGala Meyerovich 93 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Shared folder report are not recived by users and when only through my folder recived by usersSummary: HI Team, when i scheduled through shared folder BI report are not recived by recipients and when scheduled through my folder only recived by recipients. May I k…AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to set up time period for 12 week rolling percentageIn the "Workforce Management - Workforce Trend Real Time" subject area, in the "Workforce Trend" folder, there are the following fields: I need to use these in a calcula…rd17 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Options to perform data extraction from FAW DBSummary: We are looking to perform data extraction from FAW and load into a snowflake DB for some strategic reporting solutions. Is there any recommended approach for su…Amrita Gupta-Oracle 31 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Learning Module | Sql query to get details of default assignment rules of the courseContent I have a requirement where I need to create refresher alerts for mandatory courses – based on the renewal period set for the course. Notification will be trigger…Mani Venkataraman 159 views 10 comments 0 points Most recent by User_14HUA Reporting and Analytics for HCM
-
regexp_replace not working in etext templateSummary: regexp_replace not working in etext template Content (required): We have a requirement to remove extra semicolon from the string. Using regexp_replace, we are a…Meenakshi K 413 views 2 comments 0 points Most recent by Meenakshi K Reporting and Analytics for HCM
-
Missing Work Phone TypeSummary: I'm looking at the subject area mapping, and playing with a few subject areas, but I cannot figure out how to build an analysis to see which employees are missi…
-
Can I put a link inside my Bursting query?I want to add an oracle link to send it in the mail notification in the message I print inside my bursting query, is this possible?Cansel Karasoy 51 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM