Reporting and Analytics
Discussion List
-
How to get a dump of records from Oracle Fusion CX CloudHi Team, We need to extract a complete dump of all Contacts and Accounts from CX, including all available fields (full record details). Since most of these records were … -
How to get relevant FA cost balances between accounts after a category change?Summary: For the below asset, there has been a category change. This resulted in 2 different cost accounts, old and new. Is there a way to get the Cost balances for it a…
-
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 …
-
1In app bell notification and things to finish not updated after synchronizationSummary: The bell notifications and tasks under things to finish are not getting updated after running the process "Synchronize Notifications in Global Header" The synch…Tariq Mohammed 72 views 0 comments 1 point Most recent by Tariq Mohammed Idea Lab – Core Infrastructure
-
Difference in report outputs in PIMI have a custom report built using SQL based data model, no UI or report level filters. However when I run the report an excel is downloaded with inconsistent report out…
-
Does BI Publisher's PublicReportService not support OAuth Tokens?Is it only possible to use Basic Authentication (username/password) or pass the userID and password in the SOAP Header?TTI_PRCIT 5 views 1 comment 0 points Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
Agent Effectiveness report does clock stop during non business hoursSummary: I am looking at the out of the box report #57 Agent Effectiveness - Detailed. : For the columns circled below, does this include non-business hours (i.e. weeken…Kim Dante 12 views 1 comment 0 points Most recent by George Caragicu-Oracle Reporting & Analytics for B2C Service -
Report descriptionSummary: I would need a complete list of Out Of the Box Reports for Oracle ERP and SCM. Content (please ensure you mask any confidential information): I would need a com…DamianLopez7 11 views 4 comments 0 points Most recent by DamianLopez7 Reporting and Analytics for SCM
-
Table for Bursting related information and Bursting Notifications to WorklistDo we have a way to track/report notifications sent from report Bursting? If so, what attributes can we capture (e.g., recipient(s), subject, body etc.)? Does the report…Dhananjay Seervi 13 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Is there a way to request additional indexes to Oracle Fusion seeded tables like?Hello, we have a huge custom datamodel for the invoice print receivables process. After analysing the execution plan (provided by Oracle support for the main dataset) we…Frank.Steinjan 2 views 2 comments 0 points Most recent by Frank.Steinjan Fusion Applications Administration
-
Subledger Accounting - Journals Real TimeHi, We're experiencing an issue in an OTBI Analysis where we are unable to pull back data from any columns relating to Supplier, Purchase Orders, and Receipt Numbers at …
-
FRS report is going into error after migrating to UAT instanceFRS report is going into error after migrating to UAT instance. The migration was done by two different methods. 1. Archiving from SIT and unarchiving to UAT. 2. Exporti… -
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 2 views 1 comment 0 points Most recent by Ahmed Maher Kadeh 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…Anusha716 22 views 4 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Fusion Applications Administration
-
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 1 view 1 comment 0 points Most recent by Chaitanya KM Reporting & Analytics for Sales
-
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 39 views 2 comments 1 point Most recent by Jon Kennedy Reporting & Analytics for Fusion Service
-
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 2 views 0 comments 0 points Most recent 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 Most recent 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
-
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 25 views 0 comments 0 points Most recent 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 23 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 44 views 3 comments 1 point Most recent by BK_Oracle-Oracle Fusion Applications Administration