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
-
OTBI Report parameters and export optionsSummary:. 1.Check to have the parameters section display always after report is run instead of having to go to catalog and come back again to rerun the report. Update OT… -
How to find the start and end date for an expired ESS process?Summary: Is there a way to view the start and end date of a parent schedule after it ended or expired in Enterprise Scheduled Process? Content (required): Version (inclu… -
How to identify the count of ESS Jobs which can be run parallely in an instance?Hi All, We want to identify the count of ESS Jobs which can be run parallely in an instance? As we are planning run 150+ reports in a instance, we want to know if they a…
-
Alerts in Oracle Fusion CloudSummary: Do we have anything similar to Oracle Alert in Oracle Fusion cloud ?
-
Need the Backend Table Details for Oracle SubscriptionSummary: I want to build a report to get what module/functions are used for my organization/company. Content (required): need the query if any one have handy. Attached i…
-
How can i connect to Essbase in PowerBISummary: We used oracle fusion cloud and able to connect to Essbase using Smartview in Microsoft Excel but when i try to connect to PowerBI using url it gives me error. …
-
BIP output calling an external webserviceSummary: BIP output calling an external webservice Content (required): We have a report that we'd like to export the data to a third party, but to improve integration, w…
-
Privileges required to view output on a custom version of a seeded reportSummary: Privileges required to view the output of the Import Project Budget report when a custom copy of the seeded report has been created (relevant to any seeded repo… -
Is there any query to get the outstanding invoices for the specified monthSummary: Query to get the outstanding invoices for the specified month Content (required): We need to send a csv report to a customer which contains the outstanding invo…
-
Understanding the 'Disallow Previous Password' in Oracle fusion ERP password policy setupSummary: We are enabling the password policy in our system and needed to understand below regarding the field 'Disallow Previous Password' in password policy setup: How …
-
BICC costs to extract PVO from other serviceHi, As I am not sure on how particularly Oracle handles this area, I am trying to figure out the following scenario: we are trying to extract some data from Fusion using… -
Is there an option to set the priority for a process or a job within a jobset in Oracle Fusion ESS?Summary: Just wondering, if there's any option to set the priority for a process or a job within a jobset in Oracle Fusion ESS. Content (required): I have come across th…
-
Bank Payment File FormatSummary: Bank Payment File Format Content (required): Hi All, We got a requirement from the bank to modify the Payment file format . Currently the format is, R|DEBIT_ACC…
-
Moved: Drill Down OTBI is not working correctly using Custom Column.This discussion has been moved. -
Legal report for Portugal to communicate the inventories once every year - Portugal localizationsSummary: Portuguese companies are required to communicate to the Tax Authority the inventory relating to the last day of the tax period, through a file with defined char…
-
Unable to Deploy to BIP using Oracle SOAP ServicesSummary: Unable to use /analystics-ws SOAP Service to deploy a BIP Report (catalog file). Content (required): We use pasteItem2 operation of https:///analytics-ws/saw.dl…
-
Secure access to Copy/Move and Paste for a report by rolesSummary: Separation of access for users based on report execution and access to copy and move reports Content (required): Our client has a requirement where they want us…
-
Moved: SQL - GL Balances for IntercompanyThis discussion has been moved. -
Error : ORA-01861: literal does not match format stringThis is my query : WITH details AS ( SELECT ppl.person_number, ppl.person_id , pet.base_element_name, pee.effective_start_date start_date, TO_DATE(peev.screen_entry_valu…
-
Need help in DataModelInSession SOAP ServiceSummary: Can someone share working payload of DataModel In Session SOAP Service to call Data model dynamically in Fusion? Content (required): Version (include the versio… -
ERP Scheduled Job behaviour while downtime as part of maintenance/patching activitySummary: Hi Team, Could you please suggest on the behaviour of scheduled custom or seeded ess jobs in erp, during system downtime as part of maintenance/patching activit…
-
BI Publisher report with cashing multi-million records query and staggered upload to FTPSummary BIP Maximum Rows for CSV output limit is 2 million. need elegant solution to query database only once for bigger record count and then have staggered upload of r… -
Approval rule on business creationSummary: Approval rule on business Unit creation not working Content (required): I want to apply approval rule when Business Unit is created/updated, and I used the task…
-
How to create actual vs budget and variance report?Summary: Hi, We have loaded our budget on budgetary control. We are now trying to build a report with budget vs actual amounts and variance between the two. However, ora…
-
How to add new Column in seeded Subject area Receivables - Transactions Real TimeSummary: I need to add column as Ready for XML (select READY_FOR_XML_DELIVERY_FLAG from RA_CUSTOMER_TRX_ALL ) Content (required): Version (include the version you are us…
-
Is there a way to report which report is used how frequently for BI/OTBI/BICC/FRS?Summary: Hi Team, We are looking for providing a metrics on usage of reports and wanted a way to report which report is used how frequently for BI/OTBI/BICC/FRS? Content… -
Administrator license consumptionSummary: Content (required): We have a user "****.ADMIN" who has these 4 admin roles: -Employee -IT security Manager -Application Implementation consultant -Application … -
Dynamic Logo in FRS reportsSummary Dynamic Logo in FRS reportsContent Hi All, Can we have company logo derived dynamically in FRS reports ? Thanks Version 19C -
What data security policies are required for each financial Transaction Analysis Duty?Summary: I am trying to create a custom role that allows the user to run a custom OTBI report but I don't know what data security policies are required for the report. I…
-
Report on Invoice coding approval flowContent Hi, Is there any seeded OTBI report for invoice coding approval flow. If not can you please help with the SQL query to view using BI publisher Thanks