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
-
po number - po_amount - invoice amount - payment amountContent i need to create analysis to get these information po number - po_amount - invoice amount - payment amount -
Subledger Period Close Exceptions Report query timeoutSummary SQL query time exceeds the limit (2400 sec). Stopped processing.Content Hi, just wondering if anyone has any experiences with the Subledger Period Close Exceptio…User_2025-02-10-13-18-56-927 32 views 0 comments 2 points Most recent by User_2025-02-10-13-18-56-927 -
Invoice attachment link in OTBI analysisContent Hi, Looking to see if there is a way to provide a hyperlink in an OTBI analysis that would open up (preferably in a new window) an attachment associated with an …
-
BPM Worklist - Approval Aging ReportSummary Report to calculate the average time it takes approver to approve a taskContent Hello, We have a requirement to build out a report/analysis to calculate the aver…
-
Report and Dashboard prompts on multi tab DashboardSummary Prompts not clearing and show selections from other report promptsContent I have a multi tab Dashboard with two to three reports on each tab. Each report has it'…
-
How to Add the OTBI Dashboard to the Financial Reporting Center?Summary How to Add the OTBI Dashboard to the Financial Reporting Center?Content How to Add the OTBI Dashboard to the Financial Reporting Center? OR If i can make it more…
-
Can we have a multiple bursting in one reportSummary Can we have a multiple bursting in one reportContent Hello, Can we have multiple bursting in one report, I can create multiple burstings within the data model an… -
Frequently Changing HierarchiesSummary How to perform GAAP reporting on Legal Entity Rollups in ERP CloudContent All we have a use case, which I don't think is that unique, yet I am struggling with ho… -
Report to find requisition approval reassignmentsContent Hi, We need to create a BI Report showing which requisitions were reassigned to other users. The FND_BPM_TASK_VL/HISTORY tables don't seem to have this informati…
-
21A Unable to see historical ESS jobs e.g. from last year or previous years, is this a limitation?Summary 21A Unable to see historical ESS jobs e.g. from last year or previous years, is this a limitation?Content Hi Experts, We would like to ask 21A Unable to see hist…
-
How to use multiple delivery channels in Bursting query -Fusion BISummary We would like to explore the option to set delivery channel as SFTP and also we want to send delivery status notification to one particular email address .Conten…
-
Why is there no output from a scheduled OTBI report when the interactive version works fineSummary A report with csv output with parameters can be run interactively, but when scheduled no output can be found in scheduled processes, but available though e-mailC…
-
Difference between OTBI subject area "Real time" and those without "Real time"Content Hi all, Please explain as to what is the difference between the OTBI subject area "Real time" and those without "Real time" . Best Regards, Vipusha
-
No data in Account Analysis ReportContent Steps to reproduce: Run Account Analysis Report Process -> Select parameters and filter with some accounts -> Process ends "Success" -> Open the file -> There is…
-
BI Publisher report should send email with Digital signatures in email body.Summary We have a business requirement to digitally sign the email while transmitting transaction prints to customers. Basically, the email body needs to have the digita…
-
how to notify once multiple ESS jobs are completed through BI report?Summary how to notify once multiple ESS jobs are completed through BI report?Content We have a requirement of executing ESS jobs like Reevaluation and spot translation i…
-
Unpaid ReasonSummary Unpaid ReasonContent Which subject area and/or database table and column would store the "Unpaid Reason"? I am looking to create a report with this field. Thanks… -
Can Saved Custom Groups be used in Calculations/Formulas?Summary Using Custom Groups in Calculated ItemsContent In OTBI, I've designed an analysis where I've created custom groups of the Natural Account Segment Code using GL -…
-
OTBI Drill down to External Cash Transaction - Blank transaction pageContent I cant get the drill down to External Cash Transactions to work in my OTBI Analysis. Everything seems to be fine and I am redirected as expected. The problem is …
-
execute multiple repots with one ESS jobContent We have registered an ESS job with a report in ERP bursting enabled. This ESS job will be called from Oracle Integration cloud. it works fine. But we have 20 suc…
-
How to get the gl account segment 'description' from BICC PVO extracts?Summary How do we get the gl account segment 'description' from BICC PVO extracts?Content How do we get the gl account segment 'description' from BICC PVO extracts? We a…
-
Custom Purchase Order template works fine when PO is in Draft status but does not work when PO movesSummary Custom Purchase Order template works fine when PO is in Draft status but does not work when PO moves to Open statusContent Hi, The Custom PO template works as ex… -
Table to get BI Report Template and Data Model DetailsSummary Table to get BI Report Template and Data Model DetailsContent Hello, In EBS, we had XDO tables which stored BI Report and Data Definition details. Do we have any… -
How to use Flexfield feature at BIP data model?Content Hi, Are there any document about BIP data model flexfield feature? I hope the feature make me easy to query AFF info when I create custome BIP report. Thanks
-
OTBI Analysis: Connect 2 Subject Areas of General Ledger - Balance Real Time and General Ledger - PeContent Hello There, I have an OTBI analysis for Subject Area: "General Ledger - Balances Real Time". I would like to add column 'Accounting Period End Date'. This is ma…
-
Generate Financial Reports and Account GroupsContent I found the Scheduled Process Generate Financial Reports and Account Groups that is supposed to generate the following reports: * Consolidated Income Statement *…
-
Deep Links Results in Blank PageContent Hello, I have created my first Oracle Cloud ERP OTBI report with deep links to invoice. When I run the report, I have a hyperlink as expected, but the result is …
-
OCI – ERP Analytics: What's New And What's Next On The ERP Analytics Roadmap, 27 April 2021, 9 a.m.Content Submit your questions for the OCI – ERP Analytics: What's New And What's Next On The ERP Analytics Roadmap session to have them answered during the live event. P… -
ERP – The Data Privacy Conundrum – Old Issues, New Nuances and Novel Solutions, 4 May 2021, 9 a.m PTContent Submit your questions for the ERP – The Data Privacy Conundrum – Old Issues, New Nuances and Novel Solutions session to have them answered during the live event.…
-
Child account not reflecting under Parent account in Smart ViewSummary Child account not reflecting under Parent account in Smart ViewContent After creating a new account, when refreshing Smartview report I noticed Its not reflectin…