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 & Analytics for Fusion Service
Discussion List
-
Sample Daily Digest for Agents - Unassigned and My Open TicketsSummary Daily digest report ready for subscribable agent to inform agent of open tickets currently assigned to them or unassigned but in their queueContent Our agents wo… -
How do I display the lookup code in a OTBI analysis?Summary How to display a custom fiel lookup code in a OTBI analysis?Content Hi, A client wants a OTBI report with columns that contain the lookup code of some account's … -
Workshop - A Modern Solution for your Oracle Cloud!Summary Derive greater value out of Oracle Cloud with our Next-Gen Managed ServicesContent If your company is like many others, you’ve invested in Oracle applications to… -
Embedding BI report in DCS portalContent Hi, Self service users in DCS are not a users in Fusion as per latest release(20C). and those users will create in IDCS. Currently we are developing the dashboar… -
Error Displayed when trying to open OTBISummary BI Presentation Server using the connection Id =BIPresentationServer. Please ensure that it is running.Content when Clicking browse catalog to open OTBI this err… -
Customization of US 1099 Electronic Media Report - need to add custom parameterWe are working on a customization of the seeded '1099 Electronic Media' BIP Data Model in Oracle Fusion Cloud (Financials - Payables). We copied the seeded data model to…
-
Users can only see their own Expense Reports in Expense Transactions Real Time Subject Area?I am trying to use the Expenses - Expense Transactions Real Time Subject Area in OTBI to create an Expense Report item lookup tool. Users would like to be able to search… -
i am getting error when i used subject area "Dim - Debtor AR" in OAC analytics- we hetting this error when we run the report : Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P Error during query processing (SQLExecDirect…
-
Is there any OTBI subject area that provides the distribution-level Purchase Order Number?Hi Everyone, We are using the Payables Invoices - Transactions Real Time subject area. We noticed that the Invoice Line Purchase Order column is returning the correct PO…
-
"CRM/Help Desk - Inbound Messages Real Time" does not contain HDR reference numberWe need to know which emails were not delivered back to the Helpdesk, as bounce back emails -undeliverable messages are not being received (HDR are not updated automatic…
-
how to create custom roles and what are the common privileges need to add to run and publish reportsHi Team, What are the common privileges and roles required or to created a custom role to open reports in BI Publisher and scheduled new process AP Multiperiod Accountin…
-
How to address Oracle BIP report performance for Oracle finance dataset when data volume is growingWe have simple oracle account analysis report that pulls the data from from GL JE batches , GL JE headers and GL JE Lines. Our financial data is growing at unprecedented…
-
FDI project costing -- inventory item description duplicated with internal reference numberIn Oracle Fusion Data Intelligence (FDI) in the Project Costing subject area, inventory item descriptions are duplicated showing once with the correct description and on…
-
OTBI project costing - unprocessed transactions subject error unprocessed transaction detailsFor the OTBI project costing - unprocessed transactions real time subject area, when attempting to add unprocessed transaction details, such as expenditure batch, the re…
-
Missing DFF Attributes in Seeded HCM PVOs/BICC ExtractsHi Team, We are currently working on a Fusion HCM data extraction and mapping activity using BICC/PVOs across multiple HCM modules. During our analysis, we observed that…
-
We could not able to find or search Schedule Hours(for Time Card Period)Dear Team, We could not able to find or search Schedule Hours(for Time Card Period) in any of the OTL Subject Areas present. Workforce Scheduling - Work Pattern Real Tim…
-
BI Publisher Excel Template Pivot Table Not Refreshing Automatically in OutputHi Everyone, I have developed an Excel-based BI Publisher template (.xls) in Oracle Fusion. The workbook contains two sheets: Detailed GL Transactions: This sheet is pop…
-
FDI custom account analysis receipt accounting missing POETIn FDI custom account analysis, for receipt accounting, the transfer orders are missing the POET. Is there a way to properly populate this information in an analysis?
-
Identify and Retrieve Details of All Skipped ESS Scheduled Jobs.We have a requirement to fetch all ESS scheduled jobs and identify which jobs have been skipped during execution. We would like to understand: Whether anyone has encount…
-
Query/Report to pull employees details whose YTD amount is greater than Total OwedWe would like to know is there any way to pull employees details whose YTD amount is greater than Total Owed for a particular element entry. Kindly suggest.
-
active_flag in per_userwhat does the status of the user who's active_flag is marked as "N" and suspended_flag as 'N'. does the employee is still inactive and can we check who inactivated the u…
-
FDI in Custom Account Analysis for purchase invoices can you identify paid versus unpaid statusIn Fusion Data Intelligence (FDI) in the Custom Account Analysis (CAA) when reporting on accounting purchase invoices is there a way to indicate the invoice payment stat…
-
indirect access to all BUs in FDII'm posting this question regarding a data access issue we've encountered in FDI, specifically relating to the "Manage Service Providers Relationships" setup within the …
-
How we can get the percentage between two contract fields after each 20 lines or after the last lineCurrently we have a requirement to show a total at last of each page for contract lines. Let say we have 30 contract lines, we are printing 20 lines at first page then r…
-
will the goal setting date in UI reflect in OTBI reporting after 26ASummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Which table stores vacation rules on bpm worklistSummary: Which table stores vacation rules on bpm worklist Content (please ensure you mask any confidential information): Hello all, Can you help please to extract the B…
-
HCM Table that stores Candidate Personal DetailsSummary: I need to get the HCM ORC Table that holds this record based on the screenshot below
-
How to report on full Service Request message history?Summary: Hi Everyone, Our Team currently have to manually open each HR Helpdesk Service Request and take screenshots of the message threads when requested which is time …
-
Service Request statuses not appearing in the subject areaSummary: I have created a custom subject area for Service Requests. The Status field only shows the high-level (parent) values and not the detailed (child) statuses. Cou…
-
SQL query to get Inventory Org of a BU in Configure Procurement Business Function UIHi experts, We need to get the Inventory Organization of a Business Unit that shown on "Configure Procurement Business Function" User Interface. We tried using this quer…