Global HR
Discussion List
-
Sending Bursting pdf as an e-mail body instead of outputI have a notification work that I have prepared, the report returns table type employee data and absence detail.I can send this tabular report as a pdf output, but I wan…Cansel Karasoy 39 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Expand Issuing comments in Document Record Notification email templateWe are currently working on expanding the comment box for document record email notifications and BPM work lists, as the current character limit does not align with the … -
Looking for a Workflow transactional Report where Self Approval is enabled.Hi Team, I'm Looking for a Workflow transactional Report where Self Approval is enabled. Either the report should let me know about on which workflow rule self approval …
-
Extract description of lookup in OTBISummary: Content (required): Hi everyone, we are having problems extracting the value of a dff configured for the JOB. Is it possible to extract the description of the r…Gerardo Peluso 7 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to capture an end date on Individual Compensation element?Summary: How to capture an end date on Individual Compensation element? Content (required): I am trying to award compensation to an employee in the form of a sign on bon… -
OTBI Report is not giving results.Summary: Hi Everyone! Workforce management - Worker Assignment Event Real time I am using above subject area to create a report but when i click results, i am getting " …ShawShankk 2.1K views 9 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Impact on DBI's when we move from Seniority date V2 to V3Summary: We are planning to move to V3 version of seniority dates functionality. We are in V2 and since we can still access V1 we are using DBI' referring V1 Table (Per_…User_2025-07-18-06-45-42-477 172 views 3 comments 0 points Most recent by Unknown Human Capital Management
-
What HCM table can I use to get the future Line Manager?Summary: I'm checking if I can use the BIP Bursting feature to send details which includes tasks to the worker's future LM once the transfer is approved. The client want…
-
Pension and annual salary data in one reportSummary: Hi, We are trying to build a report which provides information on an employees pension and annual salary. The report is built combining subject areas. When comb…NusratB 30 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Which tables store the Weekly Working Hours data?Summary: Which tables store the Weekly Working Hours data? Version (include the version you are using, if applicable): 23BLuke.Findex 70 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Where can the admin find a saved transaction (departments in this case)?Summary: Where can we find a saved transaction? Content (required): Dear experts, we started creating departments with Manage Departments in FSM and as we missed some de…Oana C 22 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Assignment Start Date Explained?Summary: Could an Expert help me understand how when Adding Assignments to a person, the Assignment Start Date field works in the Workforce Mgmt Subject Areas? The issue…
-
Extract the ID of a department (going active on 01 october) from FusionHello, In Fusion we have created a department that will become active on the 1st of October. For our integration with Taleo I need the Department ID of this department a…
-
Query Slower after patch Favoring Full Table Scan (FTS) instead of Index ScanSummary: A report built to get the timecard details (OTL query) is suddenly running for a very long time after the recent patch was applied. It does full table scan rath…Nisha_Hegde 22 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
Assignment and Person Information for Whole Employee PopulationSummary: Hi - I have created a report that is supposed to pull in a combination of Assignment data, comp data, work relationship and person real time information (4 subj…Kyle Norris 17 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table name where department set is storedSummary: Table name where department set is stored Content (required): Was looking to build a query based on Department set, which table department set is stored. Versio…Bhavna-Civeo 1.6K views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to query email of a user account which is not linked to any person record?How to query email of a user account which is not linked to any person record? In this case person id can be null in per_users table and we can't join it with per_email_…Ankit_Bhadja 1K views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPSummary Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPContent Hello, Looking for a quick help, please. Searched the archives but could not fin…SantoshKumarBhairi 202 views 12 comments 0 points Most recent by Ninja Reporting and Analytics for HCM -
New tab on the home page of Oracle HCM (Me | My team | My client Group | My reporting) - languageSummary: New tab on the home page of Oracle HCM (Me | My team | My client Group | My reporting) - text depending on language Content (required): Hello, I am creating a n…Jacqueline GRANDIN 110 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Assignment Changes including Effective SequenceSummary: Hi - I have a logical SQL built that is looking for changes in a DFF field that do not take place on a Sunday. It is supposed to capture the changes between row…
-
Identify all actions/pages that contain Business TitleSummary: I need to identify all actions/pages that contain the Business Title in order to hide them, because client doesn't have them updated. Content (required): Versio…Stela Martins-Oracle 26 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
what metadata I should use to transfer Goals and performance doc while global transferring employeeSummary: I am looking to load transfer Goals and performance doc for person though HDL. Content (required): Metadata to transfer Goals and performance doc while global t…Sushant Srivastava 8 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
unable to create new jobSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):H_Rasheed 6 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
calculate the past experience in HCM BI ReportSummary: calculate the past experience in HCM BI Report Content (required): My client requirement is to calculate the past experience and current organization experience…
-
Absence - Shift start and end time can be 24 hours format ?Summary: In the Create Work Shift page(Set up -> All tasks -> 'Work Shifts' -> Create Time Shift -> Start Time), the current system allow us enter the time in the HH:MM …Faqir 99 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
Report on Prior Visa InformationSummary: I needed help with BIP SQL code that can help me extract prior visa information for employees. Content (required): Currently if an employee has multiple visa in…Rohan Fernandes 28 views 8 comments 0 points Most recent by Rohan Fernandes Reporting and Analytics for HCM
-
Payroll-Personal Payment Details Real Time Target Bank Account is Null but not "IsNull" in the fieldSummary: Content (required): We are trying to find all the employees that have missing Bank Account Numbers or Bank Sort Codes We are currently using Payroll - Personal …
-
Poor performance with CASE statement and sub-querySummary: Custom analysis with CASE statement extremely slow Content (required): Good afternoon, I have created an OTBI analysis that yields the names of line managers wh…ammiano 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Audit ReportHi Experts, Can we have an audit report in the system on employee details change which included any change relevant to employee assignment, DOR and personal info etc.
-
Job Code Usage ReportIs there a report shows the last time an associate was in a given job code. We have a number of job codes with no one in the title. It would be helpful to know if the jo…Rebekah Gilday 16 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM