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
-
FRS scheduler how to pass current month or Date to PromptSummary FRS scheduler how to pass current month or Date to PromptContent We are scheduling FRS reports. When we create batch it requests to enter the prompt values. Thes… -
Email BurstingContent Hi, After submitting the Print Receivables Transaction report I found that the table AR_BPA_DELIVERY_DETAILS return no records due to which email bursting is not… -
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…User_2025-02-04-14-03-09-386 309 views 2 comments 0 points Most recent by User_2025-02-04-14-03-09-386 -
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 … -
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…
-
user getting error while clicking on Browse catalog under Reports and AnalyticsSummary User not able to access Reports and AnalyticsContent One of the client user not able to access reports page, he is getting error when he clicks on browse catalog…
-
Dynamic Pivot column in BI PublisherSummary Need the column of a pivot table to be dynamic in BI PublisherContent We have a requirement to display GL balances by BU hierachy and period. As the users can ru…
-
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…
-
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 Lucky -
Need relation between WSH_DELIVERY_DETAILS & DOO_FULFILL_LINES_ALLSummary Need relation between WSH_DELIVERY_DETAILS & DOO_FULFILL_LINES_ALLContent Need relation between WSH_DELIVERY_DETAILS & DOO_FULFILL_LINES_ALL -
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…