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
-
Essbase Cube, Report distribution, Oracle Fusion SaaS environmentWe are currently in Patch 24A getting ready to go to Patch 24B. We have Smart View and have build FRS WEB reports that users can run out of Financial Reporting Center. W… -
How to schedule a custom weekly GL report, which includes date parameter of "PostedDate-7"Summary: Custom GL Report which needs to run at 12:05 AM weekly on Tues night and include data only from the previous week. If PostedDate = Aug 6, the report should incl…
-
Recommended approach for data warehouse extract from Fusion FinancialsSummary: We have implemented Oracle Cloud/Fusion Payables and Procurement modules. We have built custom data models and reports to extract data from Fusion and deliver t… -
Best approach to create a report templateHi everyone, I’m seeking advice on the best approach to create a report template with the following requirements (Bi Pulisher report): Year-to-Date (YTD) totals Subtotal…
-
Is Property Manager Available in Cloud?Summary Is Property Manager Available in Cloud?Content Is Property Manager, specifically the Equipment Lease functionality, available in Cloud? If no, is it on the roadm… -
minimum bandwidth requirement for fusion application to runSummary what is the minimum internet speed / bandwidth requirement for fusion application to run.Content Few of our customers are facing performance issues while using t… -
ERP Sofware Version and NameSummary: I need to include the ERP application name and version in a custom report. Does anyone know if this information can be queried? Specifically, I'm looking for th…
-
Why does tax_amt_funcl_curr field table zx_lines not match the amount FIELD in INVOICESSummary: Shouldn't tax_amt_funcl_curr field from table zx_lines match the amount in invoice- View accounting match. we are noticing few cents off for philippines tax_amt…
-
How to retrieve Custom Child Object and Custom Field in BI PublisherSummary: Hi, Would like to check how do I retrieve Custom Child Object and Custom Fields in BI Publisher? For example, under the SCM»Innovation Management»Proposal - I h… -
Does the purpose of Cloud Collections related columns in AR Payment Schedule align with EBS R12Summary: We have a custom report running in EBS R12 that we are looking to port to erpCloud. The R12 report references columns: AR_PAYMENT_SCHEDULES_ALL.STAGED_DUNNING_L…
-
Unable to access OTBI dashboard for Procurement - PurchasingSummary: An user can not access to a dashboard for Procurement - Purchasing on OTBI, the user has assigned the purchase analysis role Other user with te same role can ac…
-
Missing Republish Button @ ESS Jobs to open outputSummary Missing Republish Button @ ESS Jobs to open outputContent * Should be able to view the output of Jobs run from SOA user as jobs are scheduled from SOA User.For a… -
Incrimental logic for fetching the data in Custom report is not working as expectedSummary: Hi Team, We have a custom BI report which fetches Customer Invoices related columns. The ESS job for this report is scheduled to run every 15 minutes. The repor…
-
Reporting subledger modules to GL with transaction detailSummary: We're looking for a report that provides information from subledgers into the GL in an Excel like format. For example, we need the project number, expenditure t…
-
Is there a Workforce Management - Position Event Real Time Subject Area?Summary: There is currently a Subject Area for Workforce Management - Position Real Time selectable when creating an Analysis in OTBI. This Subject Area shows the max ef… -
Why do some scheduled processes have an External Job Status of WAITINGSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Offerings for Turkey Localization available as part of standard Oracle Fusion ERP subscriptionHi Team, Please provide us the documentation or the list of offerings for Turkey Localization available as part of standard Oracle Fusion ERP subscription. This is requi…
-
Steps to customize standard BI Report and Add ParametersContent Hello All, We have a requirement to customize standard BI Report to add parameters and modify the data model. Do we have any oracle document about this process ?…
-
Iam trying to customize the existing standard Supplier Balance Aging ReportIam trying to customize the existing standard Supplier Balance Aging Report where i want to same and export sample data by inputting parameters against the same data mod…
-
Payroll flow created for BI report is running into error "Dummy file is deleted"Executed the above remedy but getting the same error.
-
Connection to SFTP is failing from BI ServerSummary: Hi Team, The BI Server connection to SFTP is failing with error "Could not establish connection. java.net.ConnectException: Connection timed out (Connection tim…
-
Account Profile Conversion Rate Type field is showing Id instead of Name in OTBI AR reportSummary: Account Profile Conversion Rate Type field is showing Id instead of Name in OTBI AR report, it is showing name only for the seeded value i.e Corporate. P.N - We… -
audit report for approval group changesSummary: The audit log generated by Tools>Audit Reports is not rendering information based on the changes we make in the system, despite previously enabling logging on n… -
How to join fnd_bpm_task_comment to fnd_bpm_task_history_b table?Summary: I am trying to get data from fnd_bpm_task_comment table and joining with fnd_bpm_task_history_b table with Task_id but i am dropping the data which doesn't have…
-
printer setupSummary: Questions regarding printer setup Content (required): Hi team, Kindly clarify below points. *BI Publisher >Administration>Manage Publisher>Delivery>Printer>Add …
-
bicc povSummary: We are trying to extract data using BICC. We need to know whether : 1) BICC POV s can be joined together to get the desired data 2) We can create our own POVs W…
-
Unable to copy shortcut to MyFolders due to Path not found - Check the input path entered errorSummary: Hi, Got this error when trying to copy/paste shortcut of a folder to MyFolders : I have full ownership of the folder that i'm trying to copy the shortcut : Plea…
-
ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabledSummary: Hi Team, I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the whe…
-
Table for BPM - specifically CONFIGURATIONSContent We are looking for tables to be able to look at the workflow rule configuration. For example, we want to be able to create a report that will tell us things like… -
How to create Account Range parameter?Summary: Standard ESS job - Supplier Balance Aging Report, has a parameter 'Account Range'. How to define the parameter for a custom ESS job? Content (required): Standar…