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
-
452 4.4.5 Insufficient disk space; try again laterSummary Failed Delivery of ReportsContent Does anyone have this error message for daily scheduled reports? I have a report that runs every morning and is sent to my emai… -
Multiple selection for Enterprise Scheduler JobContent Hello, Is it possible to do a multiple selection for a parameter in Enterprise Scheduler Job ? We don't have seen option to do this, and we can't write like this… -
BI Reports Usage AnalyticsContent Hello, Is there a way we can see the last time a specific BI report has been accessed by any user? Thank you Version 19DUser_2025-02-05-02-16-41-526 60 views 3 comments 0 points Most recent by User_2025-02-05-22-11-22-331 -
Unable to find Payables Invoices - Line Distribution for OTBISummary Report for AP invoice line - Account distributionContent I am writing a report in OTBI and I cannot find the Invoice Lines Distribution. The subject area is : Pa…
-
Payables invoices consolidated to 1 currency in OTBISummary Write report for AP Invoices from different BUContent We have many business units in our system and each of them are having different ledger currency. We would l…
-
OTBI Analysis - Profile Option ValueSummary Is it possible to access profile option value in OTBI Analysis?Content We are creating a custom profile and setting the values at user level. Is it possible to a…
-
HZ Classification ReferenceContent Hi Team, I'm looking for Classification Orginal System Referenc, If I join OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS and OWNER_TABLE_ID from HZ_ORIG_SYS_REFERENCES…
-
Dashboard or report to show all changes/updates to reports/data models for auditingSummary Hi we need a report that will show if any bi reports or data models for BI have been updated in the last 90 days for audit purposes? -
Accounts Receivables Month end closing in Cloud 20 ASummary Accounts Receivables Month end closing in Cloud 20 AContent We want to close AR month end closing in Cloud 20A. I developed a query from AR tables withe invoice …
-
Issue with finds captures authorization custom layoutSummary Length() not returning correct value when used with sum()Content Hi Experts, We are in oracle fusion 19D. We are using Oracle Business Intelligence 11.1.1.9.0 I …User_2025-01-30-00-35-05-558 18 views 0 comments 0 points Most recent by User_2025-01-30-00-35-05-558
-
Tables to query files imported to ERPSummary We want to create a report that list the files imported to the ERP from external systems for reconciliation purposes.Content Hello evryone, Anyone can hep me to …
-
Modifying Configurable Expense Report TemplateSummary Access in current user detailsContent Hi,We want to access current logged in user details in configurable expense report template,1. Is it similar to how do it i…
-
Creating a Batch in FRS (Oracle Cloud ERP)Summary Creating a Batch in FRS (Oracle Cloud ERP)Content Navigate to Work space for financial Reports I am trying to Schedule a Batch. I believe I need to create a batc… -
Sync COA valuesSummary keep the COA’s in all reporting cubes in syncContent Is there some way to keep the COA’s in all reporting cubes in sync? We have had issued where SMartview does … -
OTBI Dashboard Prompts are not visible in Google Chrome BrowserSummary OTBI Dashboard Prompts are not visible in Google Chrome BrowserContent Hi All, When we open OTBI dashboards in google chrome ( Version: 80.0.3987.149), the dashb… -
Disabl Primary Ledger status is In ProcessSummary Disabl Primary Ledger status is In ProcessContent Hello During create new primary ledger i mistake on ledger name , i create a another one and is work fine but m… -
Limit IT support users to use OTBI within their folder onlySummary Limit IT support users to use OTBI within their folder onlyContent Hi all, is there any way to limit those IT support users to access his/her folder only? Not ab…
-
Open Prepayment OTBI ReportSummary Open Prepayment OTBI Report with Validation status of Available that can be back dated to the prior month.Content I have an Open Prepayment report in OTBI from s…
-
plz clear whether vendor_id in ap_invoices_all and party_id in hz_parties results the sameSummary have a doubt whether vendor_id in ap_invoices_all and party_id in hz_parties should have same valueContent Can we join vendor_id in ap_invoices_all and party_id … -
Sourcing data for BI Publisher Reports from External Data sources including Oracle DBCS/DBAASSummary Building a BI Publisher report in Oracle Fusion Cloud ERP that shall source data from Fusion cloud database and some external data.Content We need to build a BI … -
Supplier address withholding tax tableSummary Supplier address withholding tax tableContent Hi, Which view contain the Withholding Tax Exemptions details and how to connect it with POZ_SUPPLIER_ADDRESS_V vie… -
Table "ALL_TABLES" - does not include all tables?Content Hi, When I run a query in BI Publisher Enterprise, I can for example, get results from this query: SELECT DISTINCT UPPER(table_name), num_rowsFROM all_tablesWHER…
-
Oracle ERP Cloud certification for PortugalSummary Cloud certification for PortugalContent Hi, We do business in Portugal and as per the local laws, Portuguese entities and foreign entities established in Portuga… -
Scheduled Report Attachment ProblemSummary Scheduled Report Attachment ProblemContent Hello, We have 2 agents which generate excel format files. One of them attaches excel file correctly. The other one ad…User_2025-02-06-13-32-07-115 19 views 2 comments 0 points Most recent by User_2025-02-06-13-32-07-115
-
Is there any way to run a BIP Data model / Report thru a web service and get the output as a responsSummary Is there any way to run a BIP Data model / Report thru a web service and get the output as a responseContent Hi Friends, Is there any way to run a BIP Data model… -
Can the parent of an account be added to a row in Financial Reporting?Summary Trying to add the parent of the account in a row to a report in Financial ReportingContent I have used member name to add the name of the account to an individua…User_2025-02-06-10-37-19-523 34 views 4 comments 0 points Most recent by User_2025-02-06-10-37-19-523
-
Smart View Install / Uninstall FailuresSummary Admin intervention necessary when deploying latest SV 11.1.2.5.910Content We are trying to get all enterprise users onto the same version of Smart View. We curre…
-
jai_tax_lines_all & jai_tax_types tables in oracle fusionSummary jai_tax_lines_all & jai_tax_types 2 tables which are in r12. Please send relevant tables for these.Content jai_tax_lines_all & jai_tax_types 2 tables which are i…
-
BI Publisher - looking for project status tableContent Hi, Does anyone know where I can find a table that holds the history data for a Project Change status? On the front end the popup appears on our Manage Financial…
-
Need ERP R12 tables in FusionSummary Just want to know the ERP r12 tables in fusionContent Hi, Can any one help below listed ERP R12 tables in Oracle Fusion. jai_om_wsh_lines_all jai_om_wsh_line_tax…