Global HR
Discussion List
-
Choosing Position PVO from BICC - PositionPVO vs PositionPVOViewAllSummary: We are implementing a data warehouse and establishing BICC data extraction pipelines. In reviewing the available PVOs for HCM Position data, there are two relev…Josh Vincent 131 views 1 comment 1 point Most recent by Aaron Leggett Reporting and Analytics for HCM -
OTBI Data.Summary: Hi Team, We are not getting any data in worker assignments realtime. Do we need to run any process? In front-end I can see all employees. and this happens our i… -
New Hired employee details with Requisition Details (Req Number, Hiring Manager, Recruiter Name etc)Summary: Sql Query to get New Hired employee details with Requisition Details (Req Number, Hiring Manager, Recruiter Name etc) Content (required): Version (include the v…Awadhendra Tripathi 2.9K views 4 comments 0 points Most recent by Gamidi Venkat Rambabu Reporting and Analytics for HCM
-
Calculating Past Experience of employees in HCM BISummary Calculating Past Experience of employees in HCM BIContent Hi; I was trying to calculate the total past experience of the employee in BI with the below formula bu…User_2025-01-22-18-29-47-758 127 views 3 comments 0 points Most recent by Vishnupriya Reporting and Analytics for HCM -
Reporting on approval transaction commentsSummary Reporting on approval transaction commentsContent Is it possible to report on the comments submitted under Attachments and Comments section for approvals not yet…Emily Robinson 154 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report for Equal Pay Registration Certificate in IllinoisSummary: Has anyone built a report for the Equal Pay Registration Certificate now required in Illinois? Attached is the template we were provided, which is missing quite…MGettman 14 views 1 comment 0 points Most recent by Jeremy Miller-Oracle Payroll and Global Payroll Interface (GPI)
-
Core HR Seeded report.Summary: Hi Expert, Does anyone one have core hr seeded report path, where I can see all seeded report. If possible, please share the document. Thank you! Content (requi…Mohammad Afghan 52 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Count of employees by Business Unit, Location and DepartmentWe need count of employees by Business Unit, Location and Department using OTBI. When we use count function, it shows same count for all business units instead of showin…Ashok Kumar Sharma 225 views 4 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
Count not coming correctAny idea why below XML is showing Column "Count as 2 " value = 2 for all business units. Column "Count1 using assignment " value = 0 for all business units.Ashok Kumar Sharma 13 views 2 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
How to query Location changesIs there an audit trail for Location changes that provides meaningful information? Someone made a change to a location and we're trying to determine who made the change.… -
How to pass login user name dynamically in the OTBI Report nameSummary How to pass login user name dynamically in the OTBI Report nameContent Hi Team, We have an OTBI report called Direct Reportees of Manager and it's working as exp…Mahendra 426 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Best fit % calculationSummary: Hi Expert, In OTBI do have have a subject area for best fit % calculation? in Talent management module. Thank you! Content (required): Version (include the vers…
-
BIP Report LOV becomes read-only when the number of characters increasesSummary: Content (required): I am trying to build a report with prompts for Degree, Certifications, Languages, Major etc. profile items. I have used SQL queries as LOV t…Akash Kiran Jana 55 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Could please help me on to find FTE cloumn in OTBI subject areaSummary: Hi Team, We need FTE column in OTBI report, I have taken worker assignment real time but I can't find out FTE column. Any help me on . PFA. Content (required): …AjayKumar Maddipati 37 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
What is the Table name to fetch Comments & Attachment posted in Allocated TaskSummary I want to know the table name which stores the comments & attachments which are added by the Approver while marking a allocated task as completeContent I want to…VinodKumar 577 views 6 comments 0 points Most recent by Stephan Steup Reporting and Analytics for HCM
-
SQL to retrieve fields for BI ReportSummary: Hi All Please share SQL query to fetch below details for generate bursting report. Thankyou, Ram Content (required): SQL to retrieve Employee Number, Employee N…RamkumarKadhiravan 73 views 8 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
How to make BI report output file (RTF template with Excel op) as non editable once it's downloadedSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
The user request exceeded the maximum query governing execution timeSummary: The user request exceeded the maximum query governing execution time Content (required): Hi Team, Greetings! We get error on OTBI report as 'The user request ex…Parag Hiremath 75 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Absence category and absence types under this category query.I need a SQL query that returns information about the absence category and the absence types connected to this category. I would be grateful for the query you can share …Cansel Karasoy 252 views 11 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
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 30 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 2 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 1.8K 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 150 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 23 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 50 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 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM