Reports
Discussion List
-
How to report on "Job Description" from "Job Profile"Summary: I need to report on job description and effective start/end date within each job [model] profile, but i can't seem to find it from BI. I tried to query few tabl… -
permissions to view only some reports by usersmy user should be able to see only Compensation and not the others. I have already created a role and assigned it but still nothing. I create this role and associate my …CamillaRossi 52 views 5 comments 0 points Most recent by Mohammed.Dawoud Reporting and Analytics for HCM
-
Sql query to get cost code effective start date and effective end dateSummary: Sql query to get cost code effective start date and effective end date Content (please ensure you mask any confidential information): Version (include the versi…Anup Karmankar 65 views 18 comments 0 points Most recent by Anup Karmankar Reporting and Analytics for HCM
-
adding different manager types to analysis reportsHello there, I have prepared a report from the analysis and in this report I would like to see the types of managers that people are affiliated with, such as head and ex…Sinem Kara 21 views 4 comments 0 points Most recent by Girish Kushibi Reporting and Analytics for HCM
-
Need a report to pull time change request details for time and laborSummary Need a report to pull time change request details along with manager comments for time and laborUser_2025-02-04-07-00-18-658 44 views 3 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM -
Submitted Timecard and Web Clock Details ReportSummary: Need to SQL query for view the detail of submitted timecard and web clock's reported hours and schedule deviation with custom attribute. Content (please ensure …Melek Cinar 463 views 6 comments 0 points Most recent by Melek Cinar Reporting and Analytics for HCM -
Need to generate a sequence number in outbound file at BIP. How to achieve thatSummary: Need to generate a sequence number in outbound file at BIP. How to achieve that Content (please ensure you mask any confidential information): Need to generate …Ishtiaque AHmed 24 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Please Help with Audit approval QuerySummary: The auditor has requested the dates of the last updates made to our Audit approval rules for the following areas: Job Offer Job Requisition Approval Termination…Global Support Desk 15 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How can the seeded compensation dashboards below for managers be customized?Can anybody suggest the right way to edit these seeded dashboards and do the customization based on our company needs. The need is to Add/ remove parameters Add/ remove …Sameeksha MN 12 views 3 comments 0 points Most recent by Sameeksha MN Reporting and Analytics for HCM
-
report /audit to track any changes done to auto provisioning rules(HCM role provisioning rules)Summary: We need to get a report /audit for any changes done to auto provisioning rules(HCM role provisioning rules). Please help us on how to achieve this requirement. …
-
Can report schedule can trigger notifications based on the notifications triggered in last 24hours.Summary: We have a requirement, where 2 reports are developed. And the first report is triggered manually and for the second report scheduling is required. Is there any …Gowthami Gorantla 21 views 2 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Cost of absence sicknesSummary: Report to show cost($ amount) of employee leave balances Content (please ensure you mask any confidential information): Hi Team, We have developed a report for …Thomas Samuel19 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
FDI format date field to MON-YYHello, In FDI I'm trying to format payroll action effective date as a period format 'MON-yy'. TO_CHAR is not a recognized function, I tried a CASE statement for WHEN Pay…
-
How to Generate a Unique Reference Number for Each Report in Oracle Fusion HCMHello Oracle Community, We have a requirement to generate a unique reference number for each report generated in Oracle Fusion HCM, specifically for documents like lette…Harish Vummidi 39 views 1 comment 1 point Most recent by Ishtiaque AHmed Reporting and Analytics for HCM -
PDF available for Tables and Views for HCMSummary: Is PDF option available for Table and Views i see there is no option to download. Tables and Views for HCM Content (please ensure you mask any confidential info… -
How do I define the dashboard prompt to include date range on the same columnSummary: Need help in defining the dashboard prompt to include date range on the same column, for example: date range on hire date and how to incorporate in BI Publisher…Surabhi Kumari 306 views 9 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Need a report which can provide details if any scheduled job runs and BI report run got missed.Hi Team, We have a requirement in place that if any report schedule and job schedule got skipped due to any reason then we need a BI or OTBI report by which we can track…Sanchit_Jauhari_2211 29 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to customize seeded Payment Register ReportSummary: How to customize seeded Payment Register Report Content (please ensure you mask any confidential information): Hi All, We got a requirement to add new columns i…Venkatesan 99 views 6 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
OTBI to show future effective datesSummary: Hi Community, Please refresh my mind: how to make the OTBI to show future dates from EFF table? Thank you, Alvaro Couto Content (please ensure you mask any conf…Alvaro Couto 24 views 1 comment 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
Table / View for New Features and Opt In Features?Summary: Is there a table / view that can be queried via BIP which would allow us to create a report of all of the implemented and non implemented features as seen in th…Monica Fundak 42 views 6 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
How can we create a distribution list in Oracle fusion Bi publisher?I need to share a custom report with multiple users through the following steps: Schedule → Output → Destination Does anyone have any idea about configuring a distributi…
-
Position Hierarchy ReportContent (required): Looking for BI report to get the current logged in person's position and the positions under his hierarchy. Version (include the version you are usin…Nivya Mathire 93 views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Document Category is salary infomration notification issue redwoodwe have DOR with Document Category, which is salary information. For this DOR, we have created a DFF. When employee submits DOR, line manager cannot see DFF values in ap…
-
In Oracle Fusion HCM, eText template with UTF-8 character set converting space to special character.Hi Community, I am facing an issue in eText template with UTF-8 character set, whenever for a field if it has space as a value it's converting space to special character…
-
Some Employee missing of the Reports on certain dateSummary: I want to explain the issue we encountered. On December 10, the HR team uploaded a change affecting all employees in a specific department, effective December 1…Lucas B Maciel 21 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Is it possible to find deleted checklist details?Summary: Is it possible to find deleted checklist details? Content (required): Hi All, For one employee, one check list has been assigned and deleted by someone. I verif…
-
Copying OTBI reports in bulkSummary: Copying OTBI reports in bulk Content (please ensure you mask any confidential information): Hi Team, Greetings! There is a requirement to copy multiple OTBI Rep…Parag Hiremath 13 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Subject Area for Personal Payment Method DetailsSummary Subject Area for Personal Payment Method DetailsContent Hi All, Can any one please help me to find OTBI Subject area for personal payment method details. I have …nitin Sharma 203 views 13 comments 1 point Most recent by GopiKAutomus Reporting and Analytics for HCM
-
OTBI Analysis, Payroll - Calculation Cards Real Time - PAE - How do I show each linked assignment?Summary: I'm trying to create an analysis to report on employee Calculation Cards using Payroll - Calculation Cards Real Time and in the case of employees with multiple …Julie Searles 66 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
how long data can store fa_fusion_soainfra.wftask this tableSummary: Need information about this table how long data will be store Content (please ensure you mask any confidential information): Version (include the version you ar…Nagendra Chitra-Oracle 45 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM