Reports
Discussion List
-
Exit the Foreach Loop after fetching once value in XSL TemplateSummary We have an requirement where if there are multiple Invoice lines with PO numbers,but we have to fetch any one of the PO number from lines in XSL template from Pa…User_9SGJ3 41 views 4 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP -
Need Help with E-textSummary Arabic data getting Jumbled in Etext tempalteContent Hi There, We are having a requirement wherein the data in the database is in Arabic. We are preparing the e-…Sahil Makhiza 35 views 24 comments 1 point Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
Show Declaration while running BI ReportSummary Show Declaration while running BI ReportContent Hello Experts Is there a place where we can show declaration before running/scheduling a report ?A checkbox will …Murthy Kodavati 35 views 4 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP -
Need SQL join to show bank assignment to supplier siteSummary We assign bank accounts to supplier sites, I need the table joins to allow me to create a data model to show which bank account is assigned to each supplier site…Sarah Munro 12024679 231 views 2 comments 0 points Most recent by Sarah Munro 12024679 Reporting and Analytics for ERP -
RTF Template Table Overflow - SolvedSummary RTF Template Table Overflow to a different table in the same RTFContent Hi, I am trying to create a report where the data overflows from one table in an rtf to a…
-
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…
-
OTBI Reporting reporting Invoice Summary + checking hold statusSummary Wanting to report on Invoice summary (outstanding, in progress etc) but need to be not on holdContent Hi I am using the Payables Invoices Transactions Real Time … -
what is the role of ar_receivable_applications_all.display columnContent ar_receivable_applications_all.Display = 'Y' or 'N' what will happen in each case. Can anyone explain? BR LuckyLucky Sharma 71 views 6 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP -
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…
-
OTBI performance recommendations V2 paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…Pavel Buynitsky-Oracle 83 views 2 comments 5 points Most recent by Pavel Buynitsky-Oracle Reporting and Analytics for ERP
-
OTBI Dashboard to Monitor AssessmentsSummary Includes deep drills to control and assessment records in Risk Cloud pagesContent This dashboard is useful for monitoring and acting on open assessments as well …Stephanie Golly-Oracle 69 views 0 comments 3 points Most recent by Stephanie Golly-Oracle Reporting and Analytics for ERP -
Adding comments to FRS reportsSummary Add comments to specific cells in an FRS reportContent Hi All, Hopefully someone out there can help me with this, as its driving me slowly mad. We are currently … -
Need help getting drill to detailed analysis from pivot table to workContent I'm trying to create a dashboard which contains some prompts and a pivot table. When a value in the pivot table is clicked, I want the detailed report to open. T… -
Security Role for Access to Payable Invoice Register ReportSummary I'm looking to setup a custom role that gives access to the Payables Invoice Register ReportContent It seems like I've given permissions that should be sufficien…David Rabalais 35 views 2 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP -
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 48 views 1 comment 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP
-
How to call oracle functions from BI Data model ?Summary How to call oracle functions from BI Data model ?Content Hi, In EBS i used to build custom functions and i was using it in discoverer. i am looking for function …Shlomo Elnekave 138 views 3 comments 0 points Most recent by Sahil Makhiza 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 260 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
-
Performance of BI GL balances querySummary Performance of BI GL balances queryContent The Attached BI query timesout when executed with just the tree values. I have passed nulls for the remaining levels c…saravana maneeian subhramaniun 62 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI 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 152 views 1 comment 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
OTBI dashboard operators link to BI publisherSummary Can we use OTBI dashboard operators in BI Publisher sqlContent We are embedding SQL query based BI publisher report in OTBI dashboard. The OTBI dashboard has an …saravana maneeian subhramaniun 87 views 6 comments 0 points Most recent by Karina Ogata Reporting and Analytics for ERP
-
Analytics / Dashboards to measure efficiencies from ERPSummary Tracking KPIs using Oracle Analytics to measure efficiencies from ERPContent Are you using any Oracle seeded reports / analytics / dashboards to measure KPIs / e…User_QZ639 54 views 2 comments 0 points Most recent by Sophie RUDENT Reporting and Analytics for ERP
-
Actual Cost Tranactions year Wise in OTBISummary Actual Cost Tranactions year Wise in OTBIContent Hi Experts, I am creating OTBI report for one of the columns I need to display Actual cost year wise Ex: Actual …
-
OTBI Report how to only have the last valueSummary I have a report for asset that have cost and Net book value, but i have all the different net book value instead of only having the last net book valueContent He…Francis Thériault 59 views 5 comments 0 points Most recent by Muhammad Hamza Hanif Reporting and Analytics for ERP -
Standard report shortcut icon by name on dashboardSummary Seeded Report icons by namesContent There are multiple reports in the Report and analytics Based on client need can we make shortcuts of reports as icon on the d… -
Find parent value in CoA hierarchy for balancing segment in OTBIContent As an investment fund manager , my company closes the periods per FUND which is defined in the hierarchy of the Balancing Segment Chart of Accounts. As per Oracl…MaartenDIF 133 views 8 comments 1 point Most recent by alexey.shtrakhov 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 62 views 4 comments 0 points Most recent by Sujan Gutha Reporting and Analytics for ERP -
URL to download expense report attachments from UCMSummary URL to download expense report attachments from UCMContent Hi, I am trying to download the attachments in my expense report from UCM. I was able to fetch the DM_…Shifa Nazumudeen 164 views 8 comments 1 point Most recent by Shifa Nazumudeen Reporting and Analytics for ERP