To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for SCM
Discussion List
-
Negotiation and Response RFQ TemplatesSummary Negotiation and Response RFQ TemplatesContent All, What is the difference between Negotiation and Response templates for RFQ templates from Fusion procurement. h… -
How to obtain xml for Supplier Negotiation PDF ReportSummary How to obtain xml for Supplier Negotiation PDF ReportContent Hi All When I look at the bip template layout for Supplier Negotation PDF Report it is not linked to…User_2025-01-31-15-11-25-562 261 views 2 comments 0 points Most recent by Melissa Carrick - Oracle-Oracle -
How to Join RA and RCV Tables to get Dropship Order details in Oracle cloud R13 18bContent Hi , I am trying to create a BI report , where I want to have all receipt and AR invoice information for a DropShip Order. I am trying to find some link between …
-
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…
-
How to find the technical name of a field in Oracle Fusion Cloud ModulesSummary Building OTBI Report - want to make it easier to choose the field I needContent When building an OTBI report, most of the battle is trying to find the exact fiel… -
Can a SaaS BI Report fetch data from PaaS datastore?Summary Can a SaaS BI Report fetch data from PaaS datastore?Content Hi, We have a custom screen in VBCS which stores data in a table. We intend to customize the PO Print…
-
How to Identify Physical table name for EGO_ITEM_EFF_B tableSummary How to Identify Physical table name for EGO_ITEM_EFF_B tableContent Hi all, I am using Oracle BICS Data Sync to get data from Oracle Fusion SaaS (Product Hub mod…
-
Cost - Item Cost Real Time subject area refresh questionSummary How long it will take to refresh the data in the real time subject areasContent Hi Team, i would like to know how the real time subject areas will refresh. The r…
-
Item issuance report with CostSummary Item Issuance report required with Cost.Content Hi, Is there any report for Inventory issuance including the Cost ( Item list price * Quantity issue ) Month or w… -
R13.19A OTBI Direct Database Query Privilege ChangeSummary In R13.19A OTBI direct database query has been disabled by default. To prevent reports generating system errors, BI Administrator can modify BI privileges to rev… -
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 … -
Link between DOO_HEADERS_ALL and INV_PICK_SLIP_NUMBERSContent Hi All, We need a header level information for these tables 1) DOO_HEADERS_ALL and INV_PICK_SLIP_NUMBERS 2) inv_transfer_order_headers and INV_PICK_SLIP_NUMBERS …
-
Combining Purchasing and Negotiation Subject AreaSummary Combining Purchasing and Negotiation Subject Area, does not combine join correctly.Content Hello, I want to combine Purchasing Real Time with Sourcing Negotiatio…
-
Changing date format from 2018-07 to Jul-2017Summary Changing date format from 2018-07 to Jul-2017Content ello, What is the syntax to change from Time Dimension Month Code from 2018-07 to Jul-2017. When I try to ch…
-
Sales Order EFFs not showing up in OTBISummary Sales Order EFFs not showing up in OTBIContent Hi Experts, We have created few EFF in the Sales Order Header (with BI enabled), those EFF are not showing up in t… -
Report in Different LanguageSummary Reports in different languageContent Hi All, I am having one requirement in which I need to display the report in different language as per the customer site. fo…User_2025-01-31-19-49-50-009 51 views 3 comments 0 points Most recent by Phanindra V Gollapalli-Oracle
-
OTBI Training courses?Summary Does anyone know if Oracle offers any OTBI courses, or have any planned?Content Hi guys Unable to find anything looking remotely suitable on the education page, …
-
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet Content This spreadsheet is published by Oracle OTBI Development. Release: 26B…
-
New OTBI Help Landing PageSummary Introducing a brand-new OTBI Help Landing PageContent This e-mail is sent by Oracle OTBI product management. Starting with Release 13.18.10, a brand-new OTBI Hel…
-
Need SQL script for Return sales orders information in Oracle ERP cloudSummary Need SQL script for Return sales orders information in Oracle ERP cloudContent Hi Experts,I am looking for sql code to Return sales orders information in oracle …
-
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…
-
Report for tobe PutAway ReceiptsSummary Report for tobe PutAway ReceiptsContent Hi All, How can we generate a report which shows all the Receipts pending for PutAway or all the Receipts pending for Ins…
-
Opening Analysis from Dash Board not showing export optionSummary Opening Analysis from Dash Board not showing export optionContent Hi, I have created Dashboards with analysis, but when I am opening analysis from dashboard it i… -
How to get some output from the standard reports for SCM?Content Hello, we are trying to get some outputs from the standard reports that are provided in the list: http://www.oracle.com/webfolder/technetwork/docs/reports/r13/Su…
-
How to get inventory reports?Summary How to get inventory reports?Content Hello, we would like to get the following reports: - List of items per inventory organization with attributes. - Structures …User_2025-01-30-21-34-16-665 138 views 3 comments 0 points Most recent by User_2025-01-30-21-34-16-665
-
I want to create costing reportSummary Costing report requiredContent I want to get UNIT_COST,SUM OF ON_HAND_QTY with ITEM_CODE and its ITEM_DESCRIPTION
-
SCM reportingSummary Custom reports builtContent Our customer is using SCM and is not very pleased with the seeded reports in Oracle. Reports they are looking for are for example the…User_2025-01-28-02-43-26-951 158 views 6 comments 5 points Most recent by Mirza Muhammad Mohsin Baig
-
Total Purchases for Tier I SuppliersSummary I need to create an analysis that shows total purchases for specific suppliers.Content I need to create an analysis that shows purchase order line details such a…User_2025-01-28-00-30-46-187 49 views 1 comment 0 points Most recent by User_2025-01-28-00-30-46-187
-
Analysis & Query - for PRs history or apprvoal levelSummary Need to develop analysis to see the approval status and history of certiain PRContent Hi, I am trying to get the catalog or query to develop the analysis and rep…Farooq Syed, CPA, PMP, CISA, TOGAF 66 views 3 comments 2 points Most recent by Koteswararao Yenikepalli
-
How to set up JNDI connection (BI Publisher)Summary We are not able to configure JNDI connection since we do not know what data source information to populate, more specifically for field 'JNDI Name'