Oracle Fusion Analytics
Discussion List
-
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… -
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…kalyan gade 53 views 1 comment 0 points Most recent by Geno Hawkins- Support -Oracle Warehouse Management
-
Tables related to Demand ManagementSummary: Hi, I need to extract all tables with data related to SCM Fusion Demand Management, but when I look into either data lineage or fusion PVO list I do not see any…Viswanath-Oracle 96 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
MSC_BOMs_VSummary: When queried it results no data and when the code is viewed it says "undefine" Content (please ensure you mask any confidential information): Is this a bug that…Mike.Myers.CDIPRODUCTS.COM 11 views 2 comments 0 points Most recent by Mike.Myers.CDIPRODUCTS.COM Reporting and Analytics for SCM
-
Not able to pass parameters from fusion into reportInside quality management -> we created a button named report in which a report link inserted, Data inside report is fine, But the requirement is to pass the data dynami…Neeraja Chinta 28 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
How to add an Hyperlink/Button without page or app composer'sOur requirement is to add an hyperlink/button in this page, But page composer in this page does'nt alllow us to add new components here. Object related to this page does…Neeraja Chinta 2 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Unable to find database tables for Manage Terms and Conditions SetupHi Team We have the requirement to use the terms and conditions created under manage terms and conditions setup but not able to find out the related table or lookup. ple…PradeepkumarsharmaGX 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
How do I stop my OTBI screen from going Null when the user leaves and comes backSummary: We need to keep the values in the dashboard when the user moves from tab to tab. Content (please ensure you mask any confidential information): Version (include…Larry Sherrod 2 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Need to display transaction details present under Review Production Transaction History ScreenSummary: I Need to display all the transaction details present under Review Production Transaction History Screen. Please let me know the table that stores Production Tr…
-
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 498 views 7 comments 1 point Most recent by Vrinda Mittal Reporting and Analytics for SCM -
OTBI Deep link not workingHI All, We could see the deep link doesn't work for CHANGE REQUEST, PROPOSAL ,CONCEPT and REQUIREMENTS. If I try to use OTBI dashboard a blank page opens up. However, wh…Swapnil Kashid 32 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
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 51 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…
-
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 12 views 1 comment 0 points Most recent by SRGogula-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 165 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 112 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 42 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…
-
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 41 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 325 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 206 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 102 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 21 views 1 comment 0 points Most recent by Kelly Cooper-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… -
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 542 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 714 views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM