SQL
Discussion List
-
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 338 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 62 views 1 comment 3 points Most recent by User_2025-02-06-00-08-33-553 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 129 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 -Oracle 47 views 0 comments 0 points Most recent by Mirza Nasir Beg -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 52 views 1 comment 2 points Most recent by User_2025-02-04-07-16-12-621 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 52 views 1 comment 4 points Most recent by User_2025-01-30-02-57-36-931 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…