Category 129
Discussion List
-
Is it somehow possible to work dynamically with BIP reports directly in Excel?Content (required): Hi all, Is it somehow possible to work dynamically with BIP reports directly in Excel? Hence, have the layout of the BIP reports with the same parame…Daniel Lundsteen Minke 22 views 1 comment 0 points Most recent by Cezar - Fusion Oracle Support-Oracle Reporting and Analytics for ERP
-
OTBI Access and SQL Query ViewHi For OTBI Report Creation - the access is incomplete. Please observe the Create --> Published Reporting and Actionable Intelligence - only two options What all are the…SaurabhSinghal 22 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Join Subledger Tables to AP_INVOICE_DISTRIBUTIONS_ALLSummary: I'm not sure if this belongs more in the Reporting forums, however I am looking to join any of the following Subledger accounting tables to the AP_INVOICE_DISTR…JBabbit121 62 views 11 comments 0 points Most recent by Venkata Kompella Reporting and Analytics for ERP
-
Invoices Paid on timeSummary: Hi Business is trying to generate the invoices paid on time report in Fusion Cloud Not able to trace the seeded / standard report for the same. Can you please g…SaurabhSinghal 34 views 5 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
OAC Essbase Add-In for Google SheetSummary: Are we able to use smart view in Google sheet? We have heard about OAC Essbase Add-in, Will it replace Smart View for Google sheet? Also, while adding the plug-…Nikhil Bidwaikar 4 views 0 comments 0 points Started by Nikhil Bidwaikar Reporting and Analytics for ERP
-
BI Publisher - reference another group value from within a nested grouped areaSummary: BI Publisher Template: Reference a high level value from a lower level repeating group Content (required): I have a repeating group in an rtf template using BI …Robert of STAU 38 views 0 comments 0 points Started by Robert of STAU Reporting and Analytics for ERP
-
How to get the GL Segments Flex value set IDs for seeded and custom segments from EBS R12 DBSummary: EBS R12 SQL or base tables to fetch GL Segments Flex value set IDs for seeded and custom segments. Content (required): There is a need to fetch GL Segments Flex…Manu R-Oracle 23 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Is there any formula to calculate the number of days in a financial year in FRS?Summary: We have a requirement where we need to apply a formula as [(Row 1)+(Row2)]/Number of days in a FY, so for that we need to automatically get no.of days calculate…Srishti Kedia-Oracle 12 views 0 comments 0 points Started by Srishti Kedia-Oracle Reporting and Analytics for ERP
-
Error in join subject area Purchasing Real Time and Requisition real TimeSummary: Hi Team, We are trying to join the subject area Purchasing Real-time and Requisition Real-time, but getting error as below- Error Codes: OPR4ONWY:U9IM8TAC:U9IM8…raban 24 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Project Budget Vs Actual at Task Level ReportSummary: Project Budget Vs Actual at Task Level Report Content (required): Has anyone developed a report that contains Project Budget Vs Actual at Task Level? Version (i…
-
Is it possible to generate csv file with column labels of child records even when they don't exist?Summary: Standard BI Publisher behavior is that column labels are not generated for columns of child records when they don't exist. Example: Data Model queries: Data Set…Valter Pilan 22 views 4 comments 0 points Most recent by Valter Pilan Reporting and Analytics for ERP
-
Customise standard report - new layoutSummary: Standard report which only runs inside Fusion ERP. How to use sample data xml export in Fusion BI Publisher? Content (required): So I have a standard report whi…Robert of STAU 22 views 4 comments 0 points Most recent by Robert of STAU Reporting and Analytics for ERP
-
Is there a subject area for Chart of Accounts in OTBISummary: Is there a subject are for Chart of Accounts in OTBI? Content (required): Looking for a Chart of Accounts subject area so that I can build an OTBI report Versio…
-
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…AngelOftheNorth 33 views 3 comments 0 points Most recent by SimonTomey Reporting and Analytics for ERP
-
How to create a Cross-Tab reporting using BIP Excel TemplateSummary: How to create a Cross-Tab reporting using BIP Excel Template Content (required): Hi, We have a complex report layout and we have to develop it using BIP Excel T…
-
Oracle ERP Cloud - Data Extraction via BICCHi - We are building a cloud data warehouse using data from Oracle SCM Fusion Cloud 22d using Oracle Business Intelligence Cloud Connector (BICC) for data extraction usi…satya_nvs 161 views 7 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
How to restrict custom folder created in dashboardSummary: How to restrict custom folder created in dashboard Content (required): Hi Experts, We have created one custom folder and included all the custom reports in the …
-
Invoice Approval Workflow - Pending with which approverHi, Business Scenario: In AP Invoice Approval Workflow - if an invoice shall be going through five approvers in all during BPM Workflow Business would like to generate t…SaurabhSinghal 43 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
BPM Workflow Invoice Approval - Standard ReportHi, Scenario: During the workflow of invoice approval, when one of the approver has delegated the authority to someone else in organization Ask: Business would like to k…SaurabhSinghal 12 views 0 comments 0 points Started by SaurabhSinghal Reporting and Analytics for ERP
-
Font mismatch between RTF template and PDF outputSummary: Font mismatch between RTF template and PDF output Content (required): Hi Experts, We developed a custom template for the PO PDF report. We found font mismatchin…Venkatesan 43 views 8 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
How to disable the Open option on Reports & Analytics Catalog?Summary: How to disable the Open option on Reports & Analytics Catalog? Among the various reports offered out-of-the-box by the Oracle Fusion modules, some of them can b…Valter Pilan 55 views 6 comments 0 points Most recent by Valter Pilan Reporting and Analytics for ERP
-
Manage Project Sets - Table/Subject AreaSummary: Content (required): Hi I would like to know which tables stores the information in regards to Project Sets that is created in Fusion. I find the manage project …Nicolas Vahman 2 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
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 …
-
OTBI Report filter for first and last date of current monthSummary: Hi Team, I am scheduling an OTBI report. We have accounting date between parameter in report. I am adding filter to OTBI report and want system to take first an…Nidhi Chhajed 33 views 5 comments 0 points Most recent by Laxman Pondey-Oracle Reporting and Analytics for ERP
-
Report definition not found:/Custom/Financials/Payables/Invoices/****.xdoSummary: I keep getting the Report definition not found:/Custom/Financials/Payables/Invoices/****.xdo error Content (required): I keep getting the Report definition not …
-
DFF are not visible in Payables Payments - Disbursements Real TimeSummary: Hi All, We have created global DFF on AP_CHECKS (table) and made it BI enabled, but it's not visible in "Payables Payments - Disbursements Real Time" subject ar…
-
Calculated measure questionSummary: Building multiple columns based on aging Content (required): I have defined a report that gives me the amount due on an invoice and it's related aging value. I …
-
Calculated Measures issueSummary: Calculated Measures when null value exists Content (required): I have two measure. The one being invoice amount and the other being invoice paid amount. For bot…
-
Borders are not displaying in Word(.docx) outputSummary: Borders are not displaying in Word(.docx) output Content (required): Hi Experts, We develop RTF with borders, but when we run the output as .docx borders not di…Venkatesan 22 views 3 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Error in accessing BICC URL ending fusion pod /biacmSummary: Hi Team, We are getting error while trying to access BICC using url - fusion POD /biacm. Anyone faced similar issue, so need help in resolution of same. ADF_FAC…