SCM
Discussion List
-
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin… -
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. …Ramamurthy Shankarachetty-Oracle 6.2K views 37 comments 33 points Most recent by Tracy C Reporting and Analytics for SCM
-
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 34 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM -
Reports and Analysis tab is blank in SCM Work areaSummary: The reports and Analysis tab is blank in all Work areas of SCM Content (required): The reports and Analysis tab is blank in all Work areas of SCM like Purchasin…
-
How to add the Supplier Site Attribute information to the Requisition PDF ReportSummary: I want to add the Attribute Information from the Supplier Site to the Requisition PDF Report. Based on the attachment from Doc ID 2595071.1 (RequistionPDF Attri…Hendra_innopia 12 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for SCM
-
Error while loading Sales order through FBDISummary: Getting error while loading sales order. This error occurs in source order 1103-F65660TEST, on source order line 1, source item name 846581, source item 300,000… -
work order fetch based on asset number and asset work center nameSummary: Hi Experts I want to create a BIP report to fetch work orders with parameters asset number, asset work center name, item number and work order work center name.…Sharmava 3 views 1 comment 0 points Most recent by Aravindan Sankaramurthy -Oracle 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 47 views 4 comments 1 point Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
What is the deep link URL for Procurement receipts?Summary: We want to create an action link on OTBI report - when the user clicks on the receipt number, it should open up in the application ( Procurement - My receipts) …Astrid Ferrao-Oracle 26 views 2 comments 0 points Most recent by Astrid Ferrao-Oracle Inventory Management
-
What DFF's or Flex fields are we able to bring into to OTBISummary: Looking for documentation about which dimension in OTBI we can extend with flex fields. We found in finance module that not all flex fields were eligible to com…amy hardtke 4 views 3 comments 0 points Most recent by Abhijit Joshi -Oracle Reporting and Analytics for SCM -
Need to get a report for PO's where we can filter by BU'sSummary Need to get a report for PO's where we can filter by BU'sContent Hello, Grateful if you can help on how to get a list of all GRN's for Received Shipments for a S…Yogesh Nemchand 27 views 5 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
Request to share solution to display SO Header attachment URL on BIP report output and download itSummary: We have a requirement to build a custom BIP report in Oracle Cloud ERP (SCM Module). If there is any attachment at Sales Order Header Level, then we want to get…Amit Sutar 13 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
FBDI Import -Items (FBDISummary: High volume data in Products while loading Inventory Orgs Content (required): Hi Folks, We are in process of Loading Items in our projects we have 11 lakh recor…
-
LAST_UPDATE_DATE incorrect for PO_DISTRIBUTIONS_ALL - Creates issue for BICCC incremental loadsSummary: Has anyone faced th issue where the LAST_UPDATE_DATE is not being updated for PO_DISTRIBUTIONS_ALL/PurchasingDocumentDistributionExtractPVO even when the data i…Jahnavi-Oracle 6 views 0 comments 0 points Started by Jahnavi-Oracle Reporting and Analytics for SCM -
Need to call "Print Movement Request Pick Slip Report" from Movement Request pageSummary:Need to call "Print Movement Request Pick Slip Report" from Movement Request page Content (required):Need to call "Print Movement Request Pick Slip Report" from …MANISH KUMAR-145787 2 views 0 comments 0 points Started by MANISH KUMAR-145787 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… -
Lot Number received based on POContent Hi Freinds, I am trying to get a report based on Analysis having two subject area, Inventory-Inventory Transactions Real Time and Procurement-Purchasing Real Tim…Ashish_Kumar 17 views 3 comments 0 points Most recent by Wayne Aus-Oracle Reporting and Analytics for SCM
-
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsh…
-
SCM roles to create OTBI reportSummary list of roles is requiredContent Hi All, Kindly, I want to use OTBI to create reports specifically in SCM. I need the list of roles that facilitate this kind of …Morad Alshammari 10 views 5 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM
-
Print ZPL labelsSummary Print ZPL labelsContent Hi, We have a requirement to print ZPL labels on non-local Zebra printers. The availability and configuration of a Zebra printer (using a…Fabricio Reis 5 views 1 comment 0 points Most recent by Fabricio Reis Reporting and Analytics for SCM
-
Review Receipt Accounting Distributions Details OTBI ReportSummary How to pull OTBI data for details shown in Review Receipt Accounting Distributions user interfaceContent Does anyone know how to pull Review Receipt Accounting D…
-
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…Sushan Peiris 51 views 8 comments 4 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Logged in UsersSummary List of Users logged into the ApplicationContent Team, Trying to find a way to pull a list of current users that are logged into the system. Any thoughts? Thanks…Ir-Oracle 16 views 2 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM
-
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 48 views 6 comments 4 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM
-
Tables regarded to Manage Item Quantities page on Oracle Inventory ModuleContent Hello all, I need to know the tables which contain the data related to the Manage Item Quantities page on Oracle ERP. I need to capture some fields from the page…Sushan Peiris 19 views 5 comments 4 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Need Query to status of sales order import using FBDIContent Hi All, I am importing sales order using FBDI and i need a report which will pull import status(Imported or error),source transaction number,error message in cas…
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 179 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
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 26 views 6 comments 1 point 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 22 views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made …Sushan Peiris 357 views 1 comment 2 points Most recent by Sushan Peiris Reporting and Analytics for SCM