Reporting and Analytics
Discussion List
-
Do you need FDI to create new KPIs in new Purchasing icon?Summary: Hi Oracle community, I am following this link regarding the new Purchasing Icon application on the Procurement tab on the Oracle Fusion Homepage Link: https://d… -
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real timeI need to create prompt in OTBI with Aging days having case function defined, when running i am getting the below error, can someone help me on this CASEWHEN Timestampdi…Shahid Qureshi 01 12 views 2 comments 0 points Most recent by Shahid Qureshi 01 Reporting and Analytics for SCM
-
How to embed Data Model report with filter based on the opened record?Summary: How to embed Data Model report with filter based on the opened record? We have created a BIP Report due to it's flexibility over OTBI and would like to embed it…
-
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…Abhishbansal 1 view 0 comments 0 points Started by Abhishbansal Reporting & Analytics for Fusion Service
-
We need a tables or Query to get Opt-in Features for Financial in oracle fusionSummary: Hi Team, Could you please provide us the Query or Tables to get Opt-in Features for Financial in oracle fusion. We could find the below table, but these are not…
-
Usage of Prompt's "contains any" for both upper case and lower caseSummary: Usage of Prompt's "contains any" for both upper case and lower case Content (please ensure you mask any confidential information): Hi Experts, I am using subjec…
-
How to create audit report using SQL statement where in similar result to history tabSummary: in history tab of each record, we can see the changes of each auditable fields. like for example: field1, we can see in the list the before and after change. i …
-
Handle-Time per Agent for Transferred ChatsContent Does anyone have experience calculating handle-time per agent across a single chat, when multiple agents have handled the chat? For example, if I initially handl…Michael Winter 41 views 5 comments 0 points Most recent by User_HY8R2 Reporting & Analytics for B2C Service
-
Agent's Chat AHT without Virtual AssistantSummary How to exclude VA's AHT from Agent's AHTContent We recently began piloting Oracle's VA. All of our reporting is based on the Chat table, which means it it includ…user3511667 44 views 2 comments 0 points Most recent by Marissa Gonzales Reporting & Analytics for B2C Service -
Is there a way to prevent user from running a report for other BU other than they ownSummary: We have a requirement to prevent user from getting data for BU's other than the one they are assigned to. how to achieve this for BIP report Content (please ens…
-
How to delete the association of Lead and Campaign?Summary: Hi Team, currently, once we add the Lead to Campaign, the association is being created on MKT_CAMP_MEMBERS. But once we removed it, the association Active statu…
-
Retrieving and showing info from third party SystemsSummary: Hi, we need to create reports and documents related to info retrieved via API from a third party system. Furthermore we need to show those data in Account subta…
-
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…Osama Mohamed 14 views 0 comments 0 points Started by Osama Mohamed Reporting & Analytics for Fusion Service
-
how to restrict PII data in OTBI reportsHello, I am creating a report in OTBI and I am using these subject areas "Workforce Management - Person Real Time" and "Workforce Learning - Learning Records Real Time",…Joliver Caangay 21 views 3 comments 0 points Most recent by thoham Reporting & Analytics for Fusion Service
-
How to get subledger accounting details in CAA subject area for journals with non AP, AR sources?Hi All, The Configurable Account Analysis (CAA) subject area in FAW/FDI does not shows subledger accounting details for journals with non AP (Payables) and AR (Receivabl…Junaid Ahmad 3 views 0 comments 0 points Started by Junaid Ahmad Payables, Payments & Cash Management
-
How to export the information that is in the Sales Dashboard from UI RedwoodSummary: I want to export the reports that are in the Sales Dashboard. Content (please ensure you mask any confidential information): I've created several reports in OTB… -
Payroll processing status for timecard not available in HWM_TM_REC_GRP_SUM tableI have a requirement to fetch the "Payroll Processing Status" on the timecard level as shown in the below image. Since the transfer status is available in the table HWM_…Janhavi Kulkarni-Oracle 38 views 1 comment 0 points Most recent by RaduA-Oracle Payroll and Global Payroll Interface (GPI)
-
Reopen RateSummary: Any tips on how to get the number of incidents that were reopened in a given time period? For example went from solved to updated (but may no longer be in updat…Kim Dante 10 views 1 comment 0 points Most recent by George Caragicu-Oracle Reporting & Analytics for B2C Service -
Report Name Change ImpactsSummary: We have some reports in OTBI & BI which have a prefix of a Company and the name is changed - just a letter - XYZ to XY1 - so can anyone advice on the below Do w…Sailajad 15 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to access opportunity Scheduling data for reporting?Summary: In CX, there's a way that reps can forecast, monthly, how much an opportunity product will bring in using the schedule piece. How can we access and report on th…
-
Why Contract Audit Report is not Showing Line Status change/update in Audit ReportSummary: Contract Audit Report Is not Showing Status change/update in Audit Report in line level even though Status field for line level is already enabled in Manage Aud…
-
Deep Link to view the Purcahse Order details from OTBI report is not workingSummary: Deep Link to view the Purcahse Order details from OTBI report is opening a PO Web page but the page is blank Content (please ensure you mask any confidential in…
-
Is it possible to switch the display of an OTBI report to the Redwood view?Summary: I want the reports we create in OTBI to be displayed in the Redwood format. Content (please ensure you mask any confidential information): I want the reports de…SERGIO BARRETO 3 views 0 comments 0 points Started by SERGIO BARRETO Reporting & Analytics for Sales
-
How are you identifying a scheduled reports from a TST siteSummary: I would like a way to identify scheduled reports sent from our lower TST environments so that it can be automatically or manually disregarded as not being from …
-
How does one go about searching/querying an Interaction record by Name/Title?Summary: We have launched the Redwood experience & have also enabled the Redwood Side Panel for Outlook O365. Interaction records are getting created successfully for th… -
How do I source: profile item id for spreadsheet loaderI'm trying to build a spreadsheet loader to load license and certifications specifically Responsible Manager which sits in Responsible Person Region in Skills and Qualif…Tina T 55 views 3 comments 0 points Most recent by Aditya Jena Reporting & Analytics for Fusion Service
-
What all roles has BI Consumer Privilege?Summary: We have created a copy of the Employee role and removed the analytics permissions from it. However, we would now like to grant analytics access to only a few se…
-
issue with custom bip reportSummary: our team has developed a custom report for weekly notification on held invoices. report purpose is if any approval pending or hold to be released it will send i…Yellisetty_Ramesh 12 views 0 comments 0 points Started by Yellisetty_Ramesh Reporting and Analytics for ERP
-
OTBI HCM Workforce Profiles and Counts (counts returning O's only)I thought this would be simple OTBI report, but am stuck on getting an accurate count (returns only zeroes). It should output active Profiles, their associated Job Codes…
-
Generating Record 0150 (Participants/Suppliers) in SPED Fiscal (Bloco K) via LACLS_SpedInvBlocoKHi everyone, I have a question regarding the Brazilian Localization for EFD ICMS/IPI, specifically concerning the generation of Bloco K (Inventory and Production Control…