Reports
Discussion List
-
Though the cell level indent is zero still columns are showing with indentSummary: Though the cell level indent is zero still columns are showing with indent. we want to override the indent with zero Content (please ensure you mask any confide… -
default bold is showing in report even not enabled the Bold in cell level property Narrative reportdefault bold is showing in report even not enabled the Bold in cell level property Narrative report
-
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…