Reports
Discussion List
-
Project Performance Reporting OTBI ITD Actual Cost balances overstatedSummary: Hi, In Project Performance Reporting in the UI, the ITD Actual Cost balances are correct, however in my OTBI report the ITD Actuals balances are overstated. To … -
Annual salaries for current and terminated employees in one reportIs it possible to create a report with just a list current and terminated employees and their annual salaries? -
Is there any standard report for document of record audit fields?Hi, After 26A the audit field (Last updated by) of the screen "document of record" are not visible anymore. For audit purposes, HR administrator needs to view this infor…Lynda Ramos 12 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to edit Organization Code?Summary: Content (please ensure you mask any confidential information): Table HR_ALL_ORGANIZATION_UNITS_F has a field named "ORGANIZATION_CODE". It has the following val…Stefano_Mazzocca 17 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
How to grant access to OTBI without granting access to datamodelSummary: Although a custom reporting role strictly restricts the user from creating or editing Data Models, a security gap allows them to delete existing Data Model obje…
-
Integration issues with EPM post 26.07 updateSummary: We are finding some of our existing integrations into EPM have broken post 26.07 update Content (please ensure you mask any confidential information): Is anyone…John_H_FusionApps 300 views 29 comments 0 points Most recent by Ija Vidaurri EPM Platform and Freeform
-
Negative numbers, positive numbers and Percentages do not align properlyPlease refer the screenshot below. the numbers do not properly align and this is mostly the problem for negative numbers in brakets. The align prefix and suffix have bee…
-
Open Detailed Report when you Right-Click in FormsWe have a Manage Department Requests form where they can put in their own Requests I have added a right-click menu option so they can open and print report depending on …
-
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…Dasari Dileep 383 views 12 comments 0 points Most recent by ParthivAVT Reporting and Analytics for HCM
-
Technical Specialization BI Pub ReportHello everyone, We need to create a BI Publisher report to retrieve the Technical Specialization for each employee. For this, we need to extract all technical specializa…Andriampeno Odilon 51 views 9 comments 0 points Most recent by Andriampeno Odilon Reporting and Analytics for HCM -
Web Forms opened in SmartView IssueSummary: Web Forms opened in SmartView is showing Zero values in Blank Formula Rows and Columns. Anyone has experience the same? Content (please ensure you mask any conf…Kenneth John Asper-Oracle 74 views 5 comments 1 point Most recent by Kenneth John Asper-Oracle Financial Consolidation and Close -
Not able to join 3 subject areasSummary: We would like to build OTBI report but will require to use 3 Subject Areas: Workforce Management- Person Real Time Workforce Learning -Learning Records Real Tim…RodrigoRamirez 14 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Query to retrieve Opening Lease Liability calculations for Migrated LeasesSummary: Query to retrieve Opening Lease Liability calculations for Migrated Leases Content (please ensure you mask any confidential information): Per the Lease Migratio… -
Reporting agent is not working as expected on the report gridSummary: As per the 26.07 patch Reporting Agent will be available to enter natural language requests but it seems not working in our application. Content (please ensure …
-
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 95 views 18 comments 0 points Most recent by Jayanthi Shetty Reporting and Analytics for HCM -
Way to calculate Standard deviation in a reportThere is a requirement from customer they want to use standard deviation on account for Current Year (Jan to Dec) month along with Previous year(Jan to Dec) using STDEV.…
-
Usage of AIF_TARGET_APPL_MEMBERS in FCC CloudHello, We have a requirement to get member alias in data exports & currently we have used AIF_TARGET_APPL_MEMBERS to solve this problem in Non-Consolidated report. We ha… -
Why is Print Receivables Transactions ESS Job picking up seeded template?We have customized the seeded report. The Seeded report can be found under 'Shared Folders/Financials/Receivables/Bill Presentment'. The report name is "Invoice Print Te…
-
What’s New in EPM Cloud Narrative Reporting and Reports Release 26.07What’s New in EPM Cloud Narrative Reporting and Reports Release 26.07 Please refer to the July 2026 What's New Guide to understand the new features included in Cloud EPM…Dave Roberts_-Oracle 107 views 10 comments 1 point Most recent by Dave Roberts_-Oracle Narrative Reporting -
PBCS Report Formulas Not Updating When Rows Are Inserted or DeletedHello, I am experiencing an issue with a report in PBCS. Some rows contain formulas that reference other rows by row number. For example: [4] + [6] The problem is that w…
-
Any way to do a programmatic replace report in report packages?Summary: Need to do replace report in a large number of largely homogeneous report packages - any way to achieve this efficiently? Content (please ensure you mask any co…
-
Transaction console approval Transaction history report for Resignation and Termination transactionSummary: I need to Create the Resignation/Termination approval report which should include EMP ID, Name, Resignation Date, Last working date, Submitted by, Submitted dat…Maulik.Chavda 11 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Unable to see the Supply Chain Financial Orchestration tile under Supply Chain ExecutionI can see the links to the redwood pages here, However, I cannot see the tile in any of the regions as shown below, Can you please help with this? I have access to the d…Sai Shashank 10 views 1 comment 0 points Most recent by Deepak Pai-Oracle Supply Chain Financial Orchestration
-
How to set static/Dynamic password generation for PO-PDF in Oracle FusionSummary: How to set static/Dynamic password generation for PO-PDF in Oracle Fusion A requester received a Purchase Order (PO) change notification, which included the PO …Shweta Prakash Veer 1 view 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Virus Scanner Not Reachable - Unable to Archive Files in My Folders / Shared FoldersSummary: Content (please ensure you mask any confidential information): Hi, We are encountering an issue when trying to archive files in My Folders and Shared Folders. E…Sankalp Shukla 1.8K views 12 comments 1 point Most recent by Ganesh Kamath Reporting and Analytics for HCM -
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …
-
Uploaded Daily Rates QuerySummary: Need to create a report for the uploaded conversion daily rate in the GL. Content (please ensure you mask any confidential information): Hello, We have a requir…Mamdouh Ahmed 11 views 3 comments 0 points Most recent by User_OUC03 Reporting and Analytics for ERP
-
We need a query to get Payroll Balance group usages mapped to Balance dimensionSummary: Hi. We need a query to get Payroll Balance group usages mapped to Balance dimension. When dimension changes(Quarter, Run, Month… ) then the Balance group usages…