Category 81
Discussion List
-
How to pull data from Human Capital Management and Workforce Management subject areas?Summary: How can data from the Human Capital Management Approval Notification and Archive Real Time and Workforce Management Person Real Time subject areas be effectivel…Basti 42 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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 292 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?
-
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 -
OTBI Report: 360 feedback: details of the questionnaire answers + overall ratingSummary: Hello, Has anyone create an OTBI Report regarding 360 feedback: details of the questionnaire answers + overall rating? Can you please share a catalog for this? …Hazel De Castro 33 views 3 comments 0 points Most recent by Satheesh Nesamani 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. 120 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 32 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Custom column not prompted correctly in drill-down reportSummary: Custom column not prompted correctly in drill-down report Content: Hi, I have created a dashboard with different analysis about Hires & Terminations (analysis p…Yves Blanc 74 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
We have developed OTBI Report issue with output formatSummary: Hi Team, We have developed OTBI Report but issue with output format that is when try to export the report in csv or excel we getting multiple records please fin…AjayKumar Maddipati 32 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How can I have a data model for Line Managers with Inactive - Payroll Eligible status?Summary: The organization decided to just use one BU. In so doing, there are expense reports generate and managers have not assigned to the new BU. Content (required): W…
-
Benefit Certifications tableSummary: We have a requirement to fetch "Certifications" tab related data in the BIP report. May I know in which tables holds the information on certification? Content (…Satyabrata Nanda 51 views 5 comments 2 points Most recent by Viral Abotiyawala-Oracle Reporting and Analytics for HCM -
Inaccessible Column Error When Running OTBI Report DashboardSummary: Inaccessible Colum error while running OTBI reports Content (required): Reports run fine for few users role but for few user/groups tried to run shows Inaccessi…
-
Find courses not completed in a specialization - Activity SequencingSummary: Hi, I have reviewed the article which mentions this OTBI report for specialisation. This works for us in the PROD instance where we have not enabled Activity Se…Sathesh Ramaswamy 63 views 2 comments 0 points Most recent by Sathesh Ramaswamy Reporting and Analytics for HCM
-
how can I get correct seniority date when multiple seniority dates are there for a person in OTBISummary: I am reporting from Workforce Goals - Goal Status Overview Real Time and Workforce Management - Person Seniority Real Time. When I have Seniority Date showing, …User_2025-07-18-06-45-42-477 104 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI if Grade is Null those employees are not fetching in the report.Summary: We are adding version 3 seniority dates in OTBI existing report, added new subject area "Workforce Management - Person Seniority Real Time" when using filter co…challa praveen 72 views 8 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
How to display the value to be in line using BI Publisher (rtf)Summary: We want to display value in line from the RTF Template. However it displays as per below. Content (required): Please find attached RTF Template and XML Version …Aries 327 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle 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 -
Data Security Policy Mapping for Leads in the UI and OTBISummary: Using different security in OTBI to HCM Cloud Content: Would it be possible for you to give me an example of this solution: https://community.oracle.com/custome…Cassiano Carneiro 32 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Which tables do these search results belong to?Summary: When I search Subject Areas the result contains duplicates. Content (required): How do I know to which presentation tables the search results belong, and how ca…Maboagamo 32 views 11 comments 0 points Most recent by Gail Langendorf-Oracle 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 43 views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle 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 31 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 92 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 42 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…