To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Error detail information in import journal execution reportSummary: In the process of creating a custom report for import journal execution report, we are unable to fetch the data for error status. We are able to fetch data for … -
how to link to tables AP_INVOICES_ALL and POZ_SUPPLIER_REGISTRATIONS ?????Summary: i try to create bi publisher report ( report aging supplier ) i want to select supplier name and supplier number how i can ? Content (please ensure you mask any…
-
How to install oracle report builder to read legacy reportsHi All, we are in process of decommissioning r12 as we have moved into cloud. For reporting purpose we need some of the custom, standard rdf reports and their underlying…
-
Missing PJF Tables/Views (i.e PJF_TASKS_V) In BICC PVO Data Lineage RepositorySummary: Hi Team, We need to extract data from Oracle and send it to our downstream systems. We're using BICC for this data extraction process. Our current challenge is …
-
BICC Mapping documentSummary: HI Team Please provide me the latest BICC View Object Mapping Sheet link Content (please ensure you mask any confidential information): Version (include the ver…
-
Oracle BICC Frequency options checkSummary: Hi , Oracle BICC has feature to schedule the data extract job with recurrence frequency of Hourly, Immediate, Daily, Weekly and Montly. However our client needs…
-
Does anyone have a Procurement Purchase Order dashboard they could share?Summary: Wondering if anyone has a (more recent) Procurement / Purchase Orders OTBI Dashboard they could share. Content (please ensure you mask any confidential informat…
-
Getting corrupt XLS output for more than 100KB output.Summary: Report Name : AR Debtor Aging Report - MIRA Real estate.xdo Report Path : /shared/Custom/Transactional Reporting/Receivables/BI Publisher/Debtor Aging Template …Soare Oldrich Alexandru-Oracle 12 views 0 comments 1 point Most recent by Soare Oldrich Alexandru-Oracle
-
OTBI Report - Hyperlink Path Not Found ErrorI'm getting a "path not found" error when clicking a hyperlink on a graph in my OTBI report. The hyperlink is supposed to open a customer profile report when I click on …
-
Capture change in TAX lines on RA_CUSTOMER_TRX_LINES_ALL on BICC extractionSummary: As per business, we understand they could change the Invoice Tax lines attached to a given invoice in Fusion. Since we maintain the Invoice Lines data in TRANSA…
-
Unusual behavior of OTBI report -Not displaying 'invoice amount' and 'discountable amount'Hi Team, We have OTBI report which displays invoice discount information. After 24A we are observing it is not displaying 'invoice amount' and 'discountable amount' for …
-
OTBI Dashboard not reflecting the analysis dataSummary: When certain parameters are used in a dashboard, a couple columns return null values. The raw analysis does include data for these columns. This just started oc…
-
how to store the manual input parameter values for multiple session in BIP report.Summary: User wants to run the BIP report with same input parameter values again and again and our report has around 20 manual input parameters. So is there any workarou…
-
SQL Query to get Transaction column from Review Completed Transactions Page for intransit shipmentSummary: I want SQL query to transaction, serial number from get reviewed completed transaction data for Intransit shipment transaction type. Content (please ensure you …
-
Is is possible to create an audit report that has all FRS BIP and OTBI reports?Summary: Is there a way to get details of report along with the last run date individually (individual report for each areas) for reports & analysis - in OTBI and a Fina…
-
supplier bank account change report, 'last updated by' column showing 'FUSION_APPS_PROV_PATCH_APPID'Summary: Recently Quarterly Fusion 24A patch and console conversion completed in my oracle fusion fiancials. Today Business tried to ran the custom supplier bank account…
-
scheduled proccessess in Fusion: need to fetch data for 2023 yearSummary: I have a request to provide a list of all processes which were executed in the Fusion system in 2023y Cotent (please ensure you mask any confidential informatio… -
Need Information on Fusion tables related to REST APISummary: Would like to know which fusion tables are used to pull data for REST API /fscmRestApi/resources/11.13.18.05/projectPlanDetails. Content (please ensure you mask…
-
REST API's related to projectPlanDetails (/fscmRestApi/resources/11.13.18.05/projectPlanDetails).Summary: Rest call (/fscmRestApi/resources/11.13.18.05/projectPlanDetails) returns forbidden error (HTTP-403) Content (please ensure you mask any confidential informatio…
-
Schedule report option to deliver to email outside Oracle domainSummary: My client is looking at scheduling the reports via the report schedule Option in Oracle Cloud. How do we use the schedule report option to deliver to email if t…
-
Is intercompany invoice eligible for Mass Addition process?Summary: Hello, I created an Intercompany invoice with asset clearing account and want to transfer it through mass addition. I'm not able to do so. Please note that I've…
-
Cost Center details in Purchasing- Requisitions Real Time Subject AreaSummary: Cost Center details such as Cost Center code and Cost Center description in 'Purchasing- Requisitions Real Time' Subject Area Content (please ensure you mask an… -
Moved: Invoice summary details table for APThis discussion has been moved. -
Oracle Fusion ERP Timeout IssueWe are currently attempting to satisfy controls that our Oracle ERP Applications timeout after 30 minutes of inactivity. Looking at the below link, it states that Idle s…
-
Essbase Cube, Report distribution, Oracle Fusion SaaS environmentWe are currently in Patch 24A getting ready to go to Patch 24B. We have Smart View and have build FRS WEB reports that users can run out of Financial Reporting Center. W…
-
Subject Area to get real time ESS Job details for OTBI Analysis dashoboardHi, We have a requirement to create an ESS Job monitoring dashboard to show summary of ESS Jobs by status and few detail drill down reports. Is there any subject area wh… -
Pre-defined variable to get instance URL for analytics server similar to CURRENT_SERVER_URLHi, We need to include links to drill-down BIP reports in the output of a master report using an RTF template. When creating these links, the instance hostname should be…
-
Pre-defined variable to get instance URL for analytics server similar to CURRENT_SERVER_URLHi, We need to include links to drill-down BIP reports in the output of a master report using an RTF template. When creating these links, the instance hostname should be…
-
Hide column in a data modelSummary: Hi Team, We have requirement to generate an XML output with parent and child relationships for AR invoice data. We have created a parent dataset with customer_t…
-
Need a query to get accounting period of a POWe are unable to find a way to get an accounting period for a purchase order. Could you help with a query? I need the PO# and the accounting period as a column. Also, le…