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 working days be used instead of calendar days in a standard infolet?Summary: Calculate aging period using only working days instead of calendar days. Content: The aging requisition lines infolet in Purchase Orders area of Procurement mod… -
How to disable the Open option on Reports & Analytics Catalog?Summary: How to disable the Open option on Reports & Analytics Catalog? Among the various reports offered out-of-the-box by the Oracle Fusion modules, some of them can b… -
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …
-
Income Statement and Balance Sheet reportsSummary Are there a Balance Sheet and/or Income Statement reports available in ERP Cloud?Content I'm surprised there isn't an out of the box version for an Income Statem…
-
Report to monitor payables invoice rejections due to invalid approval rulesSummary: Any seeded report to monitor payables invoice rejections rejected due to invalid approval rules. These kind of rejections can be viewed only in Transaction cons…
-
Invoices Paid on timeSummary: Hi Business is trying to generate the invoices paid on time report in Fusion Cloud Not able to trace the seeded / standard report for the same. Can you please g…
-
How to count the number of pages per supplier in a report using RTF.Content (please ensure you mask any confidential information): I am creating reports using BIP (BI Publisher), and I use RTF templates for the layout. The report outputs…
-
OTBI results in errors saying "The specified criteria didn't result in any data."Summary: OTBI results in errors below Error Message : The specified criteria didn't result in any data. This is often caused by applying filters and/or selection steps t…
-
How to create custom popupSummary: Hi All, Is it possible to create a custom popup that triggers based on specific conditions? For example, on the AR invoice and credit memo pages, we have DFF (D…
-
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '…
-
bi publisher with xml parameterSummary: Hello community, I have the following requirement: From OIC, I need to send data to a BI publisher so that it can return a PDF file containing the data I send. … -
Hide column/s of an FRS ReportSummary: When FRS Report parameters are entered and report is run, I need column/s which give all blank values to be hidden. How can this be done? Content (please ensure…
-
Any Roadmap for Oracle Cloud Financial Redwood?Summary: Hi All, Is there any road map for redwood implementation for Oracle Cloud Financial, what all new features will be added and what will be time line. If any one …
-
BIP report Pivot filter not functioning as expectedSummary: Running an online layout for a pivot date from a data model doesn't properly filter null dates Content (please ensure you mask any confidential information): Fo…
-
bip report to get the approval history and status and also future approversSummary: Hi Experts bip report to get the approval history and status and also future approvers if the task is in progress. Any sample report sql query can you please sh…
-
Query to fetch Transaction console entries along with multiple Approver detailsSummary: Need a Query to fetch Transaction console entries along with multiple Approver details Content (please ensure you mask any confidential information): Version (i…
-
How to migrate extended lookup code in bulk from one instance to anotherSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Security for OTBI Subject Area "Projects - Labor Distribution Costs Analysis Real Time"Summary: We need to expose OTBI queries written against the subject area "Projects - Labor Distribution Costs Analysis Real Time" to a larger population. Right now, it i…
-
Auto Refresh InfotilesSummary: Client would like an invoice “dashboard” experience in Oracle Fusion Cloud that updates in near real time (or auto-refreshes on a set interval) without users ma…
-
Auto Refresh InfotilesSummary: Client would like an invoice “dashboard” experience in Oracle Fusion Cloud that updates in near real time (or auto-refreshes on a set interval) without users ma…
-
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…
-
ERP Cloud implementation using Agile methodologySummary ERP Cloud implementation using Agile methodologyContent Good Morning everyone, Has anyone done ERP Cloud implementation using Agile methodology ? Any feedback/le…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…
-
How to get relevant FA cost balances between accounts after a category change?Summary: For the below asset, there has been a category change. This resulted in 2 different cost accounts, old and new. Is there a way to get the Cost balances for it a…
-
How to get Branding Image URL for Course created in Oracle Fusion HCMHello Everyone, We are developing a custom report to list courses, and one of the requirements is to display or extract the URL of the uploaded branding image for each c…
-
How to burst and deliver a single CSV file to SFTP when no column has a common value for all recordsHi team, I am working on an Oracle HCM Cloud BI Publisher report where the requirement is to: Generate one CSV file Containing all records Deliver the file to SFTP locat…
-
Query for Transaction Console transactionsSummary: Query for Transaction Console transactions Content (required): I am looking to write a query that contains the below information from the Transaction Console, r…
-
Navigation : My Enterprise -> EnterpriseSummary My Enterprise -> EnterpriseContent Hi, I am trying to navigate to t My Enterprise -> Enterprise menu from the home page. Even if i have all the relevant applicat…
-
Need help with Cost Accounting Distributions CodeSummary: Hy Experts. I am developing a Purchase Register Report where I have to fetch a column named Inventory Charge Account in which this value of Inventory Valuation …
-
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…