OTBI
Discussion List
-
Why do some fields break a report in OTBI?Summary: trying to create a census report with fields from multiple subject areas and many fields work together but certain fields break the report Content (required): I…Monique Dias 54 views 8 comments 0 points Most recent by Monique Dias Reporting and Analytics for HCM -
Formula for Data Submission Status in Talent ReviewsSummary: Subject Area: Workforce Talent Review - Talent Review Meeting Real Time Content (required): Hi All, We are looking to create an analysis that could be used to m…William_Johnson 56 views 4 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
AOR Templates - RecruitingSummary: I am trying to do an OTBI Report for representatives assigned with Recruiting responsibility type. However, when I add a filter for recruiting responsibility ty…Ridma Karunanathan 54 views 1 comment 0 points Most recent by Mayur Kaushik Reporting and Analytics for HCM
-
OTBI - Need Specific Assignment History along with complete salary historySummary: Hi , Client wants specific assignment history like Job Change, Dept. Change, Status change along with complete salary history. Able to get it but the salary his…
-
Report on PromotionsSummary: I need to be able to capture anyone who is transferred from a job with a job class of 'S' to a job in any other class (E, D, M, in our case). I'm looking for a …Jessica D 44 views 3 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
May I know which subject area suitable for below columns ?Summary: Hi Team, May I know which subject area suitable for below columns ? unable to find ? Thanks, Ajay Content (required): Version (include the version you are using…AjayKumar Maddipati 22 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Job code with Null profilesSummary: Hi Everyone! I am trying to create a report which should fetch the job codes with No profiles in Manage job page. I hard coded one job code which is having no p…
-
How to find the max value across multiple columns?Summary: Staff can enter up to 6 qualifications in separate flexfields in the UI. We have a requirement to report on the highest value code entered for each employee. As…
-
How to get highest value from 4 different columns for each personSummary: I am trying to retrieve the highest value from 4 fields for each person For example these four people have various values in the 4 columns (some are null) The r… -
Absence duration between dates when absence start/end spans calendar monthSummary: How to report on absences duration within a given month, even if absence starts or ends outside of that month. Content (required): We have a requirement to repo…Michelle Hughes 35 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to fetch Contract Type Description into OTBI Analysis (Work Assignment Real Time)?Summary: We have different analysis based on subject area Workforce Management -Work Assignment Real Time, and we need to add an analysis per contract type Description. … -
How to report on position changes?Summary: I work for Charlotte-Mecklenburg Schools and we are in the process of modernizing to Oracle HCM Cloud. We have asked our ERP vendor to create a report to captur…Shea Hartsell 245 views 7 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
OTBI Analysis to identify employees with missing payment method - any help appreciatedSummary: We are looking to create an OTBI (not BIP) analysis which returns employees who don't have a payment method Content (required): Our current queries are bringing…Kevin M Storrie 86 views 5 comments 0 points Most recent by Kevin M Storrie Reporting and Analytics for HCM -
OTBI - Person Disability cannot View History using Workforce Management - Person Real Time subject aSummary When using "Workforce Management - Person Real Time" subject area we are only able to return the latest Disability row for an employee. How can we see all Disabi…Derrick Campion 73 views 2 comments 0 points Most recent by Amy Wilson Reporting and Analytics for HCM
-
Formula for most recent grade name on current assignment?Summary: Subject Area: Workforce Management - Person Profiles Real Time Column: "Grade"."Grade Name" Content (required): Does anyone have a formula to pull in an employe…William_Johnson 43 views 6 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Is there a way to report on what jobs are scheduled for extracts?Summary: Content (required): We would like to have a report to list all the jobs that scheduled for extracts. At this moment, after we schedule an extract, we lose visib…Sergio Burgos 12 views 1 comment 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Inability to view the National ID information in the report by the employee,how should we proceed?I have an excel report that I prepared with BI publisher, and this report contains the National ID information I got from the PER_NATIONAL_IDENTIFIERS table. But the use…Cansel Karasoy 291 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Seeded Line Manager DashboardsSummary: Does anyone know where the seeded line manager dashboards are pulling it's data from. When a line manager runs the headcount report then it shows a headcount of… -
Filter Active and Null Values of Assignment Status in Position FTE OTBI ReportSummary: Filter only Active and Null Values of Assignment Status in Position FTE Content (required): We are trying to filter only Active and Null Values of Assignment St…Manoj.Gupta 127 views 6 comments 4 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to add new tab for infolets?Summary: We want to add new tab similar to HR helpdesk and My services in the Analytics area of homepage. We have the links to add new infolet, but how to create a new p…ManishaSahoo 95 views 2 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Unable to join the UDT subject area to the Assignment subject areaSummary: Unable to join the UDT subject area to the Assignment subject area Content (required): In the OTBI side, we are referring two subject areas. Based on Terminatio…
-
How to fetch the direct and indirect report details in OTBI based on manager details parameterSummary How to fetch the direct and indirect report details in OTBI based on manager details parameterContent Hi, We are in REL 13 20D. I am working on the Performance r…Radha Devi P 726 views 4 comments 0 points Most recent by User_9B8T4 Reporting and Analytics for HCM
-
Compensation Details (Top of Stack) when End DatedSummary: Hi - We are looking to create a report where we are able to audit active employees where their salary was incorrectly end dated. The problem is that when the sa…Kyle Norris 71 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How can I get an interaction to filter on 2 columns at once?Summary: I have created a graph to show male/female by Grade level. I created an interaction to drill down to a report, however the interaction is only filtering on eith…Dannielle Dellucci 42 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM
-
Report to get the list of employees with multiple active relationshipsSummary: Report to get the list of employees with multiple active relationships Content (required): Hi Team, Greetings! With Global Transfer- there are some cases observ…Parag Hiremath 278 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Is there a way to encrypt the scheduled reports?Summary: Is there a way to encrypt the scheduled reports Content (required): We are looking into scheduling reports but we need to make sure there is an encryption in pl…Balazs Grajczar 76 views 6 comments 0 points Most recent by teresa.marciano Reporting and Analytics for HCM -
Payroll Element and Related Elements InformationSummary: Payroll Element and Related Elements Information Content (required): In the Payroll Element screen we have Related Elements. We need to know in which table/subj…
-
SQL for Element Status Processing RulesSummary SQL for Element Status Processing RulesContent We are looking for a SQL to display element status processing rules where we attach the element to a fast formula …User_2025-02-01-07-38-26-148 164 views 2 comments 0 points Most recent by Piyush Pokharkar-Oracle Reporting and Analytics for HCM -
Bursting Query table from the reportsSummary: Bursting Query table from the reports Content (required): Hi Team, Greetings! Is there any table(s) which holds the queries included in the bursting query in th…Parag Hiremath 335 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Best practice for reporting on incomplete allocated checklists?Summary: Hi All, Does anyone have any "best practices" for reporting on incomplete allocated checklists? We have a business case to report on number of incomplete checkl…William_Johnson 62 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM