Category 81
Discussion List
-
Hello, has anyone tried creating a report in OTBI or BIP that displays an employee's most recent ratContent (required): Hello, has anyone tried creating a report in OTBI or BIP that displays an employee's most recent rating as well as their historical rating (Performan…Hazel De Castro 11 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Where can I find Product and Segment from the financials side (default expense account) in OTBI?Summary: I want to join HCM data with expense account data Content (required): I need to be able to pull in the Product and Segment from the default expense account (or …Monique Dias 22 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Calculate Percentage based on Running Sum displayI'm displaying a running sum for minority hires and overall hires from month to month. I want to calculate the % of minorities to hires for each month based on the runni…Susan Anderson 71 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Benefits Report Etext template question?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
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
-
Extract Comment after Hiring Transaction or other transactionSummary: Extract comments after hiring transaction Content (required): Extract comments after hiring transaction as show in the image Version (include the version you ar…teresa.marciano 2 views 0 comments 0 points Started by teresa.marciano 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
-
Difference between primary assignment flag and primary flag in per_all_assignments_m tableSummary: Hi , Can anybody let me know what is the difference between primary assignment flag and primary flag in per_all_assignments_m table. How these two columns behav… -
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…
-
Manager ID population logic using Peoplesoft PS_JOB dataSummary: Hi team, We have a Oracle DWH built using Peoplesoft as a source system. One of the key requirement is to populate Manager Lev1, Manager Lev2, Manager Lev3 usin…Shaik Gousimiya-Oracle 43 views 4 comments 1 point Most recent by Shaik Gousimiya-Oracle Reporting and Analytics for HCM -
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
-
Recruiting DEI ReportingWe are trying to create a TA / Recruiting-based DEI report that necessitates requisition details, candidate details, and some sensitive DEI data elements (gender, ethnic…Brian Kress 53 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to display multiple values in seperate columnsWe're creating a report with employee data and part of the report are e.g. e-mailaddresses. When e-mail type is part of the report, the result is multiple lines, but we …Wouter.Schaap 22 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Plan Balance query - Carryover, Accrual etc ?Summary:I need to create a report that replicates the data from the Plan Balance screen - which tables? Content (required):I need to create a BI Publisher report that ha…ScottHillier 822 views 8 comments 0 points Most recent by ScottHillier Reporting and Analytics for HCM
-
Filled Requisition > Hired Employee OTBISummary: Wondering if anyone has a solid analysis that indicates which filled requisition a hired employee came from? (Even if they arent still in the same job that they… -
BI Publisher Date parameterSummary: How can I format a date parameter to a TZ string? Content (required): Which variable should I use to populate a date parameter with 2023-03-10T00:00:00.000+05:0…
-
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 -
How to pull in correct payroll number of employees in BI Publisher reporting?Summary: I have put together a query where my joins for payroll number are bringing some duplicate lines into my record. On investigation, the joins are not bringing the…
-
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…