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
-
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… -
Create Advanced Financial Controls Report with Deep Link to AP InvoiceSummary This video shows how to create an AFC report in OTBI with a deep link to drill to an AP Invoice. The documents referenced describe the various deep links that ca… -
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… -
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…
-
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… -
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…
-
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…
-
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… -
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…