Reporting and Analytics
Discussion List
-
Fusion BI Publisher – FTP Delivery Fails on First Burst, Any Delay/Event Option?Summary: Issue Description We are using BI Publisher bursting to generate CSV output and deliver files to an FTP server. Observed behavior: During the initial scheduled … -
Identify the SALARY Amount chanages based on AUDIT_CHANGE_BIT_MAP_ value in CMP_SALARY_ tableSummary: Hi Team, We have a requirment to create a repoert with only whenever user salary amount changes we need to include those rows in Report using CMP_SALARY_ Audit …Venkatesh Emani-Oracle 10 views 1 comment 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
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…
-
Custom Dashboard in Redwood Service Center – Graph Resize, Table Report, and Drill-Down CapabilitySummary: I have created a custom dashboard and embedded an analytics report that displays a graph (SR Routing Report). I need guidance on the following: 1. Graph Size Ad…
-
BICC Extract: No way to correlate MANIFEST.MF file to specific requestSummary: When submitting multiple BICC extract offerings in parallel via the ESSWebService (submitRequest), each completed job produces a MANIFEST.MF file in UCM under t…
-
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 23 views 3 comments 0 points Most recent by thoham Reporting & Analytics for Fusion Service
-
HCM Table that stores Candidate Personal DetailsSummary: I need to get the HCM ORC Table that holds this record based on the screenshot belowUser_6RUAW 2 views 0 comments 0 points Started by User_6RUAW 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 2 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 24 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 2 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…SERGIO BARRETO 2 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 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 11 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. 12 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 22 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 3 views 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