Reports
Discussion List
-
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 14 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 33 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 475 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 15 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.4K 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 32 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 21 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…
-
OTBI Archiving/Unarchiving dashboards across environmentsSummary: OTBI Archiving/Unarchiving across environments – Dashboard Migration successful but Action Link Drill‑Through Not Working Content (please ensure you mask any co…Clare Murtagh 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
If a new dimension is added to a report do we have to rebuild books?We have to add a new attribute dimension to our reports every year. When we were on-prem we did not have to then go update the books that contrain the reports with the n…
-
How to remove Home / Catalogue line from dashboard?Summary: I need to hide the line from a custom dashboard (not a BIP report) Content (please ensure you mask any confidential information): Version (include the version y…Stefano_Mazzocca 22 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Narrative PPT Package and Data Grid rendering quality issueHi, Checking in to see if there is any progress in fixing the image quality issue with Report data grids that are embedded in a PPT package? We've tried the suggested wo…
-
after 26.06.95 -> reports page takes a lot of timeHi, After applying patch 26.06.95, we’ve noticed a significant slowdown when accessing the Reports page. Before the patch, the page loaded significantly quicker, but now…
-
Deleting multiple reports at onceSummary: How can you delete multiple reports in one go? Content (required): Hi all, Our reports (approx 50) are put in a folder structure. As we want to delete all of th…
-
BIP report or data model for fetching the data of all the employees with their Hire date, terminatioSummary Can anyone help me with BIP report or data model for fetching the data of all the employees with their Hire date, termination date, rehire date along with depart…User_2025-01-29-01-34-30-592 197 views 3 comments 0 points Most recent by UdayShinde_Suavis Reporting and Analytics for HCM -
SQL not fetching pending worker created in last 1 hourSummary: SQL not fetching pending worker created in last 1 hour Content (please ensure you mask any confidential information): Hi All, There is a BIP report with burstin…Gayathri K M-Oracle 43 views 6 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
How to prevent embedded reports from resizing off the page after a refreshSummary: I am looking for advice on an issue we are experiencing with PowerPoint-based report packs. We are using report packs with embedded reports and have row suppres…
-
Hi Experts, having a requirement to send debrief estimates to Service request contacts.Summary: I am unable to get joins between debriefs(depot repair ) , Service request and RMA orders .I tried joining RCL_DEBRIEF_HEADERS. parent_entity_id with RCL_PARTS_…
-
exceeds the maximum limit error even after using filterSummary: exceeds the maximum limit error even after using filter Content (please ensure you mask any confidential information): Hi Team, Greetings! We are getting below …Parag Hiremath 12 views 3 comments 0 points Most recent by Meenakshi K Reporting and Analytics for HCM -
How to add Analytics section to homepageWe've been trying to embed some infolets on our Oracle Cloud homepage, however it appears that most users (at least it seems that way based on Cloud Connect posts, YouTu… -
Unable to Generate report in Financial Reporting CenterHI, When I give the parameters and try to Generate the Trial Balance report from Financial Reporting Center am getting the following error: Error executing query: Error:…Abeshek VP 23 views 3 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i…