Reports
Discussion List
-
Can we restrict OTBI report 'edit' access for user to edit OTBI Analysis created by themselves onlySummary: How can we restrict user to edit only the OTBI Analysis created by themselves, provided 'BI Author Role' access has been assigned to the user and user should ha… -
Work Schedules for non-primary assignments in Person Real Time Subject AreaSummary: I'm trying to report on the work schedules for employees with multiple assignments. However the OTBI Person Real Time Subject Area / Person Schedule Assignment …Richard Kemp-Eyre 61 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Did the April or May updates mess up your grid/chart formatting?Summary: Reports we built months ago for our budget book (and really haven't touched since) have column widths adjusting, chart labels flipping from horizontal to vertic… -
Aggregate commentary entered at low levelIf a user is entering commentary at lower level entities and want to view that same commentary in top level entity maybe in a different text column, is that possible. I … -
Reports to get Service Usage in fusion HCMWe need reports for below: 1) Anonymized Authorized User Names by Service Details 2) Authorized User Names by Service 3) Authorized User Privileges by Service 4) Authori…
-
Documents about multiple reporting tools in Fusion and their usesSummary: There are several reporting tools available in Fusion (OTBI, BIP, FRS, FDI etc.). Is there any document available from Oracle which helps explain when these too… -
Certified payroll - Has Oracle provided delivered reports for certified payrollSummary: Has Oracle provided delivered reports for certified payroll? Can someone, please share any leads to achieve the requirement? Content (please ensure you mask any…Suppu 61 views 3 comments 0 points Most recent by Dhinakaran Venugopal Payroll and Global Payroll Interface (GPI)
-
Report for getting shift overlap or shift with open end dateSummary: Report for getting shift overlap or shift with open end date Content (please ensure you mask any confidential information): Hi Team, Greetings! If anyone has an… -
Need Table name to pull Time Entry Layout Component in Time and LaborSummary: Need Table name to pull Time Entry Layout Component in Time and Labor Content (please ensure you mask any confidential information): Hi, Need Table name to pull…Sujeeth Chinta 175 views 11 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Requirement to have 7 buckets in Customer Statement reportSummary: Client requires 7 buckets in Customer Statement Report. We have defined a statement aging method to have 7 buckets but only 5 buckets are visible in the report …Anand Kandasamy 11 views 1 comment 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for ERP
-
Reports text grid into ExcelSummary: Hi Team, When we try to download reports into Excel, the Text Grid is being exported as an image. However, we need it to be exported as text. Does anyone have a…
-
What table stores the system transactions reference number for Bank Statement (CE) reconciled itemsSummary: We are attempting to replicate the Cash Management Bank Statements>Manual Reconciliation page>Reconciled tab in a custom OTBI Report. For system transactions li… -
Lease Amortization Schedules Extract - How to create an IFRS schedule based on ASC842 schedule?Summary: Our client only has ASC842 schedule enabled and would like to have an IFRS schedule. We would like to utilize Lease Amortization Schedules Extract to create the…
-
Display member name instead of alias in causality for exceptionIn the causality for exception use case, currently i am getting the member alias names for the top contributors. I also tried changing the same for the account to point …
-
custom US Cheque Report repositioning when printed to a copierHi, I have built a custom US Cheque Report based upon Oracle's seeded US report. I am having issues after a test payroll is ran and converted to pdf and at that point th…
-
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha…Clifford Trett 332 views 15 comments 4 points Most recent by Namrata_20 Reporting and Analytics for HCM -
Get list of all BI Publisher reports that use a specific data modelSummary: Is there a way in BI Publisher to get a list of all BI reports that are using xyz data model as the DM, in order to understand the impact of making changes to a…Shant_Sarkissian_WJG 705 views 8 comments 0 points Most recent by Surya_TejaS Reporting and Analytics for HCM
-
Grouping data in Excel TemplateSummary: I am trying to group data in my Excel Template. Every employee has 2 annual leave plans. This is how the data currently display when I group by G_1. I want to g…Consultant Ian 41 views 6 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Need SQL Query or OTBI report to display OTL Calculated HoursContent Hi All, Pls share Subject area or SQL query to get the OTL calculated hours. For Ex: In a week employee entered 42 hours under Regular. When we click on NEXT but…Visu 1.1K views 2 comments 0 points Most recent by Janhavi Kulkarni-Oracle Reporting and Analytics for HCM
-
difference between legal employer hire date and enterprise hire dateSummary difference between legal employer hire date and enterprise hire dateContent Hi, Please find attached screenshot of Manage Work Relationships for a person: 63060.… -
OTBI report has increased massively since 26BHi, A report that was taking 9 seconds to run is now taking 706. This is since 26B came in on Monday. I will attach the report xml, and I have run a Performance check us…
-
Is there an easy way to pull all the notifications enabled in the systemSummary: Is there an easy way to pull all the notifications enabled in the system. Content (please ensure you mask any confidential information): Is there a way we can p…AnushaGarikipati 21 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
how to send the zip files and PDF files as attachments in the email through the bursting bip reporti have requirement to send the zip files and pdf files as attachments in the mail through Bursting report, is there a way to do this? please let me know
-
How to Review Future Scheduled Lease Liability and Amortization AmountsI would like to ask about the Lease Transactions and Balances Report in Oracle Fusion Lease Accounting. Our understanding is that this report outputs only the amounts fo…
-
Fetch the BIP report Scheduled output bursting detailsSummary: I need to fetch the details like , Output name, Template, Format. is there a table to fetch this details of the scheduled output ? Thanks for the help in advanc…Vishal Purohit 31 views 6 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP