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.
Note!! Please register for a free account to access the full content and also to participate in Q&A in the community
Reporting and Analytics for ERP
Discussion List
-
็How to custom Trial Balance ReportSummary: How to custom Trial Balance Report by adding Filter Conditions accounting segment in Trial Balance Report Content (please ensure you mask any confidential infor… -
Requisition Approvals History - Approval history has been purged and no longer availableWe are getting the error 'Approval history has been purged and no longer available' when to view document history in requisition and purchase order. Is there any tables …
-
How to print "All" value in the output if BIP report is run for all parameter valuesHello Oracle Gurus, I have a requirement where the user is running the report with all parameter values. The parameter is Source. Currently if the user runs the report f…
-
What are the tables or SQL query to fetch ESS job name, Report name, Report path detailsHi Team, I have requirement to develop custom SQL query to fetch details like All ESS Job names, Display names, Report names, Report paths etc. I have used tables like E…
-
how to get json formatSummary: Hi, We've a requirement to format output into Json format. Is it possible to do OTBI / BIP Report in this format? Any help is highly appreciated. Thank you! -
Drill Down To Fusion Financial Applications from OTBI ERP ReportsSummary The purpose of this White Paper is to demonstrate how users can drill from Oracle Transactional Business Intelligence (OTBI) adhoc reports to transaction details… -
Automatically create a prepayment invoice from POSummary: Is there a way to automate the creation of prepayment invoices in AP from a PO? We would like to be able to create a PO and somehow specify the PO is expected t… -
SQL for Project Events InvoiceSummary: Trying to get the approved Invoices only and I am getting incorrect values. Content (please ensure you mask any confidential information): Code Snippet (add any…
-
FUSION_APPS_PROV_PATCH_APPIDSummary: we saw in audit log that the user- Provisioning Patch Application Identity - user ID: FUSION_APPS_PROV_PATCH_APPID has added the role ORA_FND_APPLICATION_DEVELO…
-
OTBI DocumentationContent i need a documentation in OTBI , or videos .
-
How to Include Accounts with No Activity in customized reportContent Dear , I create customized trial balance report. in which i create a opening balance but in some accounts its shows wrong data. so i figured out and now i want t… -
How to remove double quotes when getting output in csv pipe delimited from BI ReportHow to remove double quotes when getting output in csv pipe delimited from BI Report
-
-
Which table contains payment final approver name?Summary: I need to add 'Final approver name' for payment to a sql query/bip. What is the table name please? Content (please ensure you mask any confidential information): -
I need to find Frieght amount for purchase order line BI publihser sql,Summary: i am looking to figure out where freight amounrt for purchase order line is stored, can any one help me ? Content (please ensure you mask any confidential infor…
-
24C regression - scheduled reports are completing successfully for invalid email addressesSummary: Content (please ensure you mask any confidential information): If an invalid email address is provided as xyz@abc, Till 24B, the delivery was failing and delive…
-
How do I get my OTBI Income Statement to default to the current GL period?Summary: My OTBI Income Statement is defaulted to January 2022, but we would like it to dynamically open to the current GL period. Content (please ensure you mask any co…
-
IC and GL Reports that capture DFF detailsDo we have any seeded report that can capture the details of DFFs configured in the following tables: IC- FUN_DIST_LINES GL- GL_JE_LINES If none, could you please sugges…
-
BIP Data Source: Secure HTTP ConnectionSummary: While setting up an HTTP connection in the Data Sources section, I noticed that the only authentication method available is basic authentication. I’m reaching o…
-
R13 Financials OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Orac…
-
ERP Cloud Fusion DatabaseHi, i have a customer that is asking about Disaster Recovery with defined Recovery-Point Objectives (RPO) and Recovery-Time Objectives (RTO) for my erp cloud fusion data…
-
Transactions Available for Reconciliation Report changing mandatory parameters BankAccount IDSummary: We want to run the report Transactions available for Reconciliation in Cloud but unable to see it when going to Scheduled processes >Submit process. Therefore, … -
Which Table Stores the GL Overridden Natural Account Code in Oracle Fusion?Summary: Hello everyone, I am currently working on a data model in Oracle Fusion and need to identify which table stores the value for the GL overridden natural account …
-
How to add the segments of the Chart of Accounts to the OTBI Subject AreaSummary: Unable to find the 4th and 5th segments of the Chart of Accounts in the General Ledger or Budgetary Control subject areas Content (required): Our COA has 5 segm… -
History Limit in ESS_REQUEST_HISTORY Table?Is there a limit to the history stored in the ESS_REQUEST_HISTORY table? I can see transactions in the view PAYROLL_FLOW that trigger a BIP report, but I'm unable to fin…
-
Need a query to get total of Current Cost, Accumulated Depreciation, Impairment for asset categoriesContent Hi all, Can someone give me a query that gives a total of : * Current Cost * Accumulated Depreciation * Impairment per asset categories in Fixed Assets Module. R… -
Is there a way to custom the buckets of Aging 7 Buckets?Summary: I need to change the period of the buckets. Content (please ensure you mask any confidential information): Is there a way to create a customized report based on… -
Payables Invoices - Transactions Real Time - does not return all invoicesSummary: Payables Invoices - Transactions Real Time - does not return all invoices Content (please ensure you mask any confidential information): Hi - if I run this SQL …
-
How does chunking data work for Oracle BICC extractsHow does Data chunking work for Oracle BICC extracts, typically for large volume extracts I want to use this feature. When I mention creation date and days in the Perfor…
-
Payables Invoices by Cost Centre/SupplierSummary Dashboard & reports showing summary of AP invoice value by period/cost centre/supplier, with drill-down to invoice detailsContent Please see attached documents f…