Sample Reports
Discussion List
-
User Access Report (v2) API has only POST command available currentlySummary: One of our clients has requested the GET command for the user access report. Could you please let us know the expected timeline for its availability? Content (p…Swathi Gutta-Oracle 31 views 3 comments 4 points Most recent by Swathi Gutta-Oracle Reporting & Analytics for Sales -
report /audit to track any changes done to auto provisioning rules(HCM role provisioning rules)Summary: We need to get a report /audit for any changes done to auto provisioning rules(HCM role provisioning rules). Please help us on how to achieve this requirement. …Jagadesh S 92 views 5 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Latest data changes are not reflecting in the OTBI report immediatelySummary: Hello All, We have an AOR drill-down OTBI report, but the latest changes to data are not reflecting immediately. For example, when we assign an AOR to an employ…Nusrat Shaheen 91 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Reporting on Payment ApprovalsSummary BI Publisher or OTBI Report to extract Payment ApprovalsContent Hi Community Are there are any BI Publisher or OTBI Reports available to report on Payment Approv…Kunal Daya-175386 199 views 5 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
HCM OTBI Filter by Legal Employer of current userSummary: Hi Oracle community, i am fairly new to OTBI specifically in HCM OTBI and would like to check how to achieve in adding analysis filter to get records where lega…JSalarza 161 views 7 comments 0 points Most recent by Challa Ramya-Oracle Reporting and Analytics for HCM
-
Sample report (preferably OTBI) of candidates that have applied using multiple emailsSummary: Does anyone have a report (preferably OTBI) of candidates that have applied using that one email. In essence, same candidate name and address applying with mult… -
Unable to add a new field to oracle seeded report "Payable Trial Balance Report"Summary: We have a requirement to add a new field "Vendor_name_alt" to seeded report (Payable Trial Balance Report), after added new field and ran ess job it is throwing…SireeshaJaladi 51 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Join required between exm_expenses and pjc_exp_items_all tablesHow do I join from exm_expenses and pjc_exp_items_all tables in Fusion. Do I need to join through other tables also to get this link? Thanks Scott
-
Is there a table which stores Absence balance for future date of and incremental planSummary: We are looking for a table or sql query which gives Absence balance as on future date. Absence plan is incremental, and accrual process will run for every bi we…
-
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 & …Amarnath 6.2K views 17 comments 0 points Most recent by Mostfa Shehata Reporting and Analytics for ERP
-
OTBI Map exampleSummary: OTBI Map example Content (please ensure you mask any confidential information): Hello experts, does anyone have an example of an OTBI report with a Map view? Th… -
Subledger Period Close Exception ReportSummary Subledger Period Close Exception ReportContent I am seeing these transaction on the Sub-ledger exception report as per below table. 1. Does this means they were …
-
Service Usage Metrics Report for EPMSummary: One of our customers has requested the Service Usage Metrics Report for EPM (Hosted Named User, Hosted Employee, Records, and Hosted Employee details) from OCI.…Swathi Gutta-Oracle 42 views 2 comments 3 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
RTF Template File Size Limitation in OLC CertificationHi Team, In the Oracle Learning Cloud (OLC) module, I’ve created an RTF template for course certifications. The template includes six different certificates for six diff…
-
Oracle BIP Report Excel template output displaying Number values as TextHi, We have created the new custom BIP Report with Excel template and when we download the report output into Excel, then all Number values are displaying as text, these…Nagaraju Vandavasi 63 views 5 comments 0 points Most recent by User_26T18 Reporting and Analytics for ERP
-
BIP Vs OTBI What is the practicality of moving BIP reports to OTBI?Summary: I am recommending that my client investigates the possibility of using OTBI in preference to BIP for their reports (including whether this is just for new repor… -
Procure to Pay DashboardsSummary: Procure to Pay Dashboards Content (required): How can these be added to the home dashboard once the user is login, instead of going to reports and analytics and…
-
Need sample query to get Original transaction number from credit memosSummary: Need sample query to get Original transaction number from credit memos Content (please ensure you mask any confidential information): need to know about the bac…MayuriMMote 251 views 3 comments 0 points Most recent by Mohamed M. Faramawy-Oracle Reporting and Analytics for ERP
-
Unable to proceed to create Dataset using webservice in Oracle BIP ReportSummary: Unable to create dataset with Webservice while creating custom BIP report Content (please ensure you mask any confidential information): below are the steps to …SireeshaJaladi 121 views 6 comments 1 point Most recent by Sri Prasanth Reporting and Analytics for ERP
-
Document of Record Drill to Document DetailsSummary: This report uses Deep Links for Document Records to navigate directly to the worker's DOR from the report results without additional clicks or navigation. Conte…Melanie Mahon-Oracle 191 views 4 comments 7 points Most recent by Samantha Collins Reporting and Analytics for HCM -
segregation of dutiesIs there a report for segregation of duties for Finance?
-
How to display date in the format (like April 1st 2025) using RTF tags.The requirement is to display the date like April 1st, 2025 in the RTF Template using RTF Tags.Nalsoft Pvt Ltd 41 views 3 comments 0 points Most recent by Hari Haran Reporting & Analytics for Fusion Service
-
the end date of assignment is 4712for the previous assignmentHi, Currently just Working on one requirement where i encountered a scenario is(Using Per_all_assignments_m) The person has four Assignments Active employee where the en…Kande Likhitha 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…SireeshaJaladi 1.1K views 18 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for ERP
-
How to Import a signature and logo in UCM Server and Export a signature and logo in RTF TemplateSummary A requirement is to upload logo in UCM server and access that logo in RTF Template by using Payment Format(Check printing))Content A requirement is to upload log…Arpita Saha-137995 730 views 10 comments 1 point Most recent by User_P8MK7 Reporting and Analytics for ERP
-
Project Period Close Exceptions DashboardSummary Project Period Close Exceptions DashboardContent Project Period Close Exceptions Dashboard - Anybody created as shown in release document. Attached screenshot -
I need a query which will fetch Percentage of completed performance reviews with highest ratingsSummary: I need a query which will fetch Percentage of completed performance reviews with highest ratings Content (please ensure you mask any confidential information): …
-
Query to get import/update customer in Oracle Fusion based on load request IDI am trying to import/update customer and wanted to get import error messages for those customer through the BI report. But getting few error messages even the customer …Zaid123 32 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Does BI Publisher SFTP delivery connection support with Azure SFTP server ?Does BI Publisher SFTP delivery connection support with Azure SFTP server ?KabirB 31 views 3 comments 0 points Most recent by Z-Man-Oracle Reporting & Analytics for Fusion Service -
Cash Flow Statement Generation - FRS or Other Reporting ToolsSummary: Cash Flow Statement Generation - FRS or Other Reporting Tools Content (please ensure you mask any confidential information): Hi Experts, Please advise as to whe…Nicole Deleon 21 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP