Reports
Discussion List
-
Query to Pull List of Candidates and Their Supporting DocumentsSummary Query to Pull List of Candidates and Their Supporting DocumentsContent Hi Experts! Looking for some guidance. We need to build a query that lists all candidates …Lindsay Lamont 73 views 8 comments 0 points Most recent by MarkHodges Reporting and Analytics for HCM -
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 … -
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 16 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
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 416 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 53 views 9 comments 0 points Most recent by Andriampeno Odilon 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… -
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 172 views 10 comments 2 points Most recent by Dave Roberts_-Oracle Narrative Reporting -
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 56 views 1 comment 0 points Most recent by Deepak Pai-Oracle Supply Chain Financial Orchestration
-
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
-
Employee supervisor Id and Email id for cancel workship employeewhen i do cancel work relationship for the employee i need to show the supervisor id and email id of the employeeMohanaPriya 1 view 2 comments 0 points Most recent by Abhishek Premchandra BI Publisher Learning Center
-
is there a way to download the each OTBI report output from Dashboard in different formats?unable to find the option to download the report output from DashboardKiran Kumar Alle 13 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
ASE_USER_ROLE_MBR table usage restriction and alternate table suggestionSummary: Is ASE_USER_ROLE_MBR not supposed to be used for BI reporting? If yes, what is the reason, and what could be the alternate way to get the role revocation detail…VeerakumarS 44 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Process to setup a custom Process Configuration Group to a flow patternSummary: The Flow pattern is triggered to run periodically using an external service (SOAP Web Service), currently the flow runs on a default group which is "1 Thread" a…
-
Query to get Fusion Workflow ApprovalsHello, Is there a query where i can get all pending approvers for a transaction, not only the current assignee? I was able to identify the current assignee using the bel…Osama_Mo 4.1K views 11 comments 1 point Most recent by Jayanth Sarma Reporting and Analytics for HCM
-
Table/View for AP Invoice Approval History & Workflow (BPM Flow)We are in the process of creating a customized report to track the complete approval history of AP invoices in Oracle Fusion. The requirement is to fetch details of the …sailesh_cloudare 493 views 4 comments 1 point Most recent by Jayanth Sarma Reporting and Analytics for ERP -
How to combine multiple OTBI Analysis into one OTBI Analysis to generate graphs?Summary: We have requirement to create a Turnover dashboard based on the count of unique person numbers at a point in time using OTBI analysis. As the fact columns in wo…manish_yadav04 13 views 0 comments 0 points Started by manish_yadav04 Reporting and Analytics for HCM
-
How to use Hyperlink in RTF templates?Summary: Hello Experts, Is it possible to use Hyperlink in RTF templates? Like, in the report output, the Person Number attribute will have a hyperlink, once the user cl…Abhishek Premchandra-Oracle 1.5K views 4 comments 0 points Most recent by Kevin Wong Sing Ting Reporting and Analytics for HCM
-
BI Publisher Scheduled Report Not Reflecting Updated Recipient List in Oracle FusionSummary: We are facing an issue with an existing scheduled BI Publisher report in Oracle Fusion. After updating the recipient email list in the schedule, the changes are…Gurivi Reddy-Oracle 37 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
BI Catalog Folder ManagementI am looking for best practices on managing Custom Folder in BI Catalog: We have 2 folders for custom reports: Custom Folder and CompanyName Business User Reports (mostl…Ulitka 22 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticesContent This white paper provides the best practices for working with BI catalog folders, and …User720640-Oracle 354 views 8 comments 11 points Most recent by Ulitka Reporting and Analytics for HCM -
Financial Reporting Excel Export Splitting into Multiple Worksheets Instead of a Single WorksheetHi Everyone, We're experiencing an issue where Financial Reports exported from Open Workspace for Financial Reports are now split into multiple Excel worksheets based on…