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
-
Is it possible to trigger existing report in Oracle button page using Sandbox?We would like to trigger a report and run it as Scheduled Process when clicking existing Oracle Fusion button (Manage Invoice Preview button to be specific). Is it possi… -
Fusion BI Report Time zone issues in report output related queriesOur users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries b… -
User Role Memberships Report - possible location in OTBI?Apart from the scheduled process, the report can be seen. Is it also possible to locate this in OTBI?
-
Moved: Cost Accounting subject areaThis discussion has been moved.
-
Moved: How to create AOR based transaction console BI report in oracle fusion hcmThis discussion has been moved. -
Moved: Dashboard access and rolesThis discussion has been moved. -
Inactive User Report - Is it possible to see this in OTBI?Inactive User Report - Apart from the scheduled process, the report can be seen. Is it also possible to see this in OTBI? If yes, where is the path name?
-
OTBI Performance - Project Cross Subject Area - Date Filters Affecting Performance very badSummary: Using Projects - Cross Subject Area Analysis - Real Time there are severe performance issues filtering by accounting date less than or equal to. There is same … -
How to schedule FRS reports in Fusion FinancialsSummary: I need to run an FRS report in Fusion Financials using scheduling. In EPM the process would be to create a batch and then add the batch to the schedule. In Fusi…
-
General Ledger Detail Dashboard is showing 0(Zero) AmountsSummary: We have developed a Dashboard named CHRS General Ledger Detail Dashboard. In which we were using "General Ledger - Journals Real Time" and "Subledger Accounting…
-
Deliver BIP report to sharepointSummary: Ability to deliver BIP report to sharepoint seems possible, but documentation is from 2007 and doesn't seem to line up with current sharepoint screens. Content … -
Redwood Plan for Oracle Cloud ERPSummary: I haven't found clear discussion on how the Redwood would affect Oracle Cloud ERP. I see documentations and notices for EPM, HCM, and SCM, but I'm unclear on wh…
-
Error when invoking ESSWebService submitRequest method from SoapUiHi, I'm trying to submit a request to run the job "ItalianSalesVatRegister" and I receive the following error: oracle.as.scheduler.RuntimeServiceAccessControlException: …
-
how to add attachment column in bank account creation of register supplier page in fusionSummary: how to add attachment column in bank account creation of register supplier page in fusion Content (please ensure you mask any confidential information): Hi All,…
-
Moved: Analysis to retrieve total element amount per month and yearly trendThis discussion has been moved.
-
How can I join General ledger and ExpensesHow can I join General ledger and Expenses I am precisely looking to join below tables gl_je_lines gl_ledgers exm_expense_types Much appreciate your help on this
-
Moved: Pivot using Mulitiple groupsThis discussion has been moved.
-
-
How to default the Parameters in Job set while schedulingwe have created a jobset and if we want schedule that we need to pass parameters. But unable to default the parameters and not able to schedule it.
-
Moved: Supplier Recon reportThis discussion has been moved.
-
Need the table name that stores job history of BIP reports submitted through BI publisher dashboardSummary: Need the table name that stores job history of BIP reports submitted through BI publisher dashboard but not the Scheduled processes page. (I know the ESS_REQUES… -
Define a global function in BI reportsDear All, Is there a way to define a global function in BI reports to use it across all reports? For instance, NLS_NUMERIC_CHARACTERS?
-
using trigger for BIP reportSummary: I am trying to use a trigger for a BIP report and schedule. Content (please ensure you mask any confidential information): I only want to deliver the report whe…
-
Moved: TOOLS > audit reports - ORACLE PLATFORM SS > ADD/REMOVE ROLE MEMBERSHIPThis discussion has been moved.
-
Performance impact while using standard viewsSummary: Is there any performance impact while using the standard views (in a BIP report) listed by Oracle. For eg. using standard view PJF_PROJECTS_ALL_VL, instead of t…
-
BIP report output with 0 KB.Summary: We have a custom BIP report with a datamodel. The data could be seen when viewed in the data tab of the DM. When the report was ran in the BIP (using the schedu…
-
Moved: Reporting on Approval Transactions outside HCMThis discussion has been moved.
-
Can you use temporary tables in cloud fusion otbi?Summary: Can we use temporary tables in cloud OTBI as a replacement for multiple union select statements Content (please ensure you mask any confidential information): W…
-
Inquiry- Extracting data from Essbase cube and database tables.Summary: Inquire data from essbase cube balances based on mappings stored in database table. Content (please ensure you mask any confidential information): We have a req…
-
Moved: Connect Oracle HCM to AlteryxThis discussion has been moved.