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
-
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 … -
About new Oracle Redwood UI for ERP and SCM.....Summary Do we know from which version this new UI will be available for customers? Or some estimated time to be applied? -
View Objects to get Invoice Headers and its Business Unit?Summary Need Invoice Header and Business Unit of those invoices.Content Hi. I'm working with VO extracts in Tableau. I'm using: fscmtopmodelam_finapinvtransactionsam_inv… -
Payment Remittance AdviseContent Hi, I need to customize Payment Remittance Advice report for which please help me the underlying data model and the path of the report attached Thanks -
Customer Part Number/Customer Item Number field found in which tables that should refer HZ and wsh tSummary Customer Part Number/Customer Item Number field found in which tables that should refer HZ and wsh tablesContent Customer Part Number/Customer Item Number fields… -
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… -
20A/20B New Feature Session for Financials Cloud_For China CustomersSummary Reply and materials of 20A/20B New Feature Session_For China CustomersContent This is reply of FIN Cloud 20A/20B New Feature Session held by China CSM team and S…
-
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… -
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…
-
Procedure to archive data in Oracle Financial Cloud.Summary What is the procedure to archive data in Oracle Financial Cloud ?Content What is the procedure to archive data in Oracle Financial Cloud ? Appreciate if anyone c… -
Creating Custom Infolets for ProcurementSummary Creating Custom Infolets for ProcurementContent Hi All, Is there a way of creating custom infolets for procurement? If yes, then please let us know the details a…
-
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 35 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 …