Inventory
Discussion List
-
Physical Inventory Adjustment ReportHello, Has anyone created a Physical Inventory Adjustment report for Oracle Fusion? We're on version 23A. Any guidance on the query would be appreciated. Thank you, JuliaJulia Looi 12 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM -
Infolets Receipt line: need to extract the querySummary: I need to extract the query under the infolets "Receipt Lines". Is it possible? Otherwise, how can I extract the lines in awaiting receipt, awaiting inspection …Giuseppe Galluzzo 12 views 1 comment 0 points Most recent by Giuseppe Galluzzo Reporting and Analytics for SCM -
Access to Inventory Subject Areas for Inventory OTBI AnalysisHello, According to this document: https://docs.oracle.com/en/cloud/saas/supply-chain-management/22d/faosm/Inventory--Inventory-Transactions-Real-Time-SA-36.html#Invento…
-
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…
-
Need a way to create OTBI for Available to transact quantity in Inventory ManagementSummary: We are trying to create a OTBI to report 'Available to Transact' on hand quantity. However, we dont find this field in any OTBI under Inventory Management. Any …Nakul Buradkar-Oracle 31 views 2 comments 1 point Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM
-
How can I identify Items which have common Structure with another item in different org?Summary: Goal is the extract list of item with with common structure. We have gone through the two subject areas below elated to Item Structure but did not find any comm…
-
Seeded pick slip report submitted from inventory UI in wrong languageSummary: Content (required): 1- Log in to Oracle in French (All the settings in French in manage user preferences) 2- Go to manage pick slip screen in the inventory modu…
-
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 26 views 5 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
How to Remove Edit Option for OTBI Report.Summary: Content (required): Hello Friends We have made a custom role and added duty role -"Receiving Transaction Analysis Duty". Assigned this role to a user. But I do …Ashish_Kumar 41 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for SCM -
Replicate Data in FusionSummary: We are looking for a tool or an app that can help us extract data from Oracle Fusion (Financials/SCM). Content (required): We currently create BIP reports to ex…sanjam1130 1 view 1 comment 0 points Most recent by Sahithi Kolasani-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 11 views 0 comments 1 point Started by MANISH KUMAR-145787 Reporting and Analytics for SCM
-
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 34 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 7 views 5 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM
-
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 165 views 8 comments 4 points Most recent by Sushan Peiris 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 24 views 5 comments 4 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
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 321 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 34 views 6 comments 1 point Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Lot Experation Date Field in Subject AreaSummary Looking for the Lot Experation Date fieldContent I am using the Inventory - Inventory Transaction Real-Time subject Area. Under Lot there is no Expiration Date f… -
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…Rohit Kumar-266502 184 views 1 comment 0 points Most recent by Rohit Kumar-266502 Reporting and Analytics for SCM
-
Not able to find Source Locator- Inventory Transaction Real Time Subject AreaContent Hi Team, I am new to Analytics reporting & need help to create a report with Below Scenario: 1) We need a report where Transaction Type = 'Subinventory Transfer'…Mayank Pande 12 views 2 comments 2 points Most recent by Sahil Makhiza 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 20 views 2 comments 4 points Most recent by Rohit Soni-259808 Reporting and Analytics for SCM
-
Report 'Receipt Accrual Balances'Summary Report similar to 'Adjust Receipt Accrual Balances' menuContent We want a report that shows the same information as you can see in the 'Adjust Receipt Accrual Ba… -
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…Bilalemail 40 views 8 comments 4 points Most recent by Cesar Gonzalez-111557 Reporting and Analytics for SCM -
Where is "Available to Reserve" fact in BISummary Where can "Available to Reserve" fact be located in BIContent Could you kindly advice where in BI is "Available to Reserve" fact located in? So far none of the f…Jonathan Chan gmg 26 views 1 comment 2 points Most recent by User_LDHCN Reporting and Analytics for SCM