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
-
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… -
Categories in Assign rules not shown in OTBI reportSummary: I am using OTBI to extract the list of assignment rules, that are used to assign SRs to the correct queue. I want to have the list of categories that are includ… -
Create Security Assignment on a DFF field in FDIGood morning, We need to configure a custom HR role that grants visibility into HR data only for employees whose PER_ASG_DF field is populated with the value “Yes.” We h… -
Custom HR Role Configuration for Supervisor Hierarchy Visibility in FDIGood morning, We need to configure, in FDI, a custom HR role that provides visibility into HR data for employees belonging to the line manager hierarchy of a specific ma…
-
2 team leaders in the same resource organization should see the same in data in the infoletsSummary: I have a client who has 2 team leaders that manage their HR Support Desk, they oversee all of the resources so should therefore be able to view the same data in…
-
Case Management Reports / DashboardsSummary: Hello All, We would appreciate the community’s support in sharing or pointing us to any existing or delivered case management or HelpDesk reports or dashboards …
-
'Queue' manager should be able to see queue members data in infoletsSummary: Hi, Currently, Infolets allow a resource to view only their own data. At present, there is a single resource organizational hierarchy in the resource directory,… -
Can we give content server document URL access to BIP user without giving content server accessSummary: We are trying to build the report which will give the attachment names So we have created a URL based on content server but now content server cannot be accessi…
-
HR Help Desk Infolets "My HRHD Request Work Time" and "Team HRHD Request Work Time" return no dataSummary: Hi, I have a question about HR Help Desk Infolets. "My HRHD Request Work Time" and "Team HRHD Request Work Time" return no data and I am trying to understand wh… -
where is almacenes all my data generated in fusion applications?My question is, how can I access all the data generated in my Fusion applications? I want to replicate my OAC instance in Power BI. I have an ADB instance, and I've conn…
-
Is there any tool to migrate objects from B2B one instance to another Instance?Summary: One of my customers is using a Fusion instance for Service Cloud with multiple business units. They are planning to migrate and move selected business units int…
-
Hide/remove access to infolets for specific usersSummary: In Germany KPIs such as performance may not be measured at the individual level. It must not be apparent, for example, how quickly an employee has processed or …
-
The report prompt doesn’t appear on the same page when I apply the report filter.Summary: We created a report-level prompt, not a dashboard prompt. We need the prompt and the report to remain on the same page, but when we apply the prompt filter, the…
-
How to report on Live Chat for Fusion Service wrap up resolution in OTBISummary: As part of our Live Chat for Fusion Service roll out in HR Helpdesk, we have built a suite of reports and dashboards that contain information on average wait ti…
-
How to implement rollup functionality in OTBI / BIP report in Oracle CX Sales Fusion?Hi everyone, I’m exploring whether Oracle OTBI (Oracle Transactional Business Intelligence) or BI Publisher can support a report layout similar to the Rollup (expand/col…
-
In which Subject Area Can I get Fields related to "Event" ObjectI need to fetch data related to the "event" object in OTBI Reports. However, I’m not able to locate the fields in OTBI. Can someone guide me on which Subject Area contai…
-
Case Management ReportingSummary: For Case Management my client would like to run a report that produces data relating to the Person number, Department, Job Title, ..etc Can you advise what tabl…
-
Help with Due Date Fields in OTBI for SR MetricsSummary: Hi Team, I’m working on an OTBI report to capture: First Response Metric Breached – Count of SRs that have breached first response time Resolution Metric Breach… -
Sep 2025 SOC and Bridge Letter Delivery DateSummary: What is the projected date for delivery of the Sep 2025 SOC1 report and Bridge letter? We have auditors anxiously awaiting delivery of these reports. Content (p…
-
Audit Data for Custom Fields on Service RequestsHi, we currently have the following query: SELECT DISTINCT SR.SR_NUMBER, CATEGORIES.CATEGORY_NAME AS CATEGORIA_ATTUALE, OLD_CATEGORIES.CATEGORY_NAME AS CATEGORIA_PRECEDE…
-
How to get all the Queues & Resources assigned dates for a Service request in OTBI Analytics reportSummary: Hi Team, As per the requirement, we need to create reports with the list of resources assigned to the SR with the assigned dates and the same for Queues. Could …
-
Moved: Cannot successfully extract metadata using the Out of the box Oracle EPM connector in Oracle…This discussion has been moved.Elaine Leffler-Support-Oracle 1 view 0 comments 0 points Most recent by Elaine Leffler-Support-Oracle -
How do we achieve this calculation to be implemented in FDI/OAC classic Report.Hi Team, There is this caculation requirement in P&L report. Please let me know if anyone has implemented a similar logic for %Calculations in FDI Classic Report. For ex…
-
Import Oracle Fusion Data Extensions for Transactional Business Intelligence completes with ErrorSummary: The following process Import Oracle Fusion Data Extensions for Transactional Business Intelligence has completed in ERROR. Log file attached. Any ideas what has…
-
Request SQL to Extract All Agent Configuration DetailsHi Team, We would like assistance in building a SQL query that retrieves complete Agent configuration details from the backend tables in Oracle Fusion. Currently, we can…
-
Can we create event base value set?At customer site level user have enabled one DFF value for SALESREP_ID which display LOV of all the SALESREP email ids through one value set. Now they are asking if we c…
-
Announcing: Oracle CX Partner Enablement Training Series (Sep 8 - Oct 2)We’re excited to invite all Oracle implementation partners to join our upcoming Oracle CX Partner Enablement Training Series, starting September 8 and running through Oc…