SQL
Discussion List
-
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…Tejaswi p 48 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.…Gabriel Alejandro Zorrilla 28 views 2 comments 0 points Most recent by Gabriel Alejandro Zorrilla 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 114 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…Gabriel Alejandro Zorrilla 98 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…Yogesh Nemchand 140 views 8 comments 0 points Most recent by Yogesh Nemchand 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…Yogesh Nemchand 158 views 1 comment 0 points Most recent by Yogesh Nemchand 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 45 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…Yogesh Nemchand 187 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…Yogesh Nemchand 29 views 2 comments 2 points Most recent by Yogesh Nemchand 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-…Naveen Kumar-158764 32 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…Denrick Jack 97 views 4 comments 3 points Most recent by Denrick Jack 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_XW1ZL 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 53 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 …Jonathan Chan gmg 43 views 6 comments 0 points Most recent by Jonathan Chan gmg 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 245 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 -…Jonathan Chan gmg 48 views 1 comment 3 points Most recent by Jonathan Chan gmg 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…Vitor Lima-178070 50 views 4 comments 3 points Most recent by Bradley Q-Oracle Reporting and Analytics for SCM
-
Security In Data ModelSummary How to restrict user by not getting data of other BU in BIP ReportContent Hi Champs, Let's say my user 'A' has access to only 'X' Business Unit. How should BIP d…Manish Pesswani 124 views 2 comments 2 points Most recent by Mrigank Sharma Reporting and Analytics for SCM -
Pixel perfect PDF reportsSummary Pixel perfect PDF reportsContent We need some inputs on best practices / recommendations for developing pixel perfect PDF reports. Context: The implementation sc…Mirza Nasir Beg Nasir-Oracle 43 views 0 comments 0 points Most recent by Mirza Nasir Beg Nasir-Oracle Reporting and Analytics for SCM
-
Customization on the AP invoiceSummary Customization on the AP invoiceContent Is it possible to do a customization on the AP invoice to validate certain fields and making some fields required based on…Mohammad Alhindawi 48 views 1 comment 2 points Most recent by Mauricio Chavarry-132851 Reporting and Analytics for SCM
-
Need A Report To Find Out The PR Is Pending With Whom And Its HistoryContent We are looking for some SQL query to find out the requisition is currently pending with whom and what is the history of the approval To achieve this requirement …Koteswararao Yenikepalli 43 views 1 comment 4 points Most recent by Siva Kumar-71666 Reporting and Analytics for SCM
-
Need info on inventory adjustment for all material transactionsSummary Need info on inventory adjustment for all material transactionsContent Hi Experts, I am looking for any BI or OTBI reports to get inventory adjustment for all ma…