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
-
Control report-level permissions during migrationSummary: We have a custom folder ("Folder A") with 4 roles assigned: Role A, Role B, Role C, and Role D. When a new report is migrated into this folder, it automatically… -
Alternative to Rank for Participant Details - ICSummary: Currently when creating a report that includes Participant Detail results, we need to use a Rank Participant Details Start Date by Participant ID. If we don't u…
-
Is the 75000 row limit for OTBI reports just a limit on the output?For an OTBI report, the SQL automatically adds "FETCH FIRST 75001 ROWS ONLY." Is this only referring to the output of the report? Or is it also referring to the total po…
-
Report listing active users with current and past assigned roles (with start and end date)Summary: Report listing active users with current and past assigned roles (with start and end date). Content (please ensure you mask any confidential information): Clien…
-
Purge User RequestsSummary: Purge User Requests Content (please ensure you mask any confidential information): There is a way to purge a specific request? I'd like to purge some requests f…
-
Schedule ess job- Create Customer StatementsSummary: Hi, We have a requirement to schedule "Create Customer Statements" to run once every 3 months. How do we schedule this and pass parameters to ess job on each ru…
-
Narrative ReportingSummary: In Narrative reporting, is it possible to display numerical numbers in other language numbers e.g Arabic numbers etc in reports. Content (please ensure you mask…
-
Get Service Usage Metrics Drill Through report on demandSummary: Get Service Usage Metrics Drill Through report on demand Content (please ensure you mask any confidential information): Hi We need have the information about me… -
PO PDF Template Conditional Regions by Purchasing CategorySummary: We are trying to update the PO PDF template so that if 3 specific purchasing categories are used on the Purchase Order it renders some different text on the tem…
-
Do we have any seeded audit report for setup changes required for SOX 7.2Summary: Audit report for setup changes Content (please ensure you mask any confidential information): This is in reference to SOX 7.2, and I would appreciate your assis…
-
Is it possible to see when a text field has been updated in Reports and analyticsThe usecase is to be able to make a filter on a text field where only items that have updated that specific field for the last 4 weeks are shown in the results.
-
OTBI report looks different when opening from ERPOTBI report looks different when opening from ERP than when opening it from OTBI. I want it to look like in ERP, but I do not understand why it will not do this. The fie…
-
Project Comments in query output FormattingSummary: User created a comment on Project level (might have been copy pasted from some other source), when a sql is written to extract the information, it has all sorts…
-
deeplink for receiptsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Join between xla_distribution_links and po_distributions_allHi, Can anyone tell me how to join from xla_distribution_links to the purchase order tables (po_distributions_all)? For example, for the receipt accounting accrual. In x…
-
supplier bank accounts fusion querySummary: I am trying to retrive the supplier bank accounts loaded in fusion at supplier header level. I have loaded bank accounts with only BANK_ACCOUNT_NUM. I did not i…
-
Changing Fonts in PDF Forms within FinancialReportsWe are creating forms in FinancialReports and outputting them as PDFs. We wish to change the font used in these forms. We have confirmed that fonts can be changed on a c…
-
Can we customise notifications to users only if there is any data generated after an ESS job runs.Summary: We have a requirement for which we want the notifications/Emails to be sent to users after an ESS job runs every week and if it does not have any data we don't …
-
Bi Cloud Extract is returning different amount of lines with same parametersSummary: BICC Extract Difference in amount of lines using same parameters Content (please ensure you mask any confidential information): I'm using BI Cloud Connector, da…
-
Hi All, Can you help me with SQL Query for BIP Report Status and report name?Hi All, Do we have any SQL query for BIP Report Status ,report name and report history and the status of the Report?
-
We need an SQL query to retrieve all scheduled ESS jobs from the backend in Oracle Cloud Fusion.We need to extract and get the list of all scheduled jobs and programs from the backend in Oracle Cloud Fusion. The extract should include the following details: Job Nam…
-
Help finding the audit product id for middleware applicationsIn order to call the API endpoint /fscmRestApi/fndAuditRESTService/audittrail/getaudithistory you have to pass "product". The products for regular fusion modules are eas…
-
Incorrect Invoice Amount when using OTBI "Payables Invoices - Transactions Real Time"Summary: Incorrect Invoice Amount when using OTBI "Payables Invoices - Transactions Real Time" Content (please ensure you mask any confidential information): Hi - has an…
-
Transaction Number in Account Analysis reportSummary: Can you please help to determine where we get this transaction number for payroll in Account Analysis report? Content (please ensure you mask any confidential i…
-
Schedule job list wanted by name of schedule time interval by schedule process by status waitSummary: I need the Report that can show me all schedule process running on interval and because we have many schedule process running. We have no track of those schedul…
-
Financial Tax Register is not picking receivable invoices created using REST APISummary: Financial Tax Register is not picking receivable invoices created using REST API Content (please ensure you mask any confidential information): Tring to create … -
Custom job set not requiring custom privilegeSummary: user guide is very clear on this topic: https://docs.oracle.com/en/cloud/saas/financials/24b/fafcf/create-job-sets.html but reality is different. Created a cust…
-
Scheduling OTBI report to store report output daily in sharepoint locationSummary: Scheduling OTBI report to store report output daily in sharepoint location where user can access directly instead of downloading it seperately from report Conte…
-
Sending remittance advice email limitSummary: we are a government department and are now paying a large volume of grant payments. this means an increase to the number of payments and therefore remittance ad…
-
sql query to fetch serial number per every transactionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…