Reporting and Analytics
Discussion List
-
MICR line zeros showing too smallHi, We have created a cheque rtf template and to display the MICR line we have used MICRE13B font as per the bank suggested font and font size is 13. However in the MICR…Krishna Kishore 37 views 2 comments 1 point Most recent by Jon Kennedy Reporting & Analytics for Fusion Service -
Need to automatically trigger the OAC Report (Certificate of Analysis) upon Ship ConfirmationHello Everyone, There is a business need to automatically trigger the OAC Report (Certificate of Analysis) upon Ship Confirmation. Navigation Path for Ship Confirmation:…Tauqeer Farhan 2 views 0 comments 0 points Started by Tauqeer Farhan Reporting & Analytics for Sales
-
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 …
-
Unable to find the subject area for the context segment of work order for OTBI reportHi Everyone, We’re working on an OTBI report for Work Order details and need to include the Context Segment field. However, this column doesn’t appear in the Work Order …Tauqeer Farhan 4 views 0 comments 0 points Started by Tauqeer Farhan Reporting & Analytics for Sales
-
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 26 views 4 comments 0 points Most recent by Chandramouli Yangareddy Reporting & Analytics for Fusion Service
-
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 16 views 7 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to create an infolet link to an Advance Seach to the applicationSummary: How to create an infolet link to an Advance Search to the application. Similar of what I attached to the question. This one is an Oracle seeded infolet. if you …diego m schenquerman 8 views 0 comments 0 points Started by diego m schenquerman Reporting and Analytics for SCM
-
Audit History Tables for Account, Contact & AddressSummary: We have a requirement to create a BI report for Account, Contact, and Address objects for auditing purposes. Currently, the Audit Reports functionality in the U…
-
Cloud GRNI reconciliation ProcessSummary: Is there anyone familiar with Cloud GRNI reconciliation with GL process? There is a seeded GRNI report but I ran it error out I tried "Accrual Reconciliation Re…Sharon.men 7 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
How to Schedule Processes (ESS) monitor and include several recipient/emails in only one line ?Summary: How to Schedule Processes (ESS) monitor and include several e-mails in only one line ? Content (please ensure you mask any confidential information): Hello I ne…martingabriel Kinovisques 7 views 1 comment 0 points Most recent by James McBride Fusion Applications Administration
-
How to run Costing Reports outside of Scheduled Processes?Most of the reports under /Shared Folders/Supply Chain Management/Cost Management/Cost Accounting and /Receipt Accounting are only able to be run through the Scheduled P…Abigail Wiggins 11 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
report only returns current live inspection dataWe have developed an Inspection Summary Report in Oracle Fusion (BI Publisher / OTBI) to retrieve inspection history for all items in our inventory organizations. The re…Patrick Chrabieh 5 views 0 comments 0 points Started by Patrick Chrabieh Reporting and Analytics for SCM -
SFTP connection is not workingWe are running a BIP report which has bursting SFTP using ESS job. The Job is failing with the below errors. Document delivery failed [INSTANCE_ID=bip.bi_server1] [DELIV…Radhika Sharma 21 views 1 comment 0 points Most recent by Alexandru-Catalin Serban-Oracle Fusion Applications Administration
-
Oracle 26A release impacting the OTBI subject area "SCM – Inventory Receipts".Oracle has announced changes as part of the 26A release impacting the OTBI subject area "SCM – Inventory Receipts". As per Oracle documentation, the Inventory Receipts s…Sudeep Das Bairagya 6 views 0 comments 0 points Started by Sudeep Das Bairagya Reporting and Analytics for SCM
-
Not getting values in history table of ContactsSummary: Hello I am trying to build a data model to get the change history records for the out of box Contacts object which is present under Sales Tab. Used below query …
-
How to identify Region/Location names on Transit time tables?Summary: On the transit time tables (WSH_TRANSIT_TIMES/WSH_TRANSIT_TIME_VALUES), we have the From & To Location and Region ID's. So, which tables can be used to map thes…
-
best practice to generate a report of emails / interactions for the sales teamSummary: I am looking for the best way to generate a report on emails sent and interactions that are tracked in Fusion Sales I want to be able to see by Sales Resource a…Tim Gruidl 1 view 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
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…Viktoria Priona-Oracle 24 views 1 comment 0 points Most recent by Paul Romero-Support-Oracle Reporting & Analytics for Fusion Service -
Available Today: Out of the Box Reports for Subscription ManagementSummary: Out of the Box Reports for Subscription Management - available today in Oracle Sales. Content (required): Out of the Box Reports for Subscription Management - a… -
Need a query to fetch the status of Manage Negotiations pageContent Hello, Can someone please tell me a table to fetch the status of the negotiation on the Manage Negotiations page. Please find the attached image with the require…Sushan Peiris 2.4K views 8 comments 4 points Most recent by Siddarth G L Reporting and Analytics for SCM -
How to get the time of incident reach to a particular queueHi, I need to Show date request was moved to a particular queue. How to find that? Also I need to show the initial severity of the case. Regards, MeeraMeera Saseendran T 23 views 3 comments 0 points Most recent by Ashutosh_86 Reporting & Analytics for B2C Service
-
How to access fa_fusion_soainfra.wftask_sec , FA_FUSION_SOAINFRA.WFTASKHISTORY tables from fusionUnable to access fa_fusion_soainfra.wftask_sec , FA_FUSION_SOAINFRA.WFTASKHISTORY tables from fusion, Getting error as ORA-01031: insufficient privileges. Please let me …Thanigainathan R 27 views 4 comments 0 points Most recent by Andrada-Oracle Fusion Applications Administration
-
What is the Vacation Delegation Table in fusionWhat is the Vacation Delegation Table in fusion and what is different between FA_FUSION_SOAINFRA.WFUserVacation and PER_DELEGATED_ROLES I am encountering an error (ORA-0…Mohamed Shaaban 42 views 3 comments 1 point Most recent by BK_Oracle-Oracle Fusion Applications Administration
-
What's the subject area for Opportunity recurring revenue?Summary: What's the subject area to use for OTBI analysis on Opportunity with recurring revenue (schedules)? Content (please ensure you mask any confidential information…
-
How to add Shipment Header DFF in OTBI report?How to add Shipment Header DFF in OTBI report?Mugdha 21 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Custom Filter for Tables in Redwood sales dashboardIs there a way to create and apply custom filters to an entire tab on the Sales Dashboard? We are trying to add custom filters to our Sales Dashboard ‘Pipeline’ and ‘Tea…
-
User login/logoff and download historyWe need to determine if our Oracle HCM Cloud application has the ability to provide the following information for a user during a date range Login history (not just last…Rob Turner 27 views 2 comments 0 points Most recent by Rob Turner Fusion Applications Administration -
Add a link report to a report total calculationSummary: Add drilldown on a total count column. Content (required): I have a report that has a column count. I add a total count for the column I select from the Design …
-
Generate an audit trail showing employee activity (runs and downloads) for specific BIP reportsHow can we generate an audit trail showing employee activity (runs and downloads) for specific BIP reports? To comply with auditing and security requirements, we need to…Mohamed Fathelrahman NM 5 views 1 comment 1 point Most recent by Alexandru Dicu-Oracle Fusion Applications Administration