Category 81
Discussion List
-
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 61 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 101 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 331 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 91 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 31 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 31 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 41 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 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 …
-
Is there a way to report on user accounts being created?Summary: I want to audit when new user accounts were created, by whom and possibly which roles are assigned to the user account Content (required): I'm looking for a sub…Matti Bugge 31 views 3 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 -
What is the Subject Area for Things to Finish (which are displayed on the user home page)?Summary: We have a requirement to show the count and Details of Assigned to Me under Things to Finish (which are displayed on the user home page) in an OTBI dashboard, s…Bhukya Vamsi Naik 21 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
-
Equate a node from Root Data Group and a child Data Group on EText for HCM ExtractHello Experts, Have you tried anything like this in etext template & HCM Extract combination? I have a node in my Root Data Group "Emp_DG' that I want to equate with a c…Aloka Bhattacharya 12 views 0 comments 0 points Started by Aloka Bhattacharya 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 -
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
-
Impossible to open an OTBI reportSummary: Impossible to open an OTBI report Content (required): Hello experts, we have seen that, since a couple of weeks, a specific user is not able to open a report an… -
Recruiting - recruiting real time subject area not giving expecting dataSummary: We built an analysis using Recruiting - recruiting real time subject area while extracting the data we will able to get only Open Phase information However we w… -
FAST FORMULA PER_PERIODS_OF_sERVICE ATTRIBUTE_DATE1 DBII want to find the database item that the Attribute_date1 field in the per_periods_of_service table corresponds to for use in the Fast formula, but I couldn't find it. C…
-
how can I get one 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, …challa praveen 269 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM