Global HR
Discussion List
-
BPM Worklist ReportSummary Help on creating BPM Worklist ReportContent Hi, We currently have several requests regarding the BPM Worklist Report in Fusion HCM. Do you have any idea on how t…User_2025-01-29-01-38-21-058 255 views 8 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
No fact table exists at the requested level of detail - Ethnicity IssueSummary: Hi - We have a roster report for our whole employee population and I was trying to tweak the ethnicity section to account for the many scenarios of if they choo… -
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 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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 51 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 1 view 0 comments 0 points Started by teresa.marciano Reporting and Analytics for HCM -
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 81 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 375 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 101 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 465 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 341 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 414 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 376 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 (…