Reporting and Analytics
Discussion List
-
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
-
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 21 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 26 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… -
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 26 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
-
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 32 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 22 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 3 views 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 11 views 1 comment 0 points Most recent by Michelle Akin-Support-Oracle Reporting & Analytics for B2C 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 …
-
Capture OTBI Report LogsSummary: Hello, We have a setup in which an OTBI report is triggered from Oracle Integration Cloud using SOAP APIs. We are experiencing intermittent issues where the OTB…Support Account 2 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
OTBI Case Statement excludes some of the row from StatementsSummary: After adding Transaction code formula as follows CASE WHEN ("- Line Information"."Statement Line Transaction Code" = '165' AND "- Line Information"."Statement L…Praveen Gopalakrishnan 21 views 2 comments 1 point Most recent by Praveen Gopalakrishnan Reporting and Analytics for ERP -
Not Being able to send the Output to a group mail id (DL/NG) white scheduling a report from BIPWhen i schedule a report from the report and analytics screen giving a DL (Distribution list) /NG in the destination mail id the output is not getting delivered . Did an…Sarath C P 11 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
FscmTopModelAM.FinVrmRRSharedPublicModelAM.PerfObligationLinDistsPVO- Duplicates for primary keyACTUAL BEHAVIOR Running BICC extract to extract information from PVO FscmTopModelAM.FinVrmRRSharedPublicModelAM.PerfObligationLinDistsPVO in BICC. PERFOBLIGATIONLINEDIST…Prabhjeet Kaur 51 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Issue with Tax Amount Display in OTBI Line ItemsSummary: Merge Tax line of receipt Content (please ensure you mask any confidential information): Hi, We need to include the tax amount on a single line. Currently, in O…Muhammad_Saad 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
PO PDF Printing in Supplier Address Language Instead of EnglishThe customer needs the PO PDF to be printed in English; however, it is currently being generated in the language defined at the supplier address. eg. supplier address la…Kinjal Patel-Oracle 12 views 1 comment 2 points Most recent by Ketan Janva-Oracle Reporting & Analytics for Fusion Service
-
Need a table that stores BIP Report Email recipient listHi, Which table stores the BIP Report Email recipient list. Thanks in advance.Kinjal Patel-Oracle 11 views 1 comment 4 points Most recent by Ketan Janva-Oracle Reporting & Analytics for Fusion Service