SQL
Discussion List
-
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…User_2025-02-11-07-07-59-045 761 views 1 comment 0 points Most recent by User_2025-02-11-07-07-59-045 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 928 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
How to capture existing Report name and Data model details in BIP ReportSummary How to capture existing Report name and Data model details in BIP ReportContent Hi All, We are having a requirement to develop the BIP publisher report which wil…Rohit Soni-259808 92 views 2 comments 4 points Most recent by Rohit Soni-259808 Reporting and Analytics for SCM -
Outbound interface to fetch records from FBDI Template which are ProcessedSummary Outbound interface to fetch records from FBDI Template which are ProcessedContent Hello Tech Gurus, I am new to Oracle Cloud.I have a requirement for outbount in…User_2025-02-05-23-01-57-438 44 views 1 comment 0 points Most recent by RaviThejaDarbha Reporting and Analytics for SCM
-
Bursting sending duplicated reports.Summary Some outputs are being sent duplicted (or more!) by mailContent I have a report to get the hand quantity for each subinventory. The output is like: SUB ITEM QTY.…User_2025-02-07-06-48-26-537 29 views 2 comments 0 points Most recent by User_2025-02-07-06-48-26-537 Reporting and Analytics for SCM
-
How to Print the attachment in PO ReportSummary We have a requirement to get the attachment from a PO should get displayed on the View PDF document. Kindly SuggestVersion 11.13.20.04.0Yogesh Kumar-234569 125 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
Generating a indented BOM list report.Content Hey there, I'm trying to generate a report with the indented list of a BOM. In Oracle 10 we had fields to build the structure based on a starting node and then j…User_2025-02-07-06-48-26-537 107 views 4 comments 0 points Most recent by Ahmed Mousa Reporting and Analytics for SCM
-
Use text box for user in analysisContent Hi, I am trying to create analysis that return data for selected reference designator. I succeeded to create analysis that let the user to select reference desig…
-
Item Master ReportSummary Item Master ReportContent Hello, Can you please advise if there is an option or a seeded report in Fusion where we can get a list of all item code with their res…User_2025-02-05-12-20-44-163 174 views 8 comments 0 points Most recent by User_2025-02-05-12-20-44-163 Reporting and Analytics for SCM
-
Report for all items name + item code + barcode numberSummary Report for all items + item code + barcode numberContent Hello All, I need a report to display the Item Name + Item Code + Barcode Number. I have the below table…User_2025-02-05-12-20-44-163 194 views 1 comment 0 points Most recent by User_2025-02-05-12-20-44-163 Reporting and Analytics for SCM
-
Oracle Fusion Cloud Audit Reports - Changes in Static Data (Before and After Values)Summary Audit Reports - Additional Functionality (Before and After Values)Content Hi, My client wishes to have a more detailed Audit Report functionality Currently the A…Stuart Hackney 46 views 2 comments 0 points Most recent by Stuart Hackney Reporting and Analytics for SCM
-
Remove merged cells from report in reports & analyticsSummary Remove merged cells from report in reports & analyticsContent Hello, Please note that we have a report : Scott Marketing report which has merged columns B & C AN…User_2025-02-05-12-20-44-163 203 views 7 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
Report for All Products in Staging with Order NumbersSummary Report for All Products in Staging with Order NumbersContent Hello, Can you please advise from which subject area we can download a report with all products in s…User_2025-02-05-12-20-44-163 30 views 2 comments 2 points Most recent by User_2025-02-05-12-20-44-163 Reporting and Analytics for SCM
-
Defaulting LOV parameter value from sysdateSummary Defaulting LOV parameter value from sysdateContent Hi All, How to default Menu Parameter, from sysdate. Say, we need to get Month and year in the format of 'Mon-…User_2025-02-05-08-33-37-492 33 views 4 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for SCM
-
SCM Report queriesSummary I would like to know where i can find a repository of report queries for this subject area.Content I would like to know where i can find this information for Pro…User_2025-01-25-06-03-46-894 98 views 4 comments 3 points Most recent by User_2025-01-25-06-03-46-894 Reporting and Analytics for SCM
-
Possibility to retrieve URL of an attachment stored in SaaS through BI PublisherSummary URL of attachments stored in UCMContent Hi, I am trying to find a way to extract via BI Publisher the URL of an attachment stored in the UCM. I have checked in t…Alberto Romani-Oracle 46 views 7 comments 1 point Most recent by Alberto Romani-Oracle Reporting and Analytics for SCM
-
How Charge type (Freight, Duty...) is calculated on a POSummary How Charge type (Freight, Duty...) is calculated on a PO in Landed Cost ManagementContent I need to show per unit cost of Charge (Freight, Duty, Material, Miscel…
-
Inventory OnHand Balance ReportSummary Inventory OnHand Balance ReportMahgoub S.Mohamed 92 views 1 comment 0 points Most recent by User_2025-02-07-08-26-19-537 Reporting and Analytics for SCM -
Need a query to fetch all the report names and its locationSummary Need a query to fetch all the report names and its locationContent Hello All, We have a requirement like what are the reports are avilable in the system and what…Koteswararao Yenikepalli 54 views 1 comment 0 points Most recent by Siva Kumar-Oracle Reporting and Analytics for SCM -
How to override NULL valuesSummary How to override null value with values from another column in OBIEE AnalysisContent When building an analysis in OBIEE, what would be the code to enter into the …User_2025-02-06-00-08-33-553 44 views 6 comments 0 points Most recent by User_2025-02-06-00-08-33-553 Reporting and Analytics for SCM
-
Need A SQL query to get the supplier contact address detailsSummary Need A SQL query to get the supplier contact address detailsContent Need A SQL query to get the supplier contact address details Here I have attached the screens…Koteswararao Yenikepalli 286 views 1 comment 0 points Most recent by Siva Kumar-Oracle Reporting and Analytics for SCM
-
How to display only most recent records in an analysisSummary How to output only the most recent records in "Inventory - Onhand Balance" analysisContent In OBIEE, Is there a way to modify the pre-built analysis "Inventory -…User_2025-02-06-00-08-33-553 49 views 1 comment 3 points Most recent by User_2025-02-06-00-08-33-553 Reporting and Analytics for SCM
-
OTBI how to list repeated valuesSummary how to use list component to repeat valuesContent Hello, I've created a customized report in OTBI and it i'm using the list component to present the data retriev…User_2025-02-05-18-37-12-438 56 views 4 comments 3 points Most recent by Bradley Q-Oracle Reporting and Analytics for SCM