Tip
Discussion List
-
Report needed for default expense accountSummary Report needed for default expense accountContent Hi I am trying to get a report of all users on oracle and their default expense account on OTBI but cannot find …Doron de Jong-57089 164 views 9 comments 1 point Most recent by Ed Higgins Reporting and Analytics for ERP -
How to control the folder permissions in Reports and Analytics to user levelSummary Need to control users to access the folders within the permissions provided and controlled at the user level, Please provide the details how to control this fold…
-
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
Tables in which Printer name and details are savedSummary Tables in which Printer name and details are savedContent Whenever any Customer facing document/report is sent through a BIP report to the printers, is there any…
-
How to pass field value(s) from Page to OTBI (for report or dashboard generation) ?Summary An iFrame is created in an existing Page layout in order to accommodate a OTBI report. How to pass field value(s) from Page to OTBI (for report or dashboard gene…
-
How to create custom XML output formatSummary How to create custom XML output formatContent Hi All, We have to generate a custom .xml output file from ERP cloud . How can we generate XML output file from BIP…Najeeb_ACN 224 views 5 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
Spend calculations - Procure-To-Pay Subject AreasSummary How is Spend value calculated in Procure-To-Pay Subject AreasContent Gurus, Looking at seeded 'Top 10 Spend by Category' OTBI report and see Spend column. Wonder…Manoj Acc 49 views 1 comment 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP
-
R13 Query Open AR InvoicesSummary AR Cloud ReportContent Hello : I was wondering if you can hep me about an AR Invoices Report for Cloud. Please Advise Below is the SQL but it only works for EBS …gabriel kinovisques-163562 241 views 7 comments 0 points Most recent by gabriel kinovisques-163562 Reporting and Analytics for ERP
-
How to increase the query time out in Oracle fusion BIPContent Hi Team, One of report is getting error due to query time out. We want to increase the query time out for this report. Could you please do the needful. Version 2…Jayaprakash Mathakamalli 169 views 6 comments 0 points Most recent by Jayaprakash Mathakamalli Reporting and Analytics for ERP
-
Fixed Assets - Asset Balances Real TimeSummary Assets OTBI Report for CIP not showing balancesContent Hi FA Experts, We built an OTBI report with Fixed Assets - Balances Real Time Subject area to display bala…Muhammad Hamza Hanif 157 views 1 comment 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
ESS Job Dependant Parameter LOVsSummary ESS Job Dependant Parameter LOVsContent Hi , I need to create two LOVs for Supplier Name and Its dependent Supplier Site for the ESS Job. Is this feasible ? I ca…Soumya Prakash Parhi 63 views 4 comments 0 points Most recent by Sujan Gutha Reporting and Analytics for ERP -
How to remove html tags from report outputContent Hi team, We built some Analysis based on Sourcing related subject area's Where we see some html texts in the resulting columns like below. How remove these sufix…Nishanth B Jain 136 views 5 comments 0 points Most recent by Anandakrishna Thamballa Reporting and Analytics for ERP -
How to register ESS Jobs in R13 20B?Summary How to register ESS Jobs in R13 20B?Content Hi Everyone, Can you please share your thoughts on How to register ESS Jobs in R13 20B? Thanks, -
Tracking non-financial information related to a chart of account segment for reporting with GL BalanSummary Does anyone have recommendations for storing non-financial information related to a chart of account segment and related GL Balance?Content We have some non-fina…Amber St John-145528 31 views 1 comment 0 points Most recent by ndryden Reporting and Analytics for ERP
-
Drill Down in OTBI for code combination balance to journal linesSummary Drill Down in OTBI for code combination balance to journal linesContent Use case: We need to build a report listing all the account code combination balances and…Sumanth Kunimakki-21932 64 views 3 comments 1 point Most recent by rajArun Reporting and Analytics for ERP
-
BI Query to get Difference between Dates in numeric formatSummary We have requirement to get the Average time required to complete particular ESS Job in Minutes or Seconds.Content Here are more details - We need to calculate th…
-
Modifying Configurable Expense Report TemplateSummary Access in current user detailsContent Hi,We want to access current logged in user details in configurable expense report template,1. Is it similar to how do it i…Mohak Kirtane 41 views 0 comments 0 points Most recent by Mohak Kirtane Reporting and Analytics for ERP
-
jai_tax_lines_all & jai_tax_types tables in oracle fusionSummary jai_tax_lines_all & jai_tax_types 2 tables which are in r12. Please send relevant tables for these.Content jai_tax_lines_all & jai_tax_types 2 tables which are i…Nageshwaran1 686 views 3 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP -
How to add one day to the PaymentDate in XSL Template?Summary Need to add one day to the PaymentDateContent I am trying to customize XSL Stylesheet (HTML/XML/Text) tempalte, My requirement is add one day to the payment date…OraFusionworld 54 views 0 comments 1 point Most recent by OraFusionworld Reporting and Analytics for ERP
-
Subledger job inquiry for up to date reportingSummary Subledger job inquiry for up to date reportingContent We are just starting to develop reports in BI/OTBI Oracle Fusion as a newer client. We've previously only m…Amber St John-145528 39 views 3 comments 1 point Most recent by Amber St John-145528 Reporting and Analytics for ERP
-
anyone know how to accomplish that in OTBI?Summary show a report column based on a conditionContent I am using General Ledger - Journal Real time subject area to create a report to show Journal line amount and th… -
show project number on GL reportsSummary we building a report to show subledger details like invoice number , supplier etcContent we would like to figure a way to show project number on the GL report we…Sam Solomun 72 views 2 comments 0 points Most recent by Dustin Grabowski-Oracle Reporting and Analytics for ERP
-
Advanced CollectionsContent Hello All, Do we have any OTBI subject area which gives data related to Collections. Ex: Collector wise collections. Thanks, NishanthNishanth B Jain 119 views 7 comments 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP
-
Some users do not have the archive and unarchive optionContent Some users do not have the archive and unarchive option, any ideas? Please share if you know. Thanks.Amy Chan 45 views 6 comments 1 point Most recent by Karthikeyan Sukumar Reporting and Analytics for ERP
-
Period Name- In OTBI reportSummary Need perod name should populate like DEC-FY-20 (DDDFFYY)Content Hello Team, We want to have the Period name in our OTBI report in the format 'DEC-FY-20', 'SEP-FY…Saurabh Sharma_HCL 143 views 1 comment 0 points Most recent by ndryden Reporting and Analytics for ERP
-
Lineage document for Oracle Analytics For Fusion ERPSummary This document provides the lineage report from Subject Area to data warehouse table and column.Content Enclosed Oracle Analytics For Fusion ERP subject area to d…Ramamurthy Shankarachetty-Oracle 173 views 1 comment 1 point Most recent by Chandra Yerra Reporting and Analytics for ERP
-
Daily Report that highlights supplier submitted invoicesContent Dear, Please can someone advise how to set up a report that can be scheduled daily to provide us with any new invoices that have been submitted by the supplier s…Tony Roff 37 views 4 comments 0 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for ERP
-
Expenses Overview Real Time subject areaSummary A summarization program needs to be run to gather information before data is available in this area.Content We are creating some test reports from the Expenses O… -
Can we find all scheduled BI Reports instead of navigating to each reportSummary Can we find all scheduled BI Reports instead of navigating to each reportContent I was trying to find if we can find all scheduled BI Reports instead of navigati…Balaji Paripati-112966 59 views 3 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Security setup for users who are creating BI reportsSummary What job role does an employee require to create and run BI reportsContent Morning everyone, We are currently implementing Oracle Expense Cloud. Our BI team has …Jennifer Wolfe 57 views 5 comments 1 point Most recent by Michael Cook Reporting and Analytics for ERP