Category 129
Discussion List
-
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 7 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…
-
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 26 views 4 comments 2 points Most recent by Prateek Agasti Reporting and Analytics for ERP -
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 23 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 254 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 15 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 46 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 5 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…
-
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…
-
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 …
-
BIP Schedule Data Parameters for the Previous MonthSummary: BIP Schedule Data Parameters for the Previous Month Content (please ensure you mask any confidential information): I am looking to use date parameters on a BIP …
-
Can we populate currency based on the ledger currency in FRS Report in Oracle FusionHi, We are currently building a financial report using Financial Reporting Studio (FRS) in Oracle Fusion/ERPCS, and we are exploring options to dynamically populate the …Varalakshmi Guduru 21 views 2 comments 0 points Most recent by Varalakshmi Guduru Reporting and Analytics for ERP
-
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… -
Getting an error when trying to add another column in OTBI Rep for a DFFSummary: There is a custom field (DFF) on the Customer Sites (Receivables) which we are trying to add to an existing OTBI Report. After adding it to the report, getting …
-
Sql to reconcile Receivable Invoices' balances with their applied receiptsSo, I have constructed a sql query to look at Receivables balances using ra_customer_trx_all and ar_payment_schedules_all. I have another query which I tried to summaris…Robert of STAU 1.2K views 5 comments 0 points Most recent by gkulkarni Reporting and Analytics for ERP
-
How to get the last period of previous fiscal year in FRSThere is a requirement in balance sheet report where we need to get the details for Previous Year Ending(PYE) balances in one of the column in FRS report. For Ex: Curren…SRIKANTH DEVARASHETTY 68 views 4 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
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 create Dependent List of Values parameter in ESS Job with User-defined (SQL) LOV as SourceSummary: I would like to know if it is possible to create a parameter in an ESS Job that is dependent on another LOV parameter that has a User-defined (SQL) LOV Source. …
-
How to get the last period of previous fiscal Period in FRSSummary: We create " Income Statement" . The report having Two Columns , Column A represent "Accounting Period Selected in prompt" i.e Sep-2025 Column B for Previous yea…Rama Mohan ReddyB 19 views 0 comments 0 points Started by Rama Mohan ReddyB Reporting and Analytics for ERP