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
-
BI Publisher Group filterSummary BI Publisher Group filterContent I am getting the attached error when i am trying to add two filters. any idea why ? -
Tax Registration from Supplier Address out of Supplier Real Time OTBISummary Looking for Supplier's Tax Registration Linked to AddressContent I'm building a supplier report inside the Supplier - Supplier Real Time subject area and attempt… -
BI Tables to fetch Chart of Account segment dimensionsSummary BI Tables to fetch Chart of Account segment dimensionsContent Hi, Does anyone know how to fetch the Chart of Account value sets in fusion Saas? I tried the FND_I… -
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 … -
Supplier Registration Requests Error tableSummary Supplier Registration Requests Error tableContent We are trying to build a BI Report to send out a notification to the Supplier creation requester whose Supplier… -
Year-End closing processSummary What are the Year-End closing processes best practice?Content We are in the process to close the year in the system (for the first time) wondering what are the Y… -
Under INV_MATERIAL_TXNS table transaction_cost,prior_cost,transaction_value are empty, from where caSummary Under INV_MATERIAL_TXNS table transaction_cost,prior_cost,transaction_value are empty, from where can we fetch/map the fields to get the resultContent Under INV_… -
Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Summary Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Content Is "EDI Location Code" available for Reporting in Customer Real Time Su… -
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 … -
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…
-
Logiacl sql for cross subject area analysisSummary Logiacl sql for cross subject area analysisContent Hello All, I am trying to create a cross subject area logical sql for receivables as below. However I still ge… -
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…
-
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…
-
Multi-factor authentication for Fusion FinancialsSummary Can Multi-factor auth be enabled for Fusion?Content Can Multi-Factor Authentication be enabled for SaaS / Fusion Financials or Fusion in general? If not, what wo… -
PO Change Order Amount Changed column detailsSummary PO Change Order Amount Changed column detailsContent Hi Friends, Can you please help me to get Amount Changed column details when PO Change Order action performe… -
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… -
Dynamic Logo in RTF Template in FusionContent Hello Team, Could you please let us know how can we use the Dynamic Logo in RTF Template in Oracle Cloud/Fusion. Same logo is called in many other reports and ou… -
Viewing USD AmountSummary Viewing USD AmountContent Hi, We have many companies in different countries that have different currency. We designed an pivot table using OTBI for Purchase Orde…
-
Query to retreive Custom BI Report details in CloudSummary Query to retreive Custom BI Report details in CloudContent Hi Team, Which table will give the information of the custom BI Reports created in Oracle ERP Cloud? T… -
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…
-
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…
-
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 -
Need Custom Advance Shipment Report fileSummary Need Custom Advance Shipment Report Sample fileContent Need Custom Advance Shipment Report file
-
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… -
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…
-
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…
-
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…
-
Date format issue with Excel template in BIPSummary Date format issue with Excel template in BIPContent Hi Friends, We have date format issues while using Excel template in BIP so could you please suggest if anyon…
-
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 …