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
-
Vacation and Delegation Rules reportSummary: Hi All, We have a requirement to create the below report for Vacation and Delegation rules in the application. Say when Line Manager is going on Holiday and he … -
PRC: SQL to get the Cost Center Owner approver's email address on RequisitionsSummary: We are currently investigating the process of being able to extract the Cost Center Approver email address. The cost center owner approval is setup in the secon…
-
which table Notification attachments are storedSummary: While approving the any approval notification the user can add attachment in the notification. where this attachment are stored. Content (required): Notificatio…
-
Need to push output files of the job Import Project Budgets through SFTP.Summary: Content (required): The issue can be reproduced with the following steps: Step1: We are scheduling the Import Project Budgets job. This is a seeded processes. S…
-
HWM_TM_STATUSES - Many entries for a given timecard entry (Human Workforce Management / Timecards)We would like to know how the HWM_TM_STATUSES table works in regards to timecard entry changes (when a timecard is submitted, approved, then modfied). In our observed be…
-
Bursting Enabled or DisabledHi Team, We wanted to check if we have a table or sql query to check how many reports have bursting enabled so a report or list can be prepared for the same. Please let … -
OTBI-Report-Supplier Portal - Invoice Real Time-Roles RequieredSummary: OTBI-Report-Supplier Portal - Invoice Real Time-Roles Requiered Content (required): Hello The following document state the role required to run the Supplier Por…
-
Standard ESS Job list of values modificationHi Team, We have requirement to edit the standard ESS job create accounting to remove one of the list of values from Subledger application. Please let us know if it is f…
-
Functional / logical ER diagrams for Fusion Apps?Summary: Where can I find functional or logical ER diagrams for Fusion Apps / Cloud ERP? Content (required): I am looking for something like https://architect.salesforce… -
BI - Seeded and Custom Folders Mirroring Each Other?!Summary: We are experiencing several custom template issues and have noticed that our Custom and Seeded Folders are mirroring each other without human intervention. Cont… -
Create a report that shows invoice data on day it was loaded?Summary: Hi everyone. I am curious if there is a way to create a report that allows me to collect data from an invoice on the day it was created. Such as Problem Type. I… -
PO Spend Analysis in one currency (USD or Ledger Currency)Summary: PO Spend Analysis in one currency (USD or Ledger Currency) Content (required): We are using Oracle provided Analysis: PO Spend by Top Category We found that the…
-
Dec-XX Balance for Qtr4-XX balance in FRS StudioSummary Dec-XX Balance for Qtr4-XX balance in FRS StudioContent Hi We need to populate QTD balances. The accounting calendar has 2 Adj periods. Adj 0 - XX before Jan-20X…Swapnil Mangnalikar 28 views 3 comments 0 points Most recent by Cezar - Fusion Oracle Support-Oracle
-
ERP Cloud list of payables invoice approversSummary: You can go into BPM and see, for a given invoice, the full list of approvers showing who submitted the invoice for approval, who the invoice is currently with f…
-
BICC - I'm looking for the link to the list of potential deprecated PVO's or objects for Release 22ASummary: BICC - I'm looking for the link to the list of potential deprecated PVO's or objects for Release 22A Content (required): BICC - I'm looking for the link to the …
-
SOX and Smart ViewSummary SOX is asking how they can know Smart View data is accurate and completeContent Hello, Our SOX team is asking how they can know that Smart View data is accurate,… -
What tables hold the project costs expenditure batch workflow details for creator and approverSummary:Does anyone know if this information can be reported on using BI Publisher or OTBI to view the approval workflow for project cost expenditure batches? This infor… -
Restrict OTBI report data(using subject area) to logged in userSummary How to restrict OTBI report data(using subject area) to logged in user. Currently it shows all data. Data access given at Business Unit level for the role.Conten… -
What is Difference Between Secured and Unsecured Assignment Manager Folders in Workforce ManagementSummary: What is Difference Between Secured and Unsecured Assignment Manager Folders in Workforce Management - Worker Assignment Real Time Content (required): What is Di…
-
21D BIVO list for ERP (Financials, Procurement, Projects and HCM)Summary: I am looking for latest 21D Deprectaed BICCC list for ERP (Financials, Procurement, Projects and HCM). Any link where I can download the latest listing. Appreci…
-
Unable to edit scheduled processSummary Unable to edit scheduled processContent Hi, I have a couple of processes scheduled to run daily from February 2020 until February 2021. Since the schedule was se…
-
Reset Fusion instanceSummary: Is it possible to Reset Fusion ERP Cloud instance to the initial state Content (required): Customer will buy production instance and gets development environmen…
-
Invoices Report acccessSummary: creating have created a report using Payables Invoices - Transactions Real Time and Payables Invoices - Installments Real Time Content (required): creating have…
-
OTBI report - export to Excel limitationSummary: We have OTBI reports that will exceed the 50,000 field limitation for exporting to Excel. Content (required): Can you "schedule" an OTBI report to get around th…
-
OBIEE / OTBI Pivot Table Calculated % VarianceSummary: Need the equivalent of ABS in pivot table calculated column Content (required): In a pivot table presentation; - I have a calculated column; Variance which is e…User_2025-02-10-15-12-48-631 72 views 2 comments 0 points Most recent by User_2025-02-10-15-12-48-631
-
BIP Excel output always adds additional comma to end of values when saving as csvSummary: Content (required): In BI Publisher, I need to export a simple table report to XLS (not csv) to be used as a template. However, once completed and then saved as…
-
How to cancel "Provide Online Transaction Engine Functionality" runnning jobs ?Summary: cf. Doc Id 1565921.1, I want to cancel these jobs, but a new job is running each time I cancel the previous one. Content (required): I want to cancel these jobs…
-
Custom Address StyleSummary: Our client has a requirement to build a custom address style in Cloud to replace the standard Oracle address style/formats. Is there a risk if this custom addre…
-
Fusion Process Maps (Visio)Summary: im finding the Fusion Process maps and the references or lack of them being clearly defined a little difficult to follow, previously being used to a clear struc…
-
Is it possible to have default prompt value specific for each user in an OTBI dashboardSummary: We have an OTBI dashboard for which each user is searching a specific account combinasion. Instead of always typing the account in the prompt of the dashboard, …