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
-
Issues with 18C upgrade and Chrome?Summary Anyone seeing issues with Chrome and 18C?Content We upgraded to ERP 18C last weekend. Since then we have had numerous errors with the ADFDi install and with pop … -
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… -
Tax Registration NumberContent Hi, I would like know in which table the tax registration number is stored which is available under Miscellaneous tab in Invoice Header and please find the attac… -
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 … -
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 …
-
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…
-
need erp r12 tables (oe_order_headers_all,oe_order_lines_all) in oracle fusion cloudSummary need erp r12 tables in oracle fusion cloudContent need erp r12 tables (oe_order_headers_all,oe_order_lines_all) in oracle fusion cloud -
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
-
How to Show the Text Attachment Content in the PO PDF Print OutSummary How to Show the Text Attachment Content in the PO PDF Print OutContent I tried to create custom datasource from Content Server but it return nothing when we adde… -
Outbounds from FinancialsSummary How can we update DFF attributes for Outbounds from FinancialsContent How can we update DFF attributes for Outbounds from Financials to ensure that on a daily ba…
-
Tables for Documents Attached to a ProjectSummary Tables for Documents Attached to a ProjectContent I am trying to create a custom data model to include document attachments in Manage Financial Project Settings …
-
How to DISABLE an extract in BICC.Summary Cannot find a way to disable the extract of a datastore.Content Hi. I already disabled the extract for a Data Store but It's still appearing (check image attache…User_2025-02-07-06-48-26-537 34 views 2 comments 0 points Most recent by User_2025-02-06-09-42-54-414 -
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…
-
How to fetch -4 days from to_date without weekend and holidaysSummary Hi, i need to fetch -4 working date from to_date. so here i am using gl_periods table to get start_date and end_date. end date -4 should be my to_date.Content Hi…
-
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 …
-
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…
-
Access PermissionSummary Disable access to Task in Setup and maintenanceContent Hello i need create special role to disable access permission to disable access permission for specified u… -
PO_RELEASES table equivalent in Cloud 20A?Summary Looking for the equivalent table.Content Hi. A coworker needs the table that replaces the Oracle 10g PO_RELEASES in Cloud 20A. Looked the Supply Chain mapping an…
-
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 …
-
Cannot show more than one field in Analytics.Summary If I try to use more than one field the data is not displayed. With admin privileged it worked.Content Hi. Recently I just got a proper personal account in our p…
-
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… -
ERP – BI Publisher: How to configure XSL and RTF templates, 9 June 2020, 9 a.m. PT - Submit QuestionContent Submit your questions for the ERP – BI Publisher: How to configure XSL and RTF templates session to have them answered during the live event. Post your questions…
-
Practice QuestionsSummary Practice Questions
-
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… -
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… -
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_… -
Electronic Purchase Order Submission ReportSummary Purchase Order submitted ElectronicallyContent hi Guys, I am creating a report for Purchase Order submitted Electronically. How do I identify PO is submitted ele…
-
Attach Custom List of Value to ESS JobSummary Custom List of Value to ESS JobContent Hi Experts, I have two questions pertaining to ESS jobs and are as follows:- 1) How can I attach a custom list of value to…
-
Difference between data in Essbase Cube and Fusion Transactional dataSummary Trying to illustrate the difference between what data is stored in the Financial Essbase Cube and what is in the Fusion transaction database.Content Hello Everyo…