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
-
Create custom notification with Agents in OTBISummary: We are looking to create custom notifications utilizing Agents in OTBI. We have specific use cases where we need users to receive notifications (i.e. project co… -
Issue with RTF Template – Pivot Table MergingSummary: we are using a Pivot Table to display invoice data for suppliers across different legal entities over a six-month period (from the given reference period). Issu…
-
What is "ORA_FUN_DATA_MAINT_KEY" about and How it worksSummary: is there anyone who knows what is "ORA_FUN_DATA_MAINT_KEY" look-up about and how it works? I've found that that this "ORA_FUN_DATA_MAINT_KEY" look-up code has b…
-
How to apply segment value security to Procurement OTBI subject areasSummary: How do we restrict access to requisition OTBI subject areas based on the segment value security rules? Content (please ensure you mask any confidential informat…
-
Are there any roles to provide read-only access to a data model in oracle fusion?Summary: Hi, I want to provide read-only access to one data model to one of our users. Is there any roles or configurations that will help in providing read-only access …
-
Redwood Impact for Oracle Cloud FinancialsWe have been working on the HCM side for the Redwood updates and wanted to confirm the impact that Redwood will have on the Oracle Cloud Finance side. Please let us know…
-
modules within Oracle ERP or alternateSummary: Content (please ensure you mask any confidential information): Hi Hope im putting this in the correct platform. We have a client in the airline catering industr…
-
Are there available audit reports to track master data changes?Summary: Client wants a report to track master data changes - customer, supplier, system configurations. Are there available seeded reports to cater to this requirement?… -
Cash Flow Statement Generation - FRS or Other Reporting ToolsSummary: Cash Flow Statement Generation - FRS or Other Reporting Tools Content (please ensure you mask any confidential information): Hi Experts, Please advise as to whe…
-
How to get FCCS data to BIP?We have a requirement to get data from FCCS, to create a BIP report. Is there a way to add FCCS as a data source in BI?
-
How to get the last period of previous fiscal year in FRSThere is a requirement in balance sheet report where we need to get the details for Previous Year Ending(PYE) balances in one of the column in FRS report. For Ex: Curren…
-
difference balances xla_ae_lines and xla_ac_balancesSummary: We created an OTBI report in the "Subledger Accounting - Supporting Reference Real Time" subject area, and it doesn't contain a value for a supporting reference…
-
How to calculate EOD balance for the last day of Previous month based on accounting date in OTBII'm trying to calculate the End of the day balance for the last day of previous month based on accounting date which I'm passing as a parameter in the OTBI Analysis. Sub…
-
Users with experience of using SQLConnect by BI SplashSummary: Users with experience of using SQLConnect by BI Splash Content (please ensure you mask any confidential information): We are reviewing the feasibility of granti…
-
How can we identify the list of BIP/scheduled reports that are currently being transmitted to FTPSummary: We need a list of reports from Fusion that are currently being transmitted to the FTP server as part of the requirement to transition to a more secure SFTP serv…
-
Customization of Standard Contract Preview ReportSummary: Hi Team, I am writing to request guidance on a customization for the Standard Contract Preview Report(Enterprise Contracts --> Contract Printing --> Contract Pr…
-
Do we have any option to download CSV File - rather than getting displayed in browser output ?Hi team, Do we have any option to download CSV File - rather than getting displayed in browser output ? Our data output file size is more than 100 MB , we want to downlo…
-
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… -
How do i know which field in the fusion frontend is related to which table column in backend?Hi Experts I am new to BIP report development. Customer sometimes just give screenshot from fusion and ask to create report with those field . Is there any way where i c…
-
Submit button is disabled for Trial Balance Report ESS JobSummary: When user is running the Trial Balance Report ESS Job, Submit button is disabled.
-
How to link GL journals to external cash transactionHi Team, I would like to create a custom BIP report to link GL journals to external cash transaction. How can I trace back from GL journal to external cash transaction? …
-
Excel template - with CSV Output -- Do we have an option to hide parameters ?Hi team, Excel template - with CSV Output -- Do we have an option to hide parameters ? -Sridhar
-
Excel template- Why the column header is not copied into other sheet- for rec# > 65KHi team, When the output has more than 65K records - Excel output is getting generated with multiple sheets, but only the first sheet has column name, remaining sheets d…
-
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… -
How to create data control name while registering ESS jobHi, We have requirement to modify default parameters of the seeded ESS Job. Parameters controls by the "Data Control Name" . Is there any feasibility to create a new "da…
-
How to hide "set ownership of this item" from properties option in Report and Analytics ?We have a requirement where business is asking to hide "set ownership of this item" for users with specific roles. we tried to hide from "Manage Privileges" but some how…
-
Request for audit report for the changes done on BPM Worklist - FinGlJournalApprovalSummary: I am looking for a audit report for the changes done on BPM Worklist FinGlJournalApproval. We noticed some of the rules has been disabled by some user and we ne…
-
In OTBI the table view window presented is too small. How to resizeSummary In OTBI the table view window presented is too small. How to resizeContent In OTBI the table view window presented is too small. How do I resize this preview win… -
BIP Report - Security - Role/Privilege required to access data in XLA tablesSummary BIP Report - Security - Role/Privilege required to access data in XLA tablesContent Hello, We developed a custom BI publisher report having XLA tables in the Dat… -
How to filter analysis date within current dateHi Experts, We're currently using "Receiving - Transaction Real Time" to create an analysis. and we want to filter on transaction date field that only display date on cu…