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
-
FRS branch wise bifurcation for calculated fields like gross profit and percentageSummary: I am taking branch in rows. I need to display the gross profit data branch wise and percentage should also be calculated branch wise. Content (please ensure you… -
Do we have any WebService to display the list of reports in Oracle Fusion ?Summary: Hi Team , Do we have any WebService to display the list of reports in Oracle Fusion ? ** i have used the table : GL_FRC_REPORTS_B , but its of not much use - as…
-
How to add last_updated_by column in the report/data downloaded from "Submit Vacation Rules Report"How to add last_updated_by column in the report/data downloaded from "Submit Vacation Rules Report" in "Manage Workflow Rules in Spreadsheet". Please help to find standa…
-
How to create Job Set in Oracle fusionHello Cloud Expert We have requirement to create Job set which would consists of same job with different parameter . Basically We wanted to have job set for ESS job 'Cre…
-
can we get the amount/numaric value in words in Polish language for OTBI ReportsGenerally we uses the function iby_amount_in_words.get_amount_in_words to display the amount/numaric value in words in English language for OTBI Reports. I would like to…
-
Connect Oracle Database Actions to Oracle Fusion ERPSummary: Connect Oracle Database Actions (SQL Developer Web) to Oracle Fusion ERP Content (please ensure you mask any confidential information): Are we able to connect t…
-
Not able to install the ADFDI integrator application in MAC book pro with M1 processorSummary: Not able to install the ADFDI integrator application in MAC book pro with M1 processor Content (required): Not able to install the ADFDI integrator application …
-
Date filter in rtf templateSummary: Hi All, Good Day! The template is in RTF . need to see the output in excel. Can anyone help on this ! Content (please ensure you mask any confidential informati…
-
How to add security on custom BIP folderSummary: We want to implement security to a custom BIP folder to give restrict access of some users to it. How can we do that? Is there something we can do in permission…
-
What are the standard Smart View reports available in Oracle ERP Cloud?Hi, What are the standard Smart View reports available in Oracle ERP Cloud? Such as for Cash Management we have the Cash Forecast and Cash Position Report which could be…
-
Redwood Plan for Oracle Cloud ERPSummary: I haven't found clear discussion on how the Redwood would affect Oracle Cloud ERP. I see documentations and notices for EPM, HCM, and SCM, but I'm unclear on wh…
-
How to fetch amount delivered on PO through SQL QueryWe have a custom Purchase History BI report that gives entire PO history. This report also has columns named quantity_delivered and amount_delivered which are being fetc… -
Fusion SCM Analytics Prebuilt KPI Library for MFGHi, I am looking for prebuilt KPIs library for MFG subject area. I checked the documentation link 25R1. but could not find the list for MFG, although for OM,INV etc I co…
-
Is there a report to show users' roles and privileges or what's table of them?Summary: We want a report to show users' roles and privileges or we can customize a new if there's no statndard process, but we don't know the table for these infoematio…
-
CC wise expense report in OTBISummary: we have tried to create an OTBI report for the expense total with break down by Cost Center with GL but it not showing any break down sum we can get only total …
-
How to create depended LOV parameters (based on value set) in ESS jobHow to create depended LOV parameters in ESS job. The LOV parameters will be based on value sets. -
how to show alternate account GL combination in BIP report?Summary: User requirement to show alternate account GL combination but cannot find correct field. Content (please ensure you mask any confidential information): When vie…
-
A guide to Custom Roles in Oracle ERPSummary: In this discussion, we shall know: What is custom role and why it is needed? What are components within a custom role? How to create Custom Role? How to delete/… -
Steps to customize standard BI Report and Add ParametersContent Hello All, We have a requirement to customize standard BI Report to add parameters and modify the data model. Do we have any oracle document about this process ?…
-
Convert UTC timestamp data to Mountain Time using "Format Mask Feature" in Oracle Cloud BI ReportI am using below code in data model to convert UTC to MT in report output. But column looses formatting when exported in excel and used in Pivots. How to achieve the sam…
-
BIP Bursting is not delivered the emails to DLsSummary: Bursting emails from a BIP report are not delivered to any of the email ID's part of DL list, even though the Report Job History/Output & Delivery section indic…
-
How to convert WD attachment in the rtf into table formatHi everyone I want to check if there is any possibility to convert the attachment from Work definition screen into table format. Below is the attachment being printed in…
-
Is there a query to get job board (e.g. LinkedIn, Broadbean) posting status?Summary: Is there an SQL query to get job board (e.g. LinkedIn, Broadbean) posting status for a specific job requisition? Content (please ensure you mask any confidentia…
-
Mass reassign of approvalsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
forgetaccount utility not working for one of the userSummary: Hi All, I am trying to use forget accounts from this document and it is not working How To Run renameAccounts/forgetAccounts When User is Unable To Login to Ana…
-
Ability to create OTBI analysis calling a APISummary: Ability to create OTBI analysis calling a API Content (please ensure you mask any confidential information): Is it possible to invoke a custom API from OTBI to …
-
News feed home page layoutSummary News feed home page layoutContent The new layout of news feed looks great, but, if the home page layout is set to "News Feed", the user does not get the option t… -
How to change the SQL Query Timeout value?Summary: How to change the SQL Query Timeout value? Content (please ensure you mask any confidential information): Version (include the version you are using, if applica…
-
We need to display the Tax Rate value of the Purchase Order line in OTBI.Summary: We need to display the Tax Rate value of the Purchase Order line in OTBI. So, we need to find out the subject area that we can create OTBI and display the value…
-
How to schedule ESS Processes in bulkSummary: Business has yearly activity to schedule accounting jobs across financial modules for all accounting periods. This requires good amount of manual efforts. Is th…