Reports
Discussion List
-
Grouping on Rows and Columns - can I do a Variance on on both descendants of 2 dimensions?Summary: Not sure if this is possible: I have descendants of children going across the columns (could be between 5 and 20 members depending on what parent is selected in… -
Alignment of header and main grid of reportHi In current scenario the requirement is that when report is downloaded to excel , grid should start from column B. To achieve this I have indented main grid and header…Amara Sai Sandeep 18 views 5 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
How to Stop Pie Chart Label Font Color defaulting to White?Summary: I have a pie chart with outside labels. The labels are always white despite what I set the label font color to be. This makes the labels invisible unless I chan… -
Do not promote feature in ReportsWe have an option called Do no promote in Forms Formatting / Validation rules , which allows user to restrict promoting an entity in Approval workflow. Do we have any su…Amara Sai Sandeep 11 views 3 comments 0 points Most recent by SaifUrRehman Financial Consolidation and Close
-
Journal approval and rejection reportSummary: Do we a report in Oracle that provide information on journals which were submitted for approval and have been rejected. If not can anyone share any queries wher…
-
Inquiry on Table for Bursting Email TrackingSummary: Inquiry on Table for Bursting Email Tracking Content (please ensure you mask any confidential information): In accordance with the requirement report, emails ha…
-
Create Data Model From View ObjectSummary: We are in an Oracle Fusion Saas environment. I have been looking at the View Object Data Model, We have Data Sources that populate for ERP and HCM in the dropdo…Christopher Haupt 14 views 0 comments 1 point Started by Christopher Haupt Reporting and Analytics for ERP -
BI Publisher - how to add watermark based on condition in RTFSummary: Content (please ensure you mask any confidential information): Dears , We have a requirement that a watermark to be appeared based on condition , like if the st…Beshoy Hakim-Oracle 13 views 1 comment 1 point Most recent by Gangadhara S Ariga Reporting and Analytics for ERP
-
Requirement for Encrypted File Generation in UCM via BIPSummary: Hi, We are currently using Bursting in BI Publisher, where a .csv file is generated as the output and placed in the UCM Content Server. However, we have a requi…Mounika-Oracle 50 views 5 comments 0 points Most recent by User_WBPA1 Reporting and Analytics for HCM
-
SQL to Find AP invoices assigned for approval to wf groups where those role currently has no usersWe have a requirement to fetch the invoices assigned for approval to wf groups(roles) which has no active users, if anyone has any sql or BIP report could you please hel…
-
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 66 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 …
-
HCM Extract changes only with dynamic group criteriaHI All We have a requirement for HCM changes only extract for interfacing data in payroll system. Oracle HCM is the master employee system and we have a thrid party payr…Murthy Kodavati 21 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
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 63 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 151 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 4 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…VNK 2 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
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 322 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 704 views 8 comments 0 points Most recent by Surya_TejaS Reporting and Analytics for HCM