Reporting and Analytics
Discussion List
-
How to access Data Model via API?Summary: How to access Data Model via API? Content (please ensure you mask any confidential information): Hi, our customer have external dashboards, using PowerBI, and t… -
Get Work Order Details for a Service RequestHi We have a requirement to get the Service Request details along with the associated work order detail in a report. A possible join can be the the SR Number and Work Or… -
What would be the reason of showing the Enterprise Quarter as null in Analytics- Sales CRM PipelineSummary: Eventhough the Accounting calendar is setup with proper periods & quarters; Calendar profile option also set to the configured. The opportunity records are show…Cyriac Mathew-Oracle 22 views 2 comments 0 points Most recent by Cyriac Mathew-Oracle Reporting & Analytics for Sales -
Filtering NULL values in a dashboard promptSummary: Hi, I need to be able to filter for NULL values in a dashboard. Specifically, I have a filter on Gender, which can be NULL or Male/Female, for example. If I use…Guido Masciello 45 views 2 comments 0 points Most recent by Guido Masciello Reporting & Analytics for Sales -
How to Enable Membe Opportunity Visibility Across Multiple Organizations in Standard Sales Security?Hi, We’re working with standard sales security in Oracle Fusion Sales (not using Advanced Sales Security or Enhanced Territory Management) and facing a visibility issue … -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 21 views 2 comments 1 point Most recent by ravikiran goda-Oracle Reporting and Analytics for SCM
-
How to get the assignment number from the time card entry page ?I have a requirement to get Assignment_Number from time card entry page and not on person level. please find screenshot for reference.AbhinavA 21 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
sales dashboard metric currency is always in USD.Summary: We have enabled the Sales Dashboard Metrics (For eg: Pipeline and Team pipeline). This calculates the Sum of all Revenue Amount of the opportunities. This value…A V K JAYA SURYA 43 views 3 comments 0 points Most recent by Naveen Marujolla Reporting & Analytics for Sales
-
We need a dynamic GIF Image send over emailWe need a dynamic GIF Image which is like a video image to be incorporated and send over email to employees on their birthday.Shaarif_Hussain 1 view 2 comments 0 points Most recent by Loo Alex Reporting & Analytics for Fusion Service
-
C5ISR Audit (User Access and Behavior)We need to create BI report(s) that include as much of the FUNCTION information below as possible for audits. Already finding some useful data in the ASE_USER_LOGIN_INFO…Rob Turner 11 views 1 comment 0 points Most recent by Wendy Horowitz-Oracle Fusion Applications Administration -
Can Oracle Application Performance Monitoring (APM) track user events similar to Google Analytics?I'm exploring the capabilities of Oracle Application Performance Monitoring (APM) and I'm curious if it can track user events in a manner similar to Google Analytics. Sp…
-
Page Break function not working for excel(MHTML) output formatHi Team, The customer wants to redevelop the Excel template report (with multiple tabs) into an RTF template, as the Excel template only displays 65K records per tab. We…Somasekhar Basetty -Oracle 11 views 1 comment 0 points Most recent by Rizwan.Ahmed009 Reporting & Analytics for Fusion Service
-
Is there a way to hide the views menu option from the My Approval Search page?We just want the users to see the quotes needing their approvals and limit their access on searching and filtering quotes from other regions and other sales users.
-
In Fusion HCM How can we check what security roles are assigned to user and who has assigned them?How can we check what security roles are assigned to user and who has assigned them?vikash4rv 52 views 4 comments 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Applications Administration
-
How download a BI report in PDF Output using Smart Action on redwood page?Summary: On a CX Sales Redwood page, we’ve added a “View PDF” smart action button. The requirement is that when the user clicks this button, it should trigger a BIP (BI …Ashu Singh 59 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Query to get Applied prepayment amountSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Ritu123 43 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Update ATTRIBUTE column value(to ASN#) in WSH_DELIVERY_DETAILS table after Ship confirmSummary: Can we update ATTRIBUTE column value(to ASN#) in WSH_DELIVERY_DETAILS table in Fusion after Ship Confirm business event? Content (please ensure you mask any con…Khalida Raffath 11 views 1 comment 0 points Most recent by Khalida Raffath Reporting and Analytics for SCM
-
How Can I Show BOM Level Information for Each Item in a Report?I’m encountering an issue and would appreciate some guidance. I need to display the BOM in the report with the level information, and I’ve attached a picture for referen…Dinar 83 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Querying 'Entered Unit Cost' and 'Material' from the 'Rolled Up Cost' ViewSummary: I need to make a query and retrieve the 'Entered Unit Cost' and 'Material' from the 'Rolled up Cost' view, but I'm not sure which table I should use to obtain t…Dinar 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
While I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing onlyWhile I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing only and at least I am getting timeout error. Here is my query. Can you p…
-
Roles/Previlage Usage-Remove unused Roles /Previlages from the UsersWe need the Report to extract the below Details to Remove unused Roles /Previlages. Example : 1.Role Usage : When is the Last date Role used by the User ( For example: I…JAGADEESH DS 31 views 6 comments 1 point Most recent by Andrada-Oracle Fusion Applications Administration
-
which field should I use for the Validation Status of AP Invoices?I am creating the Data Model of our BIP Report and I need to find out which field from what table should I use as Validation Status.Alvin 21 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
Custom BIP report for Accounts payable trial balanceI am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to put the as…Ritu123 11 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
Analysis to monitor the average time of the CRM APIs response we consumeSummary: We would like to know how to create a report to monitor the average time of the CRM (Oracle Sales Fusion Cloud) APIs response we consume from all integrations. …Joan Rodriguez 21 views 2 comments 0 points Most recent by Umamaheswarareddy Ambati-Support-Oracle Sales
-
After migration of FR to reports is formatting issue where a row has expanded in height drasticallyAfter migration of FR to reports I have a formatting issue where a row has expanded in height drastically, but all row height parameters are correct. Any idea what could…
-
In partners, need the corresponding backend table and column name for Partner's Geographies Served.In partners, there is a column titled 'Partner's Geographies Served.' We need the corresponding backend table and column name. In BIA, we are currently able to retrieve …Vennela Valluri 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
how do you retrieve soc1 reportsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PFreeman 71 views 3 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
query to get address number via SourceSystem and SourceSystemReferenceValue (address).Summary: query to get address number via SourceSystem and SourceSystemReferenceValue (address). Looking for table_name to get the values of SourceSystem and SourceSystem…
-
Sp HTTP 500/504 errors when using SOAP API in using BI PublisherSummary: My team makes calls every 30 minutes to BI Publisher through a SOAP API to retrieve information we need to update tables on an on prem database. We are making t…StefanyD 71 views 2 comments 0 points Most recent by Ankita Biswas-Oracle Reporting & Analytics for Fusion Service