Category 81
Discussion List
-
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 12 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 13 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 33 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 22 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 65 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 22 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 217 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 52 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 52 views 3 comments 0 points Most recent by PatriciaS-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 33 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 22 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 14 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 42 views 4 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
OTBI Subject Area Contents Listing (metadata)How do we provide our users with a user-friendly listing of the contents in each Subject Area? Or, at least, how or where do we get the data necessary to build one? This…Eric Geddes 31 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Termination Reasons & Salary in Workforce Trend to measure TurnoverSummary: When adding Termination Reasons (Action Reason), the terminations sum up correctly, but the Headcounts are inaccurate. Salary data doesn't populate. Content (re…
-
Looking for a YTD payroll reportSummary: I need to create a report showing YTD payroll. Content (required): Report needs to contain employee demographic detail along with current pay rate, YTD earnings…Scott Conaway 344 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
Which Subject Area to use for Assignment EITSummary: Which Subject Area to use for Assignment EIT Content (required): I cannot see any subject area field showing "Assignment EIT Information EFF: Assignment Extra I…Hrms Project 44 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Simple sample report: persons processed during a payroll flowSummary: This BI report lists person number and person name for payroll flows in which person records would have been processed. We had a requirement to be able to dump …Shant Sarkissian_NES 61 views 2 comments 2 points Most recent by Bhaskar Konar Reporting and Analytics for HCM