Sample Reports
Discussion List
-
Sample OTBI Report and Dashboard Workforce Compensation moduleSummary: Content (required): Hello experts, our customer want to see some delivered OTBI Analysis and Dashboards for workforce compensation module. I've tried to open th…Valerio Curzi 501 views 16 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Excel template with summary and Detail and Detail sheet should split in to multi sheet, need helpSummary: Excel template with summary and Detail and Detail sheet should split in to multi sheet, need help Content (required): Excel template with summary and Detail ( D…Dineshkumar.A-Oracle 1 view 1 comment 1 point Most recent by KISHAN BUSSA Reporting and Analytics for ERP -
Number of days an employee works in the departmentHi, In our setup, an employee can work in different departments. For this, I need a SQL query that returns information on how many hours an employee works in a departmen…Cansel Karasoy 21 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Pull email for Eligibility Last Updated By field for Performance Document Eligibility subject area?Summary: Field + subject area: Content (required): Hi All, We are using the following subject area to pull information: We are pulling in this field from the subject are…William_Johnson 11 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Is it possible to add a new filed in data model query of Payable Trial Balance seeded report?Summary: We have a requirement to get Supplier name in Arabic in Payable Trial Balance report. User don't want to customize the seeded report as they are using same repo…SireeshaJaladi 151 views 8 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
In Approval Notification Assignment number needs to be hidden as Part of workflowSummary: Hi Folks, In Approval Notification Assignment number needs to be hidden/removed as Part of workflow notification. Kindly help me with action plan to sort out th…Sowmiya Velusamy 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Project Budget Cost vs ActualSummary: Project Budget Cost vs Actual Content (required): What would cause a Project Budget carry forward cost to reflect a change than what was reflected at the beginn…
-
IS it possible to extract report on total number of self downloadable the report in employees folderSummary: HI Team, in this path Shared>Custom>employee -folder we placed the self downloadable letters so we need to extract report on total number of self downloadable. …AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
How to get the list of users who has downloaded a specific report in HCM Shared folderSummary: To get the list of users along with time, who has downloaded a report from HCM Folder Navigation : Shared folder --> Pick any report --> Open the report --> Exp…Siva Sankari N 61 views 3 comments 1 point Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
SQL query need to be debugSummary: Hi all, The Query which I run is showing the field names and the data is not populating. please help me to debug the error. Content (required): Outer joins need…RamkumarKadhiravan 12 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
Activities of an offering is not shown in backend tablesSummary: There are 2 offerings in a course that we have made and the activities of one of the offering is shown in the backend tables but the activities of the other off…
-
Duplicate person number in OTBI report.Summary: Hi Team, I am using the subject area " Worforce Management - worker Assignment Event Real Time" with below clolum and without any filter . Legislation CodeLegal…
-
Is there any bulk upload option available to assign course to employeeSummary: Is there any bulk upload option available to assign course to employee?? Content (required): Version (include the version you are using, if applicable): Code Sn…User_2025-07-18-00-17-28-232 51 views 8 comments 0 points Most recent by YASHWANTH GOWDA H R Learning
-
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 61 views 7 comments 0 points Most recent by Julian Challenger-Oracle 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…
-
Need report that shows all approval assignees who have NOT approved invoiceSummary We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)Content We a…User_2025-01-28-19-14-07-225 577 views 16 comments 2 points Most recent by DahliaG Reporting and Analytics for ERP -
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 2.1K views 4 comments 0 points Most recent by Durgadevi-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 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to retrieve the OLD payroll frequency and NEW Payroll frequency in the BIPHi ALL, Kindly support me to resolve below issue: I have a requirement to retrieve the OLD payroll frequency and NEW payroll frequency in BI report. Following with other…RamkumarKadhiravan 21 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM
-
SQL for Environmental health and safetySummary: Team, Does anyone have the sample environmental health and safety BI report (SQL). Please share Content (required): SQL for Environmental health and safety SQL …
-
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 31 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
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 1 view 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Looking for SQL query for Duty Role to Job Role mappingSummary: We have a couple of job roles and child duty roles and privileges assigned to the same job role. Can someone help me with SQL to fetch the same as we need to co…sailesh_cloudare 473 views 1 comment 2 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP -
query to retrieve expenditure type linked to a project, task and organizationSummary: I need to extract the expenditure type linked to a specific project, task and organization (cost center). How can I build this query? Any suggestion? Content (r…Giuseppe Galluzzo 4.1K views 14 comments 0 points Most recent by Dustin Grabowski-Oracle Project Management
-
Child account not reflecting under Parent account in Smart ViewSummary Child account not reflecting under Parent account in Smart ViewContent After creating a new account, when refreshing Smartview report I noticed Its not reflectin…
-
How to add a custom report in the custom application createdSummary: we created a custom application under ¨About Me¨ for employees but we are not able to add a custom report to display there. any idea on how to add the content i…
-
Workforce Compensation Plan delivered reports and dashboardsSummary: Content (required): Hello experts, are there any delivered OTBI analysis and dashboards for Workforce Compensation Plan module? If so, please could you share th…Valerio Curzi 1 view 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Offering/Course to visible to Pending Worker just before 30 days of joiningSummary: We are in implementation ,created course, offering, activity, added the content ,now this course or activity is applicable for Pending Worker and they should co…User_2025-07-18-00-17-28-232 41 views 3 comments 0 points Most recent by Saurabh Pratap Singh Learning