Reporting and Analytics
Discussion List
-
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 3 views 0 comments 0 points Started by Tauqeer Farhan Reporting and Analytics for SCM -
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 1 view 0 comments 0 points Started by diego m schenquerman Reporting and Analytics for SCM
-
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 1 view 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
-
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 2 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 2 views 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 21 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 21 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 41 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 33 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 1 view 1 comment 1 point Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
Trying to run Person Profile and Talent Profile reports in Reports and Analytics but getting no dataWe are trying to run these 2 reports in reports and analytics but we are getting no data back. I tried the Person Profile Excel version as well but the excel is blank. I…Dapper Dandle 40 views 1 comment 1 point Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
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 25 views 4 comments 0 points Most recent by Neerajk Reporting & Analytics for Fusion Service
-
Is the join operator ( ) deprecated in Oracle fusion SQLIs the join operator (+) deprecated in Oracle fusion SQL. Can we still use (+) in SQLs or shall we go with ANSI standard for eg: left outer join or Right outer joinSrinivas VRA 21 views 3 comments 0 points Most recent by Srinivas VRA Fusion Applications Administration
-
25D New Column in EGP_SYSTEM_ITEMS_B - Custom Integrations FailingSummary: We are currently reviewing the recent Oracle patch updates in PROD and have encountered an issue that warrants clarification to ensure smooth implementation for…Vignesh Subramanian 1 view 0 comments 0 points Started by Vignesh Subramanian Reporting and Analytics for SCM -
How to add profile creation and queue creation date in reportSummary: Hi community, How we can add profile creation date and queue creation date on reports in Oracle service cloud reports As a first step i have verified that we do…Santosh kumar purusottam 12 views 1 comment 0 points Most recent by Michelle Akin-Support-Oracle Reporting & Analytics for B2C Service
-
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…Prajkta Hire 11 views 0 comments 0 points Started by Prajkta Hire Reporting & Analytics for Fusion Service
-
In FOM. What is the fields names on the DOO_ tables to link a service line with its parent line.I'm trying to match the Service Line with its parent Line. I've created a SQL query in FOM. In my output, the service line is not matching up with its parent line. What …