Category 81
Discussion List
-
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 21 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 818 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 288 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 -
Error after adding another subject area to an analysisSummary: I built an analysis based on Workforce Management - Worker Assignment Real Time. Now I need to add a column from Worker Management - Person Real time. When I di…
-
Changes Only Extract not picking the ORC Promoted EmployeesSummary: What is stopping the Changes only extract not to pick the employees promoted through ORC? Content (required): We have developed a Changes Only extract which sen…
-
Folder Permissions Error in 22BSummary: Since 22B we receive error when adding or removing users to folder permissions under Custom Content (required): The following error is thrown: "Exceeded number …Janine Brown 31 views 10 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Getting an error while running a report.Summary: Hi Team, I am getting an error while running a report, please see the attached screenshot. Could you please let me know the rout causes. Thank you Content (requ…
-
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 -
how to report on job offers that are pending for approvals using workflow tablesSummary: we need to cover and track all job offers that are pending for approvals and who is the next approvers! I need to create a report covering this topic.. for the …Ayoub AFRASS 94 views 1 comment 0 points Most recent by Raghavan p-Oracle 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…