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
-
Can BI Publisher Data Models query the table SYS.DBA_COL_COMMENTS in Oracle Fusion Cloud?Can BI Publisher Data Models query the table SYS.DBA_COL_COMMENTS in Oracle Fusion Cloud? I need to query this table to see the purpose of various fields in various tabl… -
Unarchiving Custom folder after refresh fails without any error messageWe have been backing up the Custom folders (under shared folders) before the refresh on all non-prod pods. After the refresh is complete, we import back the custom folde… -
How to get Risk Code value in BIP Custom ReportSummary: We are developing a customer report and we need a column called Risk Score. The value we may need is similar to this 'Any value between 1 – 69 is high risk and …
-
Does an expense listing report exist?Users are wanting to run an expense listing report - does anything exist similar to what existed in EBS r12? Or alternatively is there a form where this can be extracted…
-
Data Model Default parameter to current periodOn a Data Model for a report I have a parameter for the period that I would like to default to the current period. The parameter is a Data Type of Date and a Parameter T…
-
How to output the BIP report in PDF formatting through APISummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is there a way to limit what tables a user can query in OTBI?We have a support team that's requesting access to write Data Model queries in OTBI. Our concern is restricting them to only the financial tables. Does anyone know if th… -
Moved: BICC Union all - documentationThis discussion has been moved. -
How to create ESS job to invoke multiple BIP Reports in oracle fusionHi All, We have a requirement to burst multiple-report output through the ESS job and this job will be invoked from OIC. Can you please help how we can achieve it. Thank…
-
How to check all the schedules defined in BICC -- by anyoneSummary: How to check all the schedules defined in BICC -- by anyone How to check which all jobs are currently running in BICC How to check which all jobs errored out in…
-
Moved: query has column present but not present in RTF after importing sample xmlThis discussion has been moved.
-
Moved: Quality Dashboard for HCMThis discussion has been moved. -
How to connect to GL Cubes as data source for MDX queriesSummary: Hello, I am trying to run a MDX query in Fusion ERP. But there are no data sources available. How can I create a data source to connect to the GL Cubes within E…
-
Performance issue with Custom ReportSummary: Dear All, We are facing performance issue with one of the report. This report provides the information about the Project Budgets along with Expenditures details…
-
African Countries - Statutory Reporting Requirement as per OHADADoes Oracle Fusion Cloud support the reporting requirement in African countries as per OHADA? OHADA stands for The Organization for the Harmonization of Business Law in …
-
How to run US 1099 Electronic Media Report for a specific vendorHi All, We need to submit an electronic file for one vendor we missed. Is there an option to run the US 1099 Electronic Media Report for a specific vendor. There seems t…
-
24A ERP OTBI subject areas to database tables mapping spreadsheetsSummary: 24A ERP OTBI subject areas to database tables mapping spreadsheets Content (please ensure you mask any confidential information): Where can I find 24A SCM and P…
-
How to get size of file running in ESS jobSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Custom Job Set not showing for one userSummary: We have created job sets in a lower environment and the users that need to access it are able to with the exception of our Director of Projects. She is still no…
-
Fin and SCM list views oracle BIPHI Team We need the Secure list views in Oracle ERP SCM and FIN modules as we need to use them in developing the custom BIP's. Regards Praveen
-
Read only access to data modelSummary: We want to provide read only access to data model for some key BIP reports, to our Internal audit team as they want to review the code behind key sox reports. W…
-
Print Receivable Transactions Report Custom templateSummary: Print Receivable Transactions Report Custom template Content (please ensure you mask any confidential information): Hi All, We customized the Print Receivable T…
-
Smartview Essbase Error [1020098]: Duplicate name found in Grid, unable to resolve.Summary: I get the following Smartview error in report that used to work fine, adjusting the Account dimension values fails to resolve the issue, Essbase Error [1020098]… -
Recommendations to generate a delimited output over 5GB in FusionAre there any recommendations to generate a delimited output over 5GB without timeout and going into error using a report in Oracle fusion. Currently we are generating e… -
Unable to access attachments uploaded in workflow notification via hyperlinkAttachements uploaded in "Account Coding Workflow Notification" are getting saved as a content in BLOB column of a table rather than storing it as file in UCM. Hence it …
-
-
How to create a BIP Report in excel with a drill down option?Summary: I would like to create a BIP Report of the list of the BPAs. Click on BPA I would extract the list of the POs linked, click on PO I would extract the lines and …
-
Link between Bank Statement line and Transactions for Group of Manual Reconciliation.We are working on the BI report to Pull AP and External Transactions. I need to join the CE_STATEMENT_LINES and CE_RECON_HISTORY_ITEMS to AP_CHECKS_ALL. When I tried to … -
How to fetch amount delivered on PO through SQL QueryWe have a custom Purchase History BI report that gives entire PO history. This report also has columns named quantity_delivered and amount_delivered which are being fetc…
-
Currency Conversion in OTBI report from Procurement - Procure to Pay Real time subject areaSummary: We have a custom OTBI report created from Procurement - Procure to Pay Real time subject area. The report currently shows all open POs in different currencies. …