Reports
Discussion List
-
How can I write a SQL query in Oracle Fusion Cloud to identify unapproved requisitions?Hi everyone, Please see the full question below. How can I write an SQL query in Oracle Fusion Cloud to identify unapproved requisitions where a specific approver (e.g.,…FlatFish534 23 views 1 comment 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
How to achieve Flexible Hierarchy Selection in Management ReportingHello Community, We have a requirement related to dynamic hierarchy selection in our account reporting structure. Our account hierarchy is structured as follows: AC1000A…
-
[OTBI] "Workforce Performance-Performance Check-in Real Time" SA - unexpected behaviour on filtersSummary: Hello, I have following OTBI analysis : SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Workforce Performance - Performance Check-In …MariaStanciu 11 views 0 comments 0 points Most recent by MariaStanciu Reporting and Analytics for HCM
-
Required table to get Ad Hoc resource name in activities under OfferingsSummary: Hi All, We need a table to get Adhoc Resource name, quantity and description in activities under Offerings in fusion HCM Content (please ensure you mask any con…
-
How can I join the hz_parties table to a project number or contract number table using sql.Hi everyone, I'm creating a work-in-progress report that tracks project costs and needs your help joining several Oracle tables efficiently. I'm working with: PJF_PROJEC…
-
Management Reporting - Member from one dimension to show up as header in another dimensionSummary: In management reporting, we have two dimensions on row, one attribute and standard dimension. We would like the members in attribute dimension to show as header…
-
Insufficient Privileges FA_FUSION_SOAINFRA.WFUserVacationSummary: Getting Insufficient Privileges Error when running below query SELECT * FROM FA_FUSION_SOAINFRA.WFUserVacation SELECT * FROM FA_FUSION_SOAINFRA.WFUserVacation I…Fazil_Shahid_Khan 61 views 6 comments 0 points Most recent by Fazil_Shahid_Khan Reporting and Analytics for HCM
-
SQL code to fetch Overtime, bonus, commissions, merit increases, and locality pay for employeesSummary: Hi Experts, Please provide the SQL code to fetch overtime, bonus, commissions, merit increases, and locality pay for employees. Thanks. Content (please ensure y…
-
How to get employee's co-worker-style contactsSummary: How to get employee's co-worker-style contacts Content (please ensure you mask any confidential information): Hi Experts, Is there any query/tables to get emplo…
-
Manage Geography Hierarchies REST API throwing 401 errorSummary: Hi I am getting an 401Unauthorized error while testing the Manage Geography Hierarchies REST API in postman with valid credentials. API : /hcmRestApi/resources/…
-
We are currently unable to achieve consistent formatting in both the Excel and PDF in FRS reports.Summary: We are currently unable to achieve consistent formatting in both the Excel and PDF in FRS reports. Specifically, we need to center-align the headings in the gri…QuantumPulse1009 21 views 2 comments 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
Can we reference the Consolidation method to pick Ownership % to multiply with the entities?Currently, we have 2 Columns in a Report in Narrative Reporting - one is Bottom members of CurrentPov for Entity in one grid & Consolidation % which has a totally unique… -
Need to know the logic behind the seeded report parameters of Payables Trial Balance ReportSummary: Just wanted to know the logic behind seeded 'Payables Trial Balance Report' parameters which are mentioned below 1.Include Bills Payable 2.Negative Balances Onl…SireeshaJaladi 112 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to report for those absence leave requests which are in denied statusHi, Can you please suggest how to report for those absence leave requests which are in denied status. Thanks in advance. -
How to fetch data from transaction console table for ICP entry which is not approved ?We are trying to fetch details of ICPs which are in submitted status(not yet approved).The details which we are trying fetch is person details, ICP type, option , date w…
-
Reporting Field for Acknowledgement Comments on Performance ReviewSummary We would like to know the field name (if reportable) for the comments entered by an employee when acknowledging their performance review.Content We have a busine…User_2025-01-30-23-46-38-098 76 views 6 comments 1 point Most recent by Aprajita Gokhale Reporting and Analytics for HCM -
Is it possible to download personal surveys created in Oracle HCM?Summary: After creating surveys using the Create-Survey quick action in Oracle HCM, I need to download them, displaying the following data:1) Assignee Name2) Survey Name…LorellaUccello 31 views 0 comments 0 points Most recent by LorellaUccello Reporting and Analytics for HCM
-
Required table for component group rules setupSummary: Hi Team, Could ypu please provide us the table where payroll component group rules stored in oracle fusion Payroll module Setiup name > Component Group Rule. fo…
-
Query to link between State and component group ruleSummary: what is the link between component group rule and this state through SQL query or backend table. We got one table HZ_GEOGRAPHIES where GEOGRAPHY_TYPE = 'STATE' …
-
BI Publisher Packages in Datamodels for ReportsSummary: In Fusion ERP, several BI Publisher reports use packaged procedures within the data model. For example, the Fixed Assets Reserve Summary and Detail reports refe…Swapna Alluri 14 views 0 comments 0 points Most recent by Swapna Alluri Reporting and Analytics for ERP
-
Can we use invalid custom 'From email address' for BI Report Notification?Hi Everyone, We are trying to personalize 'Email From Address' for BI Reporting Delivery. We have changed 'Email From Address' by navigating to /xmlpserver → Administrat…BinduTammineni 1 view 0 comments 0 points Most recent by BinduTammineni Reporting and Analytics for HCM
-
SKIP ROW based on an attribute in one sheet of a multi sheet excel templateSummary I have a summary and detail excel template. I need to suppress rows which have a value of zero on one particular attribute of the row.Content I have inserted the…User_2025-02-05-18-28-58-388 185 views 12 comments 1 point Most recent by Bal C. Reporting and Analytics for ERP
-
Convert member formula to Groovy scriptHi All, I have multiple Dynamic currencies in ASO cube of EPBCS and they have member formulas. I am planning to convert this member formulas to Groovy and store. I am fa…Sukrut 21 views 1 comment 0 points Most recent by Vijay Mahantesh-Oracle Profitability and Cost Management
-
Getting Critical Alert when loading the HDL using the ExtractSummary: Hi experts, Here I had a requirement to call a custom report using the HCM extract that call the report and loads the data in the Fusion. Here I have provided t… -
I am trying to get te work schedules of the inactive employees via analysis reportSummary: Work Schedules - if employees are inactive, their work schedules are missing from the analysis Content (please ensure you mask any confidential information): We…Claudia Linares L 41 views 4 comments 0 points Most recent by David Vaughan-Watkins Reporting and Analytics for HCM -
Conditional Region for Pictures on BI PublisherSummary: Difficulty Applying Conditional Region for Displaying Different Logos in BI Publisher Word Add-In Content (please ensure you mask any confidential information):…
-
Excel cannot open the file worksheet.xls because the file format or file extension is not validSummary: Hi All, In a lot of area like the application table, there is function to export the data to excel. But we hit a problem for few users. Some users doing export …Yeung Shing Keith 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Learn Module | SQL query to get specialization details , module name, offering name, enrolled learneContent Hi All, I am working on a report where I need to fetch specialization details and its' corresponding module name, offering name, enrolled learners, current statu…