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
-
ESS Jobs to be run to create Cube'sContent Hi Team, Can you please let me know the list of steps to be run to publish the data to cube, so that we can design FRS reports. I'm working on FRS reports, when … -
List of Seeded OTBI reports in Oracle ERP CloudSummary List of Seeded OTBI reports in Oracle ERP CloudContent Hi, Is there a way to get the list of seeded OTBI reports from our instance? I would also like to query th… -
OTBI Report on Cross subject areasSummary PPM-AP Cross subject area reportContent We are implementing fusion Financials and PPM. The current practice is, project managers in PPM get to know the details o…
-
OTBI - ConcatenationSummary Is it possible to create a field that concatenates two or more text fields in an OTBI analysis?Content I am trying to create an OTBI Analysis using the Procureme… -
Can we find all scheduled BI Reports instead of navigating to each reportSummary Can we find all scheduled BI Reports instead of navigating to each reportContent I was trying to find if we can find all scheduled BI Reports instead of navigati…
-
Public Sector - budget to actualsSummary Budget to Actuals reports in Public SectorContent Hello, Have any other public sector Oracle Cloud users developed a good budget to actuals report? We have one t… -
Is there a size limit for email attachment for BI reports?Summary BIP - Report size is 15MB, job succeeds but never sends email.Content My report generates 15MB excel file but fails to email the report every time. I limited my …
-
Connecting Workiva Cloud Service with ERP Cloud for SEC ReportingSummary Would like to know if anybody has done this connection and how worksContent Hello, I'm trying to learn from somebody that already experienced how to connect Work… -
Remove SpaceContent Hi, Below is the query which concatenates all the category names and provides in single column value which works fine. I have registered this report as ESS Job w… -
FR studio dividing by 0 causing issues.Summary FR studio dividing by 0 causing issues.Content Column a= 634.74 Columnb= 0.00 Columnc= -([a]-[b]) = (634.74) columnd= [c]/[b]*100 = (should be 0 but getting weir…
-
A report that tracks user access activity historySummary A report for security that tracks user login history what data or module was touchedContent Does anyone know how/where I can get this information together? This …
-
Drill to Fusion from a BI Publisher ReportContent Hi, I have created a very useful data model that will allow our users to search for payments, what I would like to do is link the invoice numbers to oracle fusio…
-
OTBI computed field and graphSummary creating computed field and graphContent Hi all, I am very new to Oracle Fusion business intelligence. Background: * Fusion 19C * try to analyze the company's em…User_2025-02-06-11-24-12-541 39 views 0 comments 2 points Most recent by User_2025-02-06-11-24-12-541
-
Receiving Error When Prompting Values from Field Created from a Case StatementSummary Cannot function ship the following expression: EVALUATE. (HY000)Content I have created a Dashboard Analysis and Prompt from the following subject area: Subledger…User_2025-02-05-07-37-39-271 23 views 0 comments 1 point Most recent by User_2025-02-05-07-37-39-271
-
BIP PO rtf Template archive querySummary Displaying the Line Level Notes to Supplier in the PO Template in BIPContent Hi, I have a requirement to display "Notes to Supplier" field on to PO rtf Template …User_2025-02-05-10-39-37-202 38 views 8 comments 1 point Most recent by User_2025-02-05-10-39-37-202
-
"Apps Document Currency Code" in Procurement - Procure To Pay Real TimeSummary "Invoice Currency" missing in Procurement - Procure To Pay Real Time Subject Area.Content In 19B version, the invoice currency seems to be missing in Procurement…
-
Balance Sheet totals different for different usersSummary Balance Sheet totals are different for two different users, same reportContent Two users in our office have opened the same Balance Sheet report, same parameters…User_2025-01-31-00-03-48-847 32 views 5 comments 0 points Most recent by User_2025-01-28-21-13-11-074
-
Security setup for users who are creating BI reportsSummary What job role does an employee require to create and run BI reportsContent Morning everyone, We are currently implementing Oracle Expense Cloud. Our BI team has … -
Prepayment BalancesSummary Query for Prepayment BalancesContent Hello, We are looking to build a report that lists all current prepayments and balances, there was a Prepayments Status Repo…
-
Syntax Error While Using Evaluate in OTBI AnalysisSummary Evaluate function generates a syntax error when using REGXP_SUBSTRContent I am attempting to trim the following column in the General Ledger - Journals Real Time…User_2025-02-05-07-37-39-271 55 views 10 comments 2 points Most recent by User_2025-02-05-07-37-39-271
-
Oracle Will Not Support Internet Explorer 11 After Update 19DSummary Oracle Will Not Support Internet Explorer 11 After Update 19DContent Oracle Will Not Support Internet Explorer 11 After Update 19D.Since the release of Microsoft… -
Standard Functionality Regression Testing after patchset applicationSummary How much standard functionality testing you do after patchset application such as 19A, 19B, 19CContent Hello everyone, Just wanted to get a gauge of how much sta…
-
What role can be assigned to give a user OTBI access for report writing?Summary What role can be assigned to give a user OTBI access for report writing?Content What role can be assigned to a user for OTBI access for report writing? I can see…User_2025-01-31-00-03-48-847 104 views 6 comments 1 point Most recent by User_2025-01-31-00-03-48-847
-
PO-Requisition cross-subject area reportSummary PO-Requisition cross-subject area report in fusion saasContent I am trying to create a simple cross-subject OTBI Analysis to display PO details alongwith the Req…
-
Changes to BIP report are not reflectingSummary Changes to BIP report are not reflecting in the data. We have changed few columns in the Dataset but the report output displays old column data.Content Changes t… -
XML Structure of BIP reportContent Hi, I need to create a BIP report which is extracted as an XML. Below is the sample xml structure and sample XSD. How do I define an attribute of an element whil…
-
Journal Entry Reserve LedgerSummary Customization of the Journal Entry Reserve LedgerContent I'm customising the Journal Entry Reserve Ledger report - I am trying to add new data columns and change…
-
Unable to pull data from FA_BALANCES_REP_GT table in the seeded Reserve Summary reportSummary Unable to pull data from FA_BALANCES_REP_GT table in Reserve Summary report due to this in an Oracle only internal reportContent I'm trying to find a table/table…
-
otbi procurement subject areaSummary Has any one used procure to pay real time and pruchasing real time subject area togetherContent I am trying to get po number ,invoice number from procure to pay …
-
Report to show all invoices, amounts, VAT and attachmentsSummary A report that will identify all invoices, with invoice amount and VAT amount along with a field that pick up the file attached name (including extension i.e. .pd…