Reports
Discussion List
-
Where is WF_ROUTING_RULES located? Vacation Rules table?Content Hi, I'm trying to do reports for vacation rules and I have read I can use WF_ROUTING_RULES but or the life of me I can't find where these reside Any clues? Do I …King Jack 301 views 9 comments 2 points Most recent by Divya Mangtani Reporting and Analytics for ERP -
Period name taken as a parameter tag display in a wrong format in excel outputSummary: Content (required): Hello Everyone, I recently created a BIP report using excel with the "xls" format and using the xml exported, I ,created the report in an ex…Sushan Peiris 159 views 3 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
how to set Advanced Option on suppression rows in a specific member selectionSummary: Content (required): I have a BS reports with Accounts and Movements in rows. The select members for movement is: "Descendants of [FCCS_Movements].[FCCS_ClosingB…Gianluca Natili 11 views 2 comments 0 points Most recent by Gianluca Natili Financial Consolidation and Close -
Terms (Leavers) with Most Recent Box AssignmentSummary: We need a report and bar chart that shows terms (resignation and term-invol), NO legal employer changes, with their most recent box assignment from the Talent A…Rebekah Gilday 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Development Goals view of Top 5 for different categories - not overallSummary: HI there, I am reporting on our Development Goals using "Workforce Goals - Goal Status Overview Real Time" As there are so many goals in our system, I want to g…Stephanie McInnes 41 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to give mirror text formatting in rtf templateSummary: For one of the client requirement , in rtf template i need to show the text in mirror look. Please do the needful. If anyone tried this , please help us. Conten…SAKTHI SUNDAR 41 views 1 comment 0 points Most recent by Ankur Miglani Reporting and Analytics for HCM -
Agent for a BI report?Summary: Content (required): Hi there Is there a way to prepare an Agent for a BI report? Thanks B Version (include the version you are using, if applicable): 22D Code S…Bobby Jourdan 61 views 9 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Period Rolling Turnover by Employment CategorySummary: I am trying to get a rolling turnover by employment category. This analysis doesn't change any value even if I provide the assignment category filter. The resul…Anita 32 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Identify the list of reports that a custom role can accessWe have 100s of custom reports within our /Shared Folders/Custom BI catalog folder structure. We have quite a few custom HCM security roles and each custom folder & repo…Pradeep T U 82 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to calculate percentage of Employees with more than 5 hours of learning?Summary: I need to get the percentage of Employees with more than 5 hours of learning for a specific time period in OTBI. So far, I have: a counter for employee names to…A Geyne 42 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Custom report permission with Custom RoleSummary: Hi We have requirement where we wants to give a custom report access to all of the employee of the company. Our organization in using all custom role (Custom Em…Manisha Gupta 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Legal Employer LOV not populating while running EEO ReportsSummary: Hi All, While running the EEO-1 report, I am not able to find any Legal Employer coming in the dropdown. We have 3 LEs in the system and in other actions, I am …Gaurav Rath- PGC 63 views 1 comment 0 points Most recent by Abhishek Tiwari, CPP -Oracle Payroll and Global Payroll Interface (GPI) -
What’s New in EPM Cloud Narrative Reporting and Reports Release 22.12What’s New in EPM Cloud Narrative Reporting and Reports Release 22.12 Please refer to the December 2022 What's New Guide to understand the new features included in EPM C…Dave Roberts_-Oracle 31 views 0 comments 1 point Started by Dave Roberts_-Oracle Narrative Reporting -
Add 2 Report Measures: Dept Active FTE and Vacancy Rate %Summary: I have an Analysis that calculates vacancy rate by department. I need expert advice on how to add two measures to the pivot table. I want to add a measure "Dept…
-
Is there a limit to the number of columns in a data modelHello, I’m attempting to create a report using a SQL based data model. It has about 90 columns but when I run the report it leaves off the last 2 columns. Is there a lim… -
Non-Aggregating Statistical Accounts and Weighted Average in Sparse DimsOk Team... We have a variety of Workforce statistical accounts that we want to report out of an ASO Cube (we technically push the data from WF to FS, then report out of …
-
We develop new custom report but we getting some of employes have two recordsSummary: Hi Team, We develop new custom report but we getting some of employes have two records due to terminattion date actuallyin ui no termination date but some have …Maddipati Ajay Kumar 32 views 4 comments 0 points Most recent by Maddipati Ajay Kumar Reporting and Analytics for HCM -
SQL Query for Supervisor/Employee Hierarchy with Both Direct and Indirect ReportsContent I have a task to create a BI Publisher report and attach additional data from different tables based on the bottom level employees. I am wondering if anyone has …Brian Todd-Oracle 1K views 2 comments 0 points Most recent by Suhitha K-Oracle Reporting and Analytics for HCM
-
Need to Restrict Employees of a Tax Reporting Unit(TRU) in ExtractSummary: We need to copy a seeded report, Run Third-Party Periodic Tax Filing Extract, and add an object group that will allow us to run the report for specific TRUs (we… -
How to get location for position in OTBISummary: How to get location for position in OTBI Content (required): I tried using location name column under Position folder from position real time subject area but i…Swati U 193 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
we have head count nearly 9000 employees and coming to this report only showing 5700 plus employeesSummary: Hi team, we have head count nearly 9000 employees and coming to this report only showing 5700 plus employees may i know how to check the issue. person real time…Maddipati Ajay Kumar 54 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
GL Value set DFF's are not available in SmartView/ FRSSummary: GL Value set DFF's are not available in SmartView/ FRS. Please let me know is this standard functionality. My client want to track this. Let me know we have ano…User_2025-02-12-18-40-30-943 91 views 2 comments 0 points Most recent by User_GRG5N Reporting and Analytics for ERP -
Need to capture the details under Mobility in "Skills & Qualifications " pageSummary Need to capture the details under Mobility in "Skills & Qualifications " pageContent Hi Experts, Need a help. Need to retrieve the following data for a person. N…Aloka Bhattacharya 67 views 6 comments 0 points Most recent by Shampi Reporting and Analytics for HCM -
Secured List View - How it works in a BIP ReportSummary: Hello, Is there any documentation or white paper on how secured list view works in a BIP report? Content (required) We used secured list view in our BIP query t…Hazel De Castro 981 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
which subject area we get father/husband names in OTBISummary: Hi Team, we need data employees of father and husband names so could please assitance on. Content (required): Version (include the version you are using, if app…Maddipati Ajay Kumar 42 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Not able to find column as Pending changes in Position subject areaSummary: Not able to find column as Pending changes in Position subject area Content (required): In manage position, we have "Pending Changes" column. see attached. Does…Swati U 47 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I calculate Absence Sickness for Employees for 4 absences of 3 days or more?Summary: I need to produce a report for employees that have had more than 4 sickness absences of 3 days or more within a rolling 12 month period. I have managed to creat… -
How do I run a report on average age of employees?Summary: I need to run a quick report on the average age of employees in the whole organisation and per Legal Employer. Content (required): I have the report with employ…User_2025-03-10-21-26-28-299 35 views 1 comment 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM