Global HR
Discussion List
-
Missing Work Phone TypeSummary: I'm looking at the subject area mapping, and playing with a few subject areas, but I cannot figure out how to build an analysis to see which employees are missi… -
Can I put a link inside my Bursting query?I want to add an oracle link to send it in the mail notification in the message I print inside my bursting query, is this possible?Cansel Karasoy 51 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
How to take Length of service(in years), Service category and transfer detailsSummary: How to take Length of service(in years), Service category and transfer details? Content (required): Hi All, We got a BI report requirement to show employee's Le…
-
What does it mean to have 'INITIAL' in the 'STATE' field in the hrc_txn_data table?When I query the records with 'DRAFT' from the transaction table, the STATE field is reflected as 'INITIAL' AND 'SAVED'. What exactly does INITIAL mean?Cansel Karasoy 11 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM
-
How can I create dependent working parameters in SQL report?Hi, I have 'person number' and 'absence start date' parameters that I will use in my sql report and I have defined lov value set for them. But I want start date to come …Cansel Karasoy 51 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Tables to get the talent ratingSummary: What are the tables to get the Talent ratings(Performance rating) Content (required):Navigation Me->Directory(search for employee). Go to show more and click on…Rahul Saini 101 views 13 comments 0 points Most recent by Rahul Saini Reporting and Analytics for HCM
-
Add "Business Object Type" and "Attribute" columns to the Delete Audit ReportSummary: We had a custom report called 'Delete Audit Report' and the client wants to add columns on it for 'Business Object Type' and 'Attribute' same on what we see on …Maria Cristina L. San Jose 31 views 1 comment 0 points Most recent by Maria Cristina L. San Jose Reporting and Analytics for HCM
-
Termination Headcount MeasureSummary: Subject Area: Workforce Management - Work Assignment Event Real Time, Assignment Event, Termination Headcount calculating terms on the last day of the month in …Rebekah Gilday 91 views 5 comments 0 points Most recent by Yves Blanc Reporting and Analytics for HCM -
Assignment Event/Workforce Trends - Counting a Termination on the Termination DateContent Hello Experts! I'm using Assignment Event Real time and have noticed that terminations are counted the day after their termination date. I suspect it's counting … -
How to count terminations as effective on termination date itself?Summary Looking for ways to summarize terminations per period (i.e. monthly) based on the termination date itself, rather than the effective start date of the term actio…James Hoffmann 88 views 8 comments 1 point Most recent by Yves Blanc Reporting and Analytics for HCM
-
DATE_ADD function ErrorSummary: Hi Everyone! I am try to add specific year to the hire date using Date_add function, but it is throwing "Missing right parenthesis error". Could any one help me…
-
Procurement and Projects Folders are still available after doing Catalog Lockdown steps!Summary: Content (required): Procurement and Projects Folders are still available after doing Catalog Lockdown steps! Version (include the version you are using, if appl…Walid Hamdy 22 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Resignation/Termination Approval- Current/Pending Approver DetailsSummary: Resignation/Termination - Pending Approver Details Content (required): Hi All, There is a report requirement to show Resignation/ Termination approval -> curren…
-
Report on Employee's Time in Current RoleSummary: Content (required): We're looking to build a report that show us how long an employee has been in their current. Do anyone have recommendations or samples? Vers…Ratha Sun 41 views 1 comment 0 points Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM
-
How to take Resignation Submission date?Summary: How to take Resignation Submission date? Content (required): Hi All, Report requirement to show employee's Resignation Submission Date. From which table we can …Venkatesan 31 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Rehires are showing twice when using Seniority Years in Wrkfrc Mgmt - Person Seniority Real TimeContent (required): When I add Seniority Years (or months/days) to a report in this subject area, rehires are duplicated with one row calculating based on their enterpri…Monique Dias 53 views 5 comments 0 points Most recent by Monique Dias Reporting and Analytics for HCM
-
Report for Position Attributes change HistorySummary Looking for a report whcih can give us history of position attribute changes.Content Hi I am looking for a report to track changes in all position attributes lik…Mohit Gupta-45440 184 views 10 comments 1 point Most recent by Jesus N Reporting and Analytics for HCM -
Column order in BIP ReportSummary: Column order in BIP Report Content (required): Hi, We are trying to have specific order of columns in our BIP report (CSV output). Earlier it was word layout wh…
-
How to link Top Manager to a username within "Workforce Management - Worker Assignment Real Time"Summary: Hi all I'm trying to create an emergency contact report that allows managers to see their entire reporting line population and the emergency contact details on …
-
Need to edit Subject in Enterprise Onboarding mail- ChecklistWelcomeReportSummary: Wanted to customize the Enterprise Onboarding email subject being sent. Content (required): We want to display the first name in place of full name in the Enter…Gourabh Choudhary 51 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Unbale to get Notice Period UOM token details for Offer creation in XML file?Summary: Unbale to get Notice Period UOM token details for Offer creation in XML file? Content (required): Unbale to get Notice Period UOM token details for Offer creati…
-
Need Enterprise Onboarding Template NameSummary: Wanted to customize the Enterprise Onboarding email being sent. Content (required): We need the path of the template. We want to display the first name in place…Gourabh Choudhary 51 views 3 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
Geography Mappings in Oracle HCM CloudSummary: How is data from hz_geographies mapped to per_addresses for countries other than the US Content (required): I am working on a Peoplesoft to Oracle HCM Cloud imp…NathanParry 111 views 1 comment 0 points Most recent by Sebastien Mariller Reporting and Analytics for HCM
-
How do you remove double quote marks from a CSV file?Summary: I'm creating a CSV file to export to a 3rd party vendor. The file contains double quote marks around a few fields. The vendor does not want them. How can I disa…MorganH13 195 views 2 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
Reporting on 'Required' Field in OTBI From the Learning CatalogHello all, Does anyone know if its possible at all to report on the 'Required' section of any assigned learning to an individual? Within the Learning Catalog, we have co…
-
Can you password protect files sent out using an Agent?Summary: Is it possible to add a password to the output file for additional security that is sent out via email by the agent? It isn't needed for all situations but if w…Sarita Schumacher 42 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Privilege for ORA_PER_LINE_MANAGER_ABSTRACT to access Workforce Management - Worker Assignment SASummary: Hello, Does anyone know what is the exact privilege required for ORA_PER_LINE_MANAGER_ABSTRACT to run the data of subject area Workforce Management - Worker Ass…Hazel De Castro 51 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BI Publisher Server host and Port NumberSummary How to get BI Publisher Server host and Port NumberContent Hello Everyone, I'm unable to login to BI Publisher RTF template using following url. Does anyone know…VarunG 436 views 7 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
OTBI Analysis with suspended assignment detailsSummary: We have an OTBI analysis to capture employees' suspended assignment details and need to add the date of the that suspended assignment started. Content (required…Ayesha Iroshani 32 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Is it possible to have multiple organization trees active in core HR?Summary: Is it possible to have multiple organization trees active in core HR? What is the impact if the hierarchy is different? Does this affect reporting? Content (req…