Category 129
Discussion List
-
Sending remittance advice email limitSummary: we are a government department and are now paying a large volume of grant payments. this means an increase to the number of payments and therefore remittance ad…Anne Cilia 42 views 3 comments 0 points Most recent by Gopikrishna-Oracle Reporting and Analytics for ERP -
how to do sql query Report Job ID(Report Job History)Summary: How to do sql query Report Job ID(Report Job History) Content (please ensure you mask any confidential information): Look like this Report Job ID is not Correct…
-
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 6 points Most recent by SankarBalu Reporting and Analytics for ERP -
Fusion OTBI Drill Down to different subject area, linking on column with different name in each areaSummary: Hi, Oracle Fusion OTBI. I'm attempting to drill down from and OTBI Report on "Procurement - Procure to Pay" Subject Area to another report based on "Payables In…
-
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 -
Customizing the standard Negotiation Award Decision Notification doesn't work after upgradeSummary: I customized the standard Negotiation Award Decision Notification by: Adding new columns to the data model and using them in the layout. Adding new sections and…Nermin Khaled-Oracle 12 views 0 comments 0 points Started by Nermin Khaled-Oracle 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…
-
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 11 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 add filter to obtain prior financial period transactions?How do we create a filter on an OTBI analysis to return the prior financial period's transactions based on current date? Requirement: We need to schedule a report to del…Elaine Hendry 20 views 3 comments 0 points Most recent by Elaine Hendry Reporting and Analytics for ERP
-
We are having an issue with reports showing with trial balance for mexico report for occasional userSummary: When running the trial balance report for Mexico from the RFC, it does not display any data. This happens with a specific user. What could be the cause? The use…arin innovation 8 views 0 comments 0 points Started by arin innovation Reporting and Analytics for ERP
-
Report Output data getting spit in two rows in excel file due to line breakageSummary: We have an OTBI report based on an Analysis where the Data Model is also using Analysis. In the data, there are line breaks within certain fields. When exportin…Nikhil Kubba 96 views 5 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
BI Publisher – Unable to Set Default Parameter to Week Start (Sunday) and Week End Date (Saturday)We are trying to configure a BI Publisher report parameter in Oracle Fusion Cloud to automatically default to the start and end of the week Week Start = Sunday Week End …Deepika Maddirala 14 views 2 comments 0 points Most recent by Deepika Maddirala Reporting and Analytics for ERP
-
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…
-
We would like to understand the New Redwood features for Oracle FinancialsHi Team, Can someone please help us understand What are the new Redwood Oracle financial features? Is there any documentation or screenshots explaining the Finance upgra…
-
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 38 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…
-
FRS Report not displaying any output (Blank screen on execution)Summary: While executing the FRS report for a specific accounting period, the output page appears blank despite correct parameter selection and confirmed data availabili…
-
Manage Production Calendar Exceptions Calendar TablesI am trying to find the table that saves the registries for shifts exceptions on maintenance production calendars in Oracle Fusion in order to use it for reporting in OT…
-
OTBI - General Ledger - Balances Real Time Subject Area not Returning Budget DataSummary: OTBI - General Ledger - Balances Real Time Subject Area not Returning Budget Data Content (required): Having successfully loaded budget data into Financials fro…User_2025-02-10-15-12-48-631 265 views 4 comments 0 points Most recent by Global Customer Support | ASE-Oracle Reporting and Analytics for ERP -
End User gets the option of EDIT for custom OTBI reportSummary: Hi Team, We created and OTBI report using General Ledger -Journals real time subject area, In the permissions window we have given full access only to BI admini…Naga Hari Krishna P-Oracle 17 views 7 comments 0 points Most recent by Naga Hari Krishna P-Oracle Reporting and Analytics for ERP
-
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…
-
Need BICC PVO to get per_location_details_f tables Additional attributesSummary: Need BICC PVO to get per_location_details_f tables Additional attributes Content (please ensure you mask any confidential information): Version (include the ver…Nishanth B Jain 41 views 5 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP -
Procure To Pay real time Subject Area issuesSummary: Need help to triage Procure To Pay real time Subject Area issues Content (please ensure you mask any confidential information): I am currently validating the da…
-
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 7 views 0 comments 0 points Started by Shriya Srinivasan Reporting and Analytics for ERP
-
Assistance required to create Requisition Bucket with Bar graphHello, I am seeking assistance in developing a Requisition Aging Bucket in OTBI. The goal is to create a bar graph to present summarized requisition data on a dashboard.…
-
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…
-
Recommended OTBI and BI Publisher Reports for Financial ReconciliationI’m exploring OTBI and BI Publisher in Oracle ERP Cloud and would like to build useful reports for reconciliation between Payables, Receivables, and GL. Could someone re…
-
How can I schedule a BI Publisher report with dynamic date parameters for the previous 3 months?Summary: We have a report used by many business areas. One particular business area would like to schedule this report to pick up the previous 3 months of data. How can …