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
-
INV_ACCESSIBLE_ORGANIZATIONS_V View Not AccessibleThe INV_ACCESSIBLE_ORGANIZATIONS_V view that is used in our BI reports is previously accessible using other roles even without the Application Implementation Consultant … -
Why do scheduled reports with a daily frequency cannot be received on a weekend (Saturday & Sunday)?Summary: The business users created a schedule for the daily backup of a report, but the backup mail is being received only from Monday to Friday. Mail for Saturday and …
-
How to change the measures in the Chart based on the Dashboard promptSummary: Content (please ensure you mask any confidential information): We have a scenario involving three types of costs: A, B, and C, which have been added as measures…
-
How can I configure "All" prompts in BI PublisherSummary: Content (please ensure you mask any confidential information): I have a report with some parameters, I would like them to come with the default value "All" and,… -
Can I change the date format in the BI Publisher data model to 'DD/MON/YYYY'?Summary: In the Fusion, publisher reporting → data model→ SQL Query "select to_char(to_date('12/09/2024','DD/MM/YYYY'),'DD/MON/YYYY') from dual;". It always returns 12/0…
-
How to use multiple delivery channels in Bursting query -Fusion BISummary We would like to explore the option to set delivery channel as SFTP and also we want to send delivery status notification to one particular email address .Conten…
-
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…
-
PL/SQL Query to ADD Month to a Period NameSummary: I have a scenario where a user will pass input period name. The query should return data of both the current period entered by the user and the previous period.…
-
How to add 2 columns in group by in Excel templateSummary: Need to add 2 columns in Group by expression in EXCEL template Content (please ensure you mask any confidential information): below condition is working for 1 c…
-
Want to embed only bip report output and not the header sectionSummary: Hi Experts I want to embed below bip report in the supplier page but i could see that when i embed the bip page the header containing web page, home, catalog,fa…
-
UNSPSC Code HierarchyDoes there exist within ERP a full listing of available UNSPSC codes and its potential hierarchy? I am assuming this data is available within ERP but I can't see it if i… -
Not able to add Budget Values(amount) column in FRS Report.We have an FRS Report for Profit & Loss Account where the accounted values are reflected. We have a requirement to add Budget Values also in the FRS, but we have tried e…
-
Linking Project Task Number to BPM tablesHello Team, We have a business requirement to report on the Project Adjustment BPM approval routing. To Achieve this requirement, we are trying to establish link from fa…
-
No Data Found when Other Users run BIPSummary: I created a simple vendor report with BIP. I can run it fine and see the data such as vendor name, number, address, etc. I have another user, Employee B, who on…
-
how to use SQL to create otbiI have Created an sql query for BI report , but I want to convert it to OTBI analysis is there any way to achieve this ?
-
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… -
How to take custom object definition to Prod env in erp cloud??I have created 10 custom objects in sandbox by using Application Composer. Now i need to take same definition of custom objects to PROD but i am not being able to find o…
-
How to create a dashboard for a cash control budgetSummary: This document provides an overview of how to install and use the Cash Control Dashboard Content (please ensure you mask any confidential information): The Cash … -
sql query to fetch sales order(export order) related details from oracle fusionhow to get delivery mode(FOB,DDP etc), Exporter(To ship) address,fumigation status(YES/NO) and type of certificate required for a sales order export compliance from orac…
-
PVO DetailSummary: Im trying to get the detail of what this PVO is including (HcmTopModelAnalyticsGlobalAM.HcmRecSrcTrackingAM.SourceTrackingViewAllPVO ) , is there a good documen…
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo… -
how to add multi line text using interface text in sandbox in oracle fusion applicationReplace multi line text using interface text in sandbox in oracle fusion application. output: Expectation: it should print 2 lines with a line gap i. Attach supporting d…
-
How to schedule an OTBI report to run for a subset of the full OTBI report?Summary: I have an OTBI report I created that lists all active Projects, the assigned project managers and total budgeted amount. The full report with all project manger… -
Inconsistent running time of BIP reportsHello Everyone, We have an existing Custom BI Report that we are monitoring, running this report thru Scheduled Jobs 10 times to check how long this report run. Sometime…
-
Navigation : My Enterprise -> EnterpriseSummary My Enterprise -> EnterpriseContent Hi, I am trying to navigate to t My Enterprise -> Enterprise menu from the home page. Even if i have all the relevant applicat…
-
Oracle BIP Report Excel template output displaying Number values as TextHi, We have created the new custom BIP Report with Excel template and when we download the report output into Excel, then all Number values are displaying as text, these…
-
Compare 2 Versions of BIP Report between 2 different instances in Oracle FusionHi All, We're exploring options to compare two versions of a BI Publisher (BIP) report, including both the data model and report definition, to identify changes between …
-
What tablle gives the solicitation response historyI am looking for data under analyze →view response history on the solictation page
-
Need dataflow/flow chart for Oracle fusion finance(ERP)Summary: Hi Team, We need to give presentation for Oracle fusion-Saas+OIC+anyother application module , so we need data flow diagram/flow chart for the same. This diagra…
-
Can I change the default attributes of a BICC extraxt file stored in UCM?Summary: I'm creating 2 extracts of BICC sourced from the same PVO for 2 different purposes, this is creating files with the same name. I need to download the files and …