Global HR
Discussion List
-
Succession Permission AuditSummary Succession Permission Audit ReportContent Is it possible in Oracle HCM to create a report showing all plans, and the individuals who have Succession permission f… -
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. … -
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 83 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 41 views 6 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM -
View Extract Results task not showing any instances which has ran post 23A upgradeSummary: View Extract Results task not showing any instances which has ran post 23A upgrade Content (required): User does have access of payroll admin data role and payr… -
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 396 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
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… -
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 103 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… -
table to pull the error details from transaction console.Summary: Hi All, I'm trying to build a report and looking to pull the error details from transaction console. I tried searching tables but I'm not getting the info, can …vamshi krishna-283622 471 views 8 comments 0 points Most recent by Arun Menon 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 41 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 360 views 4 comments 0 points Most recent by Volodymyr Faranosov 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 426 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Function to convert accented characters to their plain ascii equivalents in BI reportSummary: Function to convert accented characters to their plain ascii equivalents in BI report Content (required): Function to convert accented characters to their plain… -
Can the parameter affect both the row and the column in the Matrix report prepared from the analysisI have a matrix report that I use on the Dashboard screen, and the column information consists of job name information. The row information is also from the locations. a…Cansel Karasoy 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Subject Area for Override LocationSummary: We have a requirement to query 4 different types of address for employees. HOME, US Resident Tax, Work Location and Override Location addresses. I am able to qu… -
Analysis error - Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PSummary: Analysis of 3 Subject areas, if no prompts are selected, produce report, when selecting a prompt, analysis result in error Content (required): Analysis of 3 sub… -
Subject Area for Workflows & Approvals?Summary: I need to do a review of all of the Workflows & Approvals, and would like to be able to export them all, as is to avoid going through each one, one-by-one. Is t…Jessica D 363 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How do you enable My Report tab for employees?Summary: How do you enable My Report tab for employees? Content (required): What is the privilige that you need to use in order to enable My Report tab for employees? Ve…
-
How to get the termination action/reason for the report with benefit details?Summary: I have an OTBI report built with benefit details. I need to add employee's termination reason/action for that report. Content (required): I cannot find a benefi…Ayesha Iroshani 381 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
HCM Extract: No Output when Fast formula is added to ExtractHi Team, I need to get the Assignment Effective Start Date based on some conditions using a Fast Formula. My fast formula is working fine because I wrote logs for each f…Chaitra Lakshmi Krishna 31 views 2 comments 0 points Most recent by Chaitra Lakshmi Krishna HCM Extract -
I have requirement to send outbound files from HCM Extract to SharePoint.Summary: I have requirement to send outbound files from HCM Extract to SharePoint. Can someone provider me documents/pointers if this is done before by anyone? Content (… -
Division showing blank for Performance task status real time subject area in OTBISummary: Org tree columns showing blank value in OTBI due to new org tree version Content (required): We have activated our new tree version from 1st jan 2023, since the… -
Salary Range Report ALL Jobs (Active and Inactive)Summary: I have a requirement to produce the below OTBI report but if I use the Compensation Salary Detail Real Time, it only shows data if an employee is assigned to th…JHaden3 101 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need to display complete History related Employeement changes for the previous and current valuesSummary: Need to display complete History related Employeement changes for the previous and current values Content (required): We need to display complete history employ…