Oracle Fusion Analytics
Discussion List
-
How to increase time-out limit for online reportsSummary: I need to know where to increase the processing time for online reports. We have already increased the extraction limit to 2GB, but when we extract the report w… -
Hide catalog toolbar when call analytic report from ApplicationsSummary: How Hide catalog toolbar when call analytic report from Applications Content (please ensure you mask any confidential information): Version (include the version…Arafat022 17 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Are there any seeded infolets available for HCM?Summary: I enabled HCM Infolets in Rel 23C. However, it only resulted in a blank HCM infolets page. Are there any seeded infolets available for HCM? If so, how can I ena…Mohammad Hussein 22 views 0 comments 0 points Started by Mohammad Hussein Reporting and Analytics for SCM
-
Fusion warehouse calendar querySummary: Need warehouse calendar query. I built a query that needs to have year, month, month start information using msc_calendar_months but msc_calendars table does no…
-
Need query to pull item cost details for specific transactionsSummary: Content (required): Business requirement is to pull item cost details for specific transactions from the refurbished SKUs Version (include the version you are u…kalyan gade 1 view 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
How to filter out duplicate value for multi-rows attributes in OTBI analysisSummary: The OTBI analysis shows duplicate value for multi-rows attributes. I need a way to filter them out in analysis. Content (required): I have two multi-rows attrib…Albert Liu 100 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Need a query to get details from Review Cost Accounting Distributions UIContent Hello all, I need to get the highlighted fields as per the screenshot I have attached for the Account Alias Issue transaction. In the UI,78001 Account Alias Issu… -
BIP ESS Job ErrorSummary: create ESS Job For BIP Report ,Go error when run Schedule Process Content (required): Version (include the version you are using, if applicable): Code Snippet (…
-
What is the PVO for Item Descriptive FlexfieldsContent: Once DFFs for Items (EGP_SYSTEM_ITEMS_DFF) are "BI enabled" and deployed, what is the associated PVO that can be used in BICC to extract those Flexfield values …User_BEGVH 40 views 3 comments 0 points Most recent by Marc Vermeulen Reporting and Analytics for SCM
-
convert date formatSummary: Need help with date formatting Content (required): substr(fleff.attribute_char5, 1, 10) to only display as MM-DD-YYYY Below is the query: SELECT substr(fleff.at…kalyan gade 89 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
SCM & Procurement Standard reports templates ?Summary: am searching for a document that include fusion SCM & Procurement Standard reports templates Content (required): SCM & Procurement Standard reports templates Ve…Mohamed AttiaAllah-Oracle 46 views 4 comments 0 points Most recent by Mohamed AttiaAllah-Oracle Reporting and Analytics for SCM -
Need Query to pull the item costs for the refurbished SKUsSummary: Have a requirement to find the item costs for refubrished SKUs Content (required): Query to pull the item costs for the refurbished SKUs Version (include the ve…
-
Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDMSummary: Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDM Content (required): Is there any possibility to update the Sales Order…Pandiyan 187 views 5 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
OTBI - Locating 5th occurrence of characterSummary: Several fields have been migrated into one field and need to split into separate columns into OTBI Content (required): We need to pick the department from the c…Sai Revanth-Oracle 45 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM -
Documentation on Complete list of available pre-built KPI/metrics in Fusion SCM Analytics (FAW)?Summary: Can you please let us know the link where we we can get to know the complete list of metrics/KPI available in SCM Analytics for OM, Procurement and Inventory? C…SIVA.G 190 views 4 comments 1 point Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
Why Front Infolets Source to Settle it does not show any data?Summary: Analytics Source to Settle Infolets section in front not show any data (blanket) users only can see results into Expanded view. Content (required): Procurement …Yerwin Blanco 135 views 2 comments 1 point Most recent by Yerwin Blanco Reporting and Analytics for SCM -
OTBI/BIP catalog refresh/modified dateHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified …Swapnil Kashid 53 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
OTBI Report view as Transpose RowsSummary: Content (required): Hello Friends, How I can get a Transposed view display for OTBI report (based on subject Area)? For Example: Currently I am getting output a… -
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 25 views 1 comment 0 points Most recent by Kelly Cooper-Oracle Reporting and Analytics for SCM
-
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 268 views 6 comments 4 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM
-
Combine CSV Files to ZIP fileSummary Combine CSV output to ZIP fileContent We have requirement to combine the multiple CSV output files to single ZIP file and move it to UCM server. There were enhan… -
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 591 views 1 comment 4 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Does anyone who a query to fetch the PO number created relevant to a Transfer Order Inter organizatiContent Hello all, I need a query that picks the PO number generated for the transaction type Transfer Order Inter organization Receipt in review completed transactions.…Sushan Peiris 154 views 6 comments 1 point Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Need a query for a date parameter dependent to another date parameter.Content Hello all, There's a query I need to get the month names separately with one parameter and another parameter to select a date range. The month name parameter sho…Sushan Peiris 281 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
How to create a label called "ALL" when selecting all from a parameter in BI reports.Content Hello all, I want to know if there is any way that I could display a word called "ALL" when I select all from a LOV of a parameter in the BI report in ORACLE FUS…Sushan Peiris 201 views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made …Sushan Peiris 1.6K views 1 comment 2 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Query to find Product Family of ItemSummary Query to find Product Family of ItemContent Hi All I wanted to find the table or query which hold the Product_family details of an items: Below is the screenshot…Rohit Kumar-266502 310 views 1 comment 0 points Most recent by Rohit Kumar-266502 Reporting and Analytics for SCM
-
Need a query to get Remit to supplier name for a given supplier.Content Hello all, I want to know where I could get the Remit-to-supplier name mentioned in the supplier management page in Oracle Fusion. I have got to tables joined, p…Sushan Peiris 295 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Not able to find Source Locator- Inventory Transaction Real Time Subject AreaContent Hi Team, I am new to Analytics reporting & need help to create a report with Below Scenario: 1) We need a report where Transaction Type = 'Subinventory Transfer'…Mayank Pande 36 views 2 comments 2 points Most recent by Sahil Makhiza Reporting and Analytics for SCM