Tip
Discussion List
-
Unable to locate Direct SQL option after upgrade 19ASummary Unable to locate Direct SQL option after upgrade 19AContent HI, I'm not able to location the Direct SQL option after upgrade the 19A. Can anybody suggest where w…Suresh.Kumarasamy-Oracle 85 views 10 comments 2 points Most recent by Shyam_Patel Reporting and Analytics for ERP -
Supplier Audit ReportSummary Supplier Audit ReportContent Good People, Anyone create supplier Audit Report as a custom one apart from the one available ? Thanks, SoumyaSoumya Prakash Parhi 176 views 18 comments 1 point Most recent by Gaurav Jain _Infosys Reporting and Analytics for ERP -
BI Template Sum Function Not Working ProperlySummary: The Sum function in the BI template not working as expected. Content (required): We have a custom report where we used the sum function on specific field but it…Ahmed Maher Kadeh 62 views 3 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Is there a REST API to get the submission and completion time details of an ESS Job ?Summary: Is there a REST API to get the submission and completion time details of an ESS Job ? Please provide pointers if available. DhruvDhruvjoshi23 341 views 2 comments 2 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Pass Column as a Presentation VariableSummary: Using presentation variable, compare one column against another in Conditional Format Content (required): Hi All, Does anyone know how to go about creating a pr… -
How can I create a BI Analysis that considers the credit limit of a customer at Party levelSummary: I need to create an analysis that considers the credit limit of a customer at Party level, all the subject areas that I found that have the credit limit are at …
-
FAW - How to show Data Labels in the Sankey VisualizationSummary: We have a sankey visualization - showing the Revenue and Operating expenses - broken down in different categories. Users want to see the each bucket's values as…
-
positioning FAW on top of Supply Chain Planning Cloud (Demand Management Cloud, Supply Planning ClouSummary: Has anyone built FAW analytics using Supply Chain Planning Cloud and EBS (Procurement, Financials, Inventory, Order Management) data with drill down/deep link c…Vishnuvarth Subramanian-Oracle 21 views 0 comments 0 points Started by Vishnuvarth Subramanian-Oracle Reporting and Analytics for ERP
-
positioning FAW on top of Supply Chain Planning Cloud (Demand Management Cloud, Supply Planning ClouSummary: Has anyone built FAW analytics using Supply Chain Planning Cloud and EBS (Procurement, Financials, Inventory, Order Management) data with drill down/deep link c…Vishnuvarth Subramanian-Oracle 21 views 0 comments 0 points Started by Vishnuvarth Subramanian-Oracle Reporting and Analytics for ERP
-
FBDI Fails to import Data containing Double Quotes(")Summary: FBDI Fails to import Data containing Double Quotes("). We are loading Items through "ItemImportTemplate" FBDI template. In item description we have data like WO…Lucky Sharma 171 views 8 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
PRC: SQL to get the Cost Center Owner approver's email address on RequisitionsSummary: We are currently investigating the process of being able to extract the Cost Center Approver email address. The cost center owner approval is setup in the secon…
-
Bursting Enabled or DisabledHi Team, We wanted to check if we have a table or sql query to check how many reports have bursting enabled so a report or list can be prepared for the same. Please let …Swapnil Kashid 41 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
OTBI-Report-Supplier Portal - Invoice Real Time-Roles RequieredSummary: OTBI-Report-Supplier Portal - Invoice Real Time-Roles Requiered Content (required): Hello The following document state the role required to run the Supplier Por…Cesar Saveedra 61 views 3 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for ERP
-
Restrict OTBI report data(using subject area) to logged in userSummary How to restrict OTBI report data(using subject area) to logged in user. Currently it shows all data. Data access given at Business Unit level for the role.Conten… -
ESS Job ArgumentSummary ESS Job ArgumentContent Good People, We have a single argument for an ESS Job which is a STRING field. Unfortunately in the values we have DATA with comma e.g. A…Soumya Prakash Parhi 59 views 2 comments 1 point Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
Table which holds notification modeSummary: We need table name which holds notification mode Content (required): table to print notification mode Version (include the version you are using, if applicable)…Nishanth B Jain 31 views 3 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP -
Queries behind ADF pagesSummary: Is there a way to inspect queries behind the ADF pages in Fusion ? Content (required): Is it possible to get access to the queries/view objects behind a Fusion … -
Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to FuContent Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to Fusion App Drill-Down Actions" white paper (which had most rece…Marybeth Snodgrass 25 views 1 comment 3 points Most recent by James Allen Reporting and Analytics for ERP -
Due Date Calculation Formula based on Terms Date and Terms Name in OTBI ReportSummary Looking for a formula to derive Due Date based on Terms Date and Terms Name in OTBI RepoertContent Hi All, I have a requirement to derive Invoice Due Date based …
-
Convert OTBI analysis / report to BI Publisher reportSummary Convert OTBI analysis / report to BI Publisher reportContent At our company the OTBI reports are running slow and long. I am tasked to convert OTBI analysis / re…
-
UK Payslip CustomisationSummary UK Payslip CustomisationContent Hello Experts, Need your help. Can you please help if you have already done UK Payslip Customisation; Like the details of the cus…Bhaskar Konar-83539 63 views 2 comments 0 points Most recent by Bhaskar Konar-83539 Reporting and Analytics for ERP
-
OCI – ERP Analytics: What's New And What's Next On The ERP Analytics Roadmap, 27 April 2021, 9 a.m.Content Submit your questions for the OCI – ERP Analytics: What's New And What's Next On The ERP Analytics Roadmap session to have them answered during the live event. P…mauricio -Oracle 31 views 0 comments 2 points Most recent by mauricio -Oracle Reporting and Analytics for ERP -
Accessing External DataSource via Fusion BIP reportsSummary We have a requirement to build a report the data of which will be in oracle cloud as well as in external database.Content Hi Guru's We have a requirement to buil…_IshanAgarwal 233 views 5 comments 0 points Most recent by Pradeep Rananaware-216731 Reporting and Analytics for ERP
-
Extract Cost Center from "Code Combination Description" field - (Procurement - Spend Real Time) subjSummary Extract Cost Center from "Code Combination Descpription" fieldContent I am using "Code Combination Description" field as one of my select columns from (Procureme…UjasB 235 views 5 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
Tables to query files imported to ERPSummary We want to create a report that list the files imported to the ERP from external systems for reconciliation purposes.Content Hello evryone, Anyone can hep me to …User_B9AX9 70 views 1 comment 0 points Most recent by Christian Guidibi Reporting and Analytics for ERP
-
Date format issue with Excel template in BIPSummary Date format issue with Excel template in BIPContent Hi Friends, We have date format issues while using Excel template in BIP so could you please suggest if anyon…Sudha KOVURU 82 views 9 comments 0 points Most recent by Hariharan123 Reporting and Analytics for ERP -
Reporting from both Oracle ERP Cloud and PaaSSummary How to build report using data from both Oracle ERP Cloud and PaaSContent How to build a report using data from both Oracle ERP Cloud and PaaS? What are the vari…Vamshi Mohan 70 views 2 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
Limit number of lines per pageSummary I have an invoice where I want to limit the number of lines that appears per pageContent Is there an IF statement that could limit the number of lines that appea…Mohammad Alhindawi 53 views 3 comments 0 points Most recent by RichardChan Reporting and Analytics for ERP
-
Query to retreive Custom BI Report details in CloudSummary Query to retreive Custom BI Report details in CloudContent Hi Team, Which table will give the information of the custom BI Reports created in Oracle ERP Cloud? T…Abhilash K - Deloitte USI 386 views 7 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for ERP -
Dynamic List of Values for ESS JobSummary Dynamic List of Values for ESS JobContent Hi, How to create a 'Dynamic List of Values for ESS Job' , I cant use the lookup and table type valueset is not working…Soumya Prakash Parhi 142 views 12 comments 3 points Most recent by RaviThejaDarbha Reporting and Analytics for ERP