Category 81
Discussion List
-
Burst notifications are sent to inactive managersSummary: We have notifications to inform the current manager about the contract expiry dates of their employees. The OTBI was done using the Worker Assignment Real Time …Ridma Karunanathan 21 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Users with FBI_CAREER_DEV_TRANSACTION_ANALYSIS_DUTY are unable to see their own development goals.Summary: Users with FBI_CAREER_DEV_TRANSACTION_ANALYSIS_DUTY inherited by either ORA_PER_LINE_MANAGER_ABSTRACT role or ORA_PER_HUMAN_RESOURCE_ANALYST_JOB role are unable…Maciej Kozakiewicz 11 views 2 comments 0 points Most recent by Maciej Kozakiewicz Reporting and Analytics for HCM
-
Additional comments and Reason for joining can't fetch the OTBI reportSummary: Question test to response answer in Pivot Table format Content (required): Formula for Question test CASE WHEN "Checklist Questionnaire"."Question Text" = 'What…AjayKumar Maddipati 31 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Where to find in OTBI Calculation Card Start and End Date?Summary: Where can I find in OTBI Calculation Card Start and End Date? Content (required): Please see image below. I am using the "Payroll - Calculation Cards Real Time"…tiffnyc 31 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
I need to create a group or a bin based on 2 different columns. Is that possible?Summary: Group or bin based on 2 fields Content (required): I am working on turnover report and need to create groups or bins from a hierarchy tree value and a company b…Donna Valentine 41 views 3 comments 0 points Most recent by Donna Valentine Reporting and Analytics for HCM -
I have 2 parameters for analysis both are list of values on the same table - how I can write the sqlSummary: I have 2 parameters for analysis both are list of values on the same table - how I can write the SQL the will limit the lov of the second parameter Content (req…
-
BIP Report is missing the schedule - How to find the reason for the miss?Summary: We have a BIP report which is scheduled to run daily with scheduled end date in 2024. However, the report hasn't run since 15th Sep. It is not failing either. H…MandeepGupta 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How Shows/Downloads OTBI Analysis results in Excel fileSummary: Content (required): Hello Guys, We would create an analysis which extract all the candidate members inside all pools. We have a lot of candidates and for this r…Giuseppe Iacono 12 views 2 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Workforce Trend Real time subject are not giving the dataSummary: I am using workforce trend real time subject are and it is not giving the correct data when we migrate it to another instance. Content (required): We have migra…Raghavendra M 21 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
RCOUNT("Worker"."Person ID" by "Learning Items"."Learning Item Number")Summary: I am trying to fetch the latest status of a particular learning item number per employee. I have used RCOUNT and Max to fetch the data. When I filter with perso…Anita 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How can I locate which subject area the IR35 (Off-Payroll Worker Flag) is in?Summary: Trying to produce an otbi report including the IR35 flag which I think is in the Legislative Info Section of Person Management in the Person area. Can someone p…Mark Stoker 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Extract Otbi Analysis with more then 25000 LinesSummary: Content (required): Hello Guys, We would create an analysis that it extract all the candidate members inside a candidate pool. The candidate pool is very large,…Giuseppe Iacono 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Passing Prompts through an AgentSummary: Does an OTBI Agent use the hardcoded prompts? Content (required): Hi, I have an OTBI headcount report that has a hardcoded effective date prompt for the last da…Joe Dorrian 71 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Dynamic effective date on AnalysisSummary: I am trying to get active employees as of a future date in Analysis "Workforce Management - Worker Assignment Real Time" Content (required): I am able to use a …
-
OTBI>Shared Folders>Human Capital Management>Dashboards>Line Manager DashboardSummary: our managers are running the headcount report from the above location and the numbers in the top boxes esp Headcount does not equal the employee numbers in Orac…Lorrie Weiss 62 views 11 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
BIP - Talent RatingsSummary: Hello, Good day! I'm running a report in BIP but facing performance issue when I'm trying to create multiple data sets. One data set for employee details and on…Hazel De Castro 21 views 0 comments 0 points Started by Hazel De Castro Reporting and Analytics for HCM
-
Absence Summary ReportSummary: Does anyone have an absence summary report? Content (required): We are looking for a report (or better yet, and analysis) that tells us how many hours each empl…Jenna Savage 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
SQL for Costing for ElementsSummary: We are working on SQL to fetch the Element Entry details with costing information. I am finding it difficult to fetch the costing information from the Element E…Mohan Murali 243 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to habilitate 'My reporting' for HR Specialist in HCM Cloud?Summary: The tab 'My Reporting', is unavailable in our environment menu. Content (required): Greetings community! I have seen that in demo.oracle I can use the tab 'My R… -
Termination Headcount measure question.Summary: In Subject Area: Workforce Management - Workforce Trend Real Time - the Termination Headcount measure is set to 1 on the Inactive assignment line that starts th…Robert Craske 51 views 7 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM
-
Need assistance enabling icon: "Reports and Analytics"Summary: Need assistance enabling icon: "Reports and Analytics" under Tools within Oracle Cloud Application (21D) HCM Dashboard. I could not find any specific roles to a…User_2025-03-07-05-24-33-733 51 views 3 comments 0 points Most recent by Patricia-S-Oracle Reporting and Analytics for HCM
-
Different Data between Subject AreasSummary: Content (required): Hello Guys, We would create an analysis that it shows for each candidate the reason why they are rejected. We use the Recruiting Event Real …Giuseppe Iacono 31 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Export more than 30 rows from dashboardpage to ExcelSummary: Content (required): I have a few dashboard which includes an OTBI analysis. The end user wants to export all the data output from the analysis to Excel to have …Nicolas Vahman 21 views 3 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Table which stores the descr (or Meaning) of ASSIGNMENT_TYPE AND PERIOD_TYPE field valueSummary: Hi All, I see the Per_all_assignment_M have the assignment_type as one/two letter words. Which table I can able to see the descr? Same of the PERIOD_type in Per…Prabhu Krishnamoorthy 42 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Assignment Event Headcount at Start of MonthSummary: Getting the Headcount at the Start of the Month Content (required): How can we configure the Formula for the Assignment Event Headcount at the Calendar Month St…Rebekah Gilday 31 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report Interaction: Web Page Action link problemSummary: Content (required): Hello Guys, We would create a dynamic action link that give us the possibility to reach the specific page of the requisition number inside t…Giuseppe Iacono 11 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
User and Role Access Audit Report - be awareSummary: This is not a query but a heads up for users. Content (required): This delivered report does not return the values it's supposed to. Running the report with 'Al…K DeFabrizio 81 views 6 comments 0 points Most recent by K DeFabrizio Reporting and Analytics for HCM
-
oracle.xdo.template.online.dms.common.XDODmsException: IO Exception was thrown! nullSummary: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.template.online.dms.common.XDODm…
-
P45 filing dateSummary: P45 filing date in OTBI (or SQL code if not in OTBI) Content (required): Does anyone know where in OTBI I can find the P45 filed date (see bottom of screenshot)…
-
BIP Report - Performance & Potential RatingSummary: Hello, Does anyone know how can I create report out of this sample data by means of using BIP? Best Regards, Content (required): Hello, Does anyone know how can…Hazel De Castro 41 views 4 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM