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
-
How to restrict users from using direct base tables in Data ModelWe have to provide certain users with Create Data Model access in BIP, but need to restrict them to usage of only certain tables or certain data in the tables. Do we hav… -
Do we really need the ESS Administrator Role to run the Approval Groups Report ESS Job?Summary: We figured out two levels of security are required to run the "Approval Groups Report": Enable the user to Submit the Scheduled Process /oracle/apps/ess/financi…
-
Restricting Data retrieved by BIP report queryHi, We have requirement to restrict the data returned by BIP query based on Data Access Security setup on ERP Cloud. We find that we have concept of Secured List Views (…
-
Applying a date filter on a PVO extractSummary: As we have been using ERP, some of our PVO tables are getting quite large, while the data extracts normally have less than 1 million rows in them, the PECSV val… -
OTBI Analysis Agent - Enable to see Email ToSummary OTBI Analysis Agent - Enable to see Email ToContent The OTBI Analysis Agent when send's the extract based on the analysis, the recipients list is not showing in …
-
How to add a header to the e-text outputSummary: By default the e-text layout output doesn't have column headers. We have a requirement to add the headers as well for the integration file with the third party.…
-
BIP internal bank account table?Hi Guys When I search online I get told to use view CE_INTERNAL_BANK_ACCOUNTS_V to lookup field INTERNAL_BANK_ACCOUNT_ID out of table iby_pay_service_requests. However w…
-
OTBI Agent generating report errorSummary: I built a new agent and it is set up to run as another user with full permissions. For some reason, every time it processes at its scheduled time, it appears to…
-
Collection Note table?Summary: Collection Note table?! Content (please ensure you mask any confidential information): I am trying to find the table that stores the data for notes related to t…
-
How to unmerge the cells when the rtf template is exported to Excel ?Summary: We have a report requirement that rtf template is exported as an excel output report, but the issues are the rows are getting merged in excel Output. Content (r…
-
From address change to display company domain in BPM workflow shows as "External mail" in OutlookHow to configure the BI publisher—> Administration—> Delivery configuration for Email delivery of all workflow emails from Company domain. Currently I have added the Fro…
-
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,… -
General Guidance on BICC/BIP for PVO JoinsSummary: General guidance on Fusion BICC/BIP for PVO joins & if Fusion supports AI/ML analytics? Content (please ensure you mask any confidential information): My unders…
-
How to remove special characters in the output of a e-text templatesSummary: We want to send all the open POs to a third party system in .txt format. The item description have a lot of special characters, how to remove it in the output w…
-
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 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 …