Reporting and Analytics
Discussion List
-
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 1 view 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 31 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 6 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 11 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…
-
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 51 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… -
Why do Reports suddenly not show results?Summary: We have weekly reports accessible on out Supervisors Navigation that suddenly are NOT showing results. I've made a copy of the Profile and can access these repo…Joe P. 13 views 1 comment 0 points Most recent by George Caragicu-Oracle Reporting & Analytics for B2C Service -
CX Sales BI Publisher report to show payment terms for accountsSummary: Is it possible to have a BI publisher report to show list of account and their payment terms which would have been setup in accounts receivables ? What tables a…Anurag M-Oracle 1 view 0 comments 0 points Started by Anurag M-Oracle Reporting and Analytics for ERP -
Service Overview DashboardWe are wanting to create a dashboard with a structure similar to the Out of the Box Dashboard Service Overview. This dashboard has each report element with a similar siz…BlakeB 23 views 1 comment 0 points Most recent by George Caragicu-Oracle Reporting & Analytics for B2C Service -
REST Data Source Fetching Only 25 Records in Oracle APEX – How to Retrieve All Records?Summary: I am currently working on building a dashboard in Oracle APEX using a REST Data Source to fetch data from an Oracle Database. However, I am facing an issue wher… -
Sales person field in OTBISummary:Salesperson Field Missing in Subscription Real-Time Subject Area Content (please ensure you mask any confidential information): Hi Everyone, I’m facing an issue …UdayShinde_Suavis 1 view 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to Expose Customer_Family Name (Not ID) in Oracle CX OTBI Report?Version:- Oracle CX Cloud Summary:- Unable to expose Customer_Family Name in Oracle CX OTBI; only numeric ID appears when using custom DCL field. Content :- We have a re…Vishal Kakde 11 views 9 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
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…MilaneKhattar 11 views 0 comments 0 points Started by MilaneKhattar Reporting & Analytics for Fusion Service -
CDC capabilities of BICC extractsA few questions about the CDC capabilities of BICC extracts, particularly around how they handle deletions and intraday changes - such as multiple status updates occurri… -
CDC capabilities of BICC extractsa few questions about the CDC capabilities of BICC extracts, particularly around how they handle deletions and intraday changes - such as multiple status updates occurri…Ashwin Almeida 11 views 0 comments 0 points Started by Ashwin Almeida Reporting and Analytics for ERP -
Edit service dashboardHi everyone! How can we configure the Service Dashboard and make new infolets available: We didn't find any documentation about this. Thank you in advance, Martina -
How to schedule report in working hours from Monday to FridaySummary: Schedule oracle standard report in working hours morning 10AM to 7 PM from Monday to Friday Content (please ensure you mask any confidential information): Sched…Tapas_Sathua 11 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM -
Display dashboards in HR Help DeskWe have agents and administrators who receive requests from the HR help desk when they click on the Dashboard icon and this is not the best information, but it has been … -
How to generate BIP report bursting output in PDF and HTML bothThe requirement is to get the email notification through bursting BIP report as an attachment and email body both. The template of the report contains tables , company l…Sharmava 31 views 5 comments 0 points Most recent by Soumya Suravita Reporting & Analytics for Fusion Service -
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 …Chandramouli Yangareddy 95 views 7 comments 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service