Reports
Discussion List
-
How to add Dashboard or OTBI analysis on Navigator or Springboard (Home page)This discussion provides step by step guidance on how to add OTBI analysis or Dashboard or any external webpage to application UI home page or on Navigator as new page e…CA Nirmal Choudhary 2K views 3 comments 5 points Most recent by SankarBalu Reporting and Analytics for ERP -
OTBI Report 8.4 RCE Anexo 11 – No Invoices DisplayedI am experiencing an issue with the OTBI report “8.4 RCE Anexo 11 – Replaces Proposal” under Oracle Fusion Cloud Financials. When I run the report for the September acco…Milagros MR 33 views 5 comments 2 points Most recent by Prateek Agasti Reporting and Analytics for ERP -
Adding extra filters to Infolets (Order Management - Seeded Infolets)Summary Customization of Order Management landing page to filter the Infolets data along with default filter of 'Source System'Content Currently the system allow users t…Senthilrajan V 145 views 9 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
Getting 401 Unauthorized error code while calling an OIC integration from BIP reportSummary: I have created an app-driven integration that has - trigger REST connection with security policy: OAuth 2.0 - the REST trigger configures multiple resources - m…Nermin Khaled-Oracle 18 views 1 comment 0 points Most recent by Nermin Khaled-Oracle Reporting and Analytics for ERP -
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle 2.7K views 75 comments 9 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS… -
Getting Errore in FRS Report - Internal Essbase JAPI errorSummary: Getting Errore in FRS Report - Internal Essbase JAPI error Content (required): Dear All, I tried to run a FRS Report and I am getting the below error. Error exe…
-
To fetch all the approval group details for a journal.Hi, I am working on a GL workflow BIP report where I need to fetch ApprovalGroup Details like ApprovalGroupName, Approval Sequence, Approval Comments for a journal. Plea…Chitti Damoder 7 views 0 comments 0 points Started by Chitti Damoder Reporting and Analytics for ERP
-
Is there any way to integrate BI Publisher bursting with Fusion’s notification frameworkSummary: We currently use BI Publisher bursting to send report outputs via email to users. This works fine, but we also want the same notification to appear in Oracle Fu…
-
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary: How to Find an IP Address of a User who has Logged in Fusion Application ? Content (please ensure you mask any confidential information): Hello, I have a requir…
-
Conditional Region for Pictures on BI PublisherSummary: Difficulty Applying Conditional Region for Displaying Different Logos in BI Publisher Word Add-In Content (please ensure you mask any confidential information):…
-
Smart View handled an unknown exception thrown by Microsoft OfficeSummary: Smart View Error - Smart View handled an unknown exception thrown by Microsoft Office Content (please ensure you mask any confidential information): Steps to re…
-
Schedule ess job- Create Customer StatementsSummary: Hi, We have a requirement to schedule "Create Customer Statements" to run once every 3 months. How do we schedule this and pass parameters to ess job on each ru…
-
How to connect General Ledger Tables to AR Cash Receipts Tables?I'm trying to build a report that includes GL data and AR Cash Receipts data. I've figured out how to connect the GL_JE_BATCHES table to the XLA_DISTRIBUTION_LINKS table…Steven Woods 33 views 4 comments 0 points Most recent by Steven Woods Reporting and Analytics for ERP
-
looking for help in building an SQL query in Oracle Fusion that can retrieve Cost Centre ManagerHi All, I'm looking for help in building an SQL query in Oracle Fusion that can retrieve Cost Centre Manager details by combining data from both: The Notifications table…
-
Intercompany Payable and Receivable representation in FRS reportsHi, Currently we are maintaining only one natural account for Intercompany Receivable and Payable. In other terms, if the account has a positive balance, it will be cons…
-
FRS Report is opening in multiple tabs for some users and not for others. Is there a specific setup?Hello, We have created a consolidated FRS report for one of our clients and when the user downloads the report, it opens in multiple tabs in excel for one users. For oth…Shriya Srinivasan 6 views 0 comments 0 points Started by Shriya Srinivasan Reporting and Analytics for ERP
-
RVIE Report (14.1 Registro de Ventas e Ingresos Electrónico – SUNAT Format) Not Showing Any InvoicesHello everyone, I’m currently facing an issue with the RVIE report (14.1 Registro de Ventas e Ingresos Electrónico – SUNAT Format) in OTBI. When executing the report for…
-
Fixed Assets Report Showing Data from Financial Book but Not from Tax BookWhen generating a Fixed Assets report, the output displays information from the Financial Book, but no data appears from the Tax Book. Could this issue be related to a m…
-
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…
-
Is there a way to replace Oracle logo at the platform level for all seeded reports?Summary: How can we replace Oracle logo with customer logo (white labeling) for all seeded reports? Content (please ensure you mask any confidential information): We hav… -
Purchase Order Reports not showing line quantityWe have an OTBI (BIP) report for Purchase Order details using Procurement - Purchasing real time. The Quantity field for Quantity based POs is not populating, are any fe… -
How to control or restrict OTBI access?Summary: We need to control OTBI access from accidental deletion of a folder/report and moving reports from one folder to another from business users? Content (please en…
-
R13 Financials OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Orac…Noelle Bartlam-Oracle 34.2K views 94 comments 55 points Most recent by JayanthP Reporting and Analytics for ERP
-
The Multiple Natural Accounts selected in Single row But Data showing in multiple Rows in FRS OutputCreated FRS Report , One Row We selected Multiple natural account in output data Showing Multiple rows, Expectation Is : Should be appear In Single RowRama Mohan ReddyB 13 views 2 comments 0 points Most recent by Rama Mohan ReddyB Reporting and Analytics for ERP
-
Oracle pbcs report (drill down support)Hi, I’m creating a report in the Reports section of Oracle PBCS. I’ve added the zoom option to enable drill down on the data. Currently, in the column for the Total dime…
-
Customize Printable Expense ReportSummary & Content: Need details for the other VOs and the attribute list similar to what was provided for PrintableReportVO and PrintableExpenseVO in the Oracle Ddocumen…Upendra Nayak 146 views 7 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Custom Folder is unavailable to all the UsersSummary: Our users are not able to see the Custom Folder under Shared Folders All our reports are in the Custom folder. Possibly -mistakenly the permission of the folder…
-
How to Create a Report for Approval/Reject Notifications in Fusion?Hi Everyone, We have a requirement to generate a report for all email notifications sent from Oracle Fusion for Approval or Rejection actions. The report should include …
-
ESS job and job sets migration from one instance to anotherSummary: We have around 200+ ESS jobs and each time after refresh, it is a tedious and time consuming task to migrate each of them individually. We have to document each…Pawan Lakhotia 2K views 11 comments 3 points Most recent by Luke Quell Reporting and Analytics for ERP