Reports
Discussion List
-
Report for failed attempted login with error messageSummary: Need to create a report for audit all the failed attempted logins with the error message. Content (required): Person number, name, date/time of login, error mes…Kumar, Nitin 13 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Registration Information OTBI columnSummary: Content (required): Hello experts, do you know the OTBI column name and subject area where finding the Legal Entity Registration Information fields? Please, fin…Valerio Curzi 11 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
WE have OTBI report On Prescreen questions but getting below errorSummary: HI Team, we have OTBI Report on Prescreen questions but getting below error only today onwords we getting (still yesterday working fine. ). Please find below sc…AjayKumar Maddipati 11 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
OTBI Report as on effective dateSummary: Want to generate OTBI report as on effective date other than sysdate Content (required): We have a requirement to fetch data as on 1 day before the current date…
-
How to fetch details from Worker Assignment Real Time Subject area as of (current_date - 7)Summary: Hi All, In an OTBI Analysis, I'm trying to fetch all the employees who has their Assignment Category changed to "Leader" in the past week. But I don't see a sub…Akhila 52 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
oracle.xdo12c.xpath.XPathException error on Payslip templateSummary: oracle.xdo12c.xpath.XPathException error on Payslip template Content (required): Hi Team, Greetings! We are getting below error for few records from Payslip tem…Parag Hiremath 11 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How extract employees work schedule assigned at different levelsSummary How extract employees work schedule assigned at different levelsContent Hi, How can we extract work schedule of employee assigned at different levels. i tried us…User_W9SIR 856 views 4 comments 2 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM
-
Audit Report for all tax code changes received from HMRCSummary: Need a report showing tax code changes from HMRC Content (required): Can anyone help with suggesting how do I go about building a report based on tax code chang…Isabela Radivoi 61 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI) -
What table to use to get data for checking the Stage Table Capacity Used for HDLSummary: I would need to build a custom alert to check if the Stage Table Capacity Used for HDL has reached over 75% . Content (required): Version (include the version y…
-
Workforce Compensation Real Time issue in production vs test podsWe created a report in our test environment and vetted it fully. Everything is being pulled from the Workforce Compensation Real Time subject area, we are not using more… -
Ability to Report on Talent Profile Strength Indicator (Content Section Completion)Summary Ability to Report on Talent Profile Strength IndicatorContent Hi All, I am searching for some information on how I can report on employee talent profile completi…User_2025-02-08-03-57-26-191 73 views 2 comments 0 points Most recent by Revanth.Rondla Reporting and Analytics for HCM -
Add a data into a domain - direct accessContent (required): I would like to be able to integrate the data "Group contract type" (see enclosed picture) directly through the domain "Workforce management - Assign…Jacqueline GRANDIN 1 view 2 comments 0 points Most recent by Jacqueline GRANDIN Reporting and Analytics for HCM
-
Line Manager Dashboard - Wrong head count displayedSummary: Our current head count is 15000, but in the Line Manager dashboard it is showing only 1200 Content (required): Version (include the version you are using, if ap…
-
Report showing employees not enrolled in benefitsSummary: Identify active employees not enrolled in medical that can be run at any time. This is not related to Open Enrollment. Content (required): Does anyone have a re…JHaden3 13 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Using SUM function in Table Type Value set using FFSummary: Unable to get the sum function in table value set and how we need to get these values in query? Content (required): Here i am facing multiple rows for each diff…Janardhan ACS-Oracle 708 views 2 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
Edit in Oracle standard absence approval notificationsHi, I want to make edits to the standard notifications in Oracle, such as changing the mail's to and cc information or the title of the mail.and I don't know how and whe…Cansel Karasoy 42 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
"Preview Offer" feature in HTML does not show correctlySummary: The "Preview Offer" task shows the Offer Letter in different formatting on different parts of the page when previewed in HTML. However, when downloaded in PDF f…Louis K.Emezina 25 views 2 comments 0 points Most recent by Louis K.Emezina Reporting and Analytics for HCM
-
Formula for NOT Current Year ("Worker"."Employee Hire Date")Summary: OTBI report - Filtering on YEAR for field name "Worker"."Employee Hire Date" Content (required): I have an OTBI report where the data returned should be for emp…
-
Extracting data using BIP Publisher Report for REST API Load (Creating Timecard)Team, We have a requirement to create bulk time entries for employees (Copying previous timecard and creating the same timecard for current week - Dates differs) and we …
-
Is there a report/subject area/table/view that pulls all role/data access auto-provisioning rules?Summary: I am in search of a way to pull in all of the active auto-provisioning role/data access rules (rule name, conditions, assignments (associated roles, associated …
-
Can we restrict otbi reports such that only manager can be able to see direct reportees?Summary: Manager should be able to see complete details of an employee who is reportee to him/her? Can we use any restrictions in otbi reports such that only manager can…Kurva Paramesh 11 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…Meenakshi K 1.1K views 6 comments 0 points Most recent by User_CTDSJ Reporting and Analytics for HCM
-
Query bursting combined with Union AllI prepared a report using more than one UNION ALL and I want to send it as a notification, for this I prepared bursting and used it from the FROM condition of the first …Cansel Karasoy 176 views 3 comments 0 points Most recent by MandeepGupta 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 128 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 164 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP - Organization HierarchySummary: Hello, Does anyone tried creating report in BIP with organization hierarchy details? For example: Enterprise Division Business Unit Department Level 1 Departmen…
-
Query to get time card approver name and approved dateSummary: I need query to get time card approver name. Content (required): I need query to get time card approver name. Version (include the version you are using, if app…Swati U 2K views 4 comments 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM
-
New hires are not showing in SQL reportSummary: New hires are not showing in SQL report. We created report by using Data model. When we export the report, there are not some new hires in it. Content (required…
-
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 11 views 1 comment 0 points Most recent by Jeremy Miller-Oracle Payroll and Global Payroll Interface (GPI)
-
Custom report to see who is listed as Read Only AccessSummary: Hi, Our Audit team would like a security report that lists everyone we have setup for READ ONLY access under Manage Administrator Profile Options Content (requi…Darrin N 13 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM