Inventory
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… -
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 33 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 29 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 25 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 2 views 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 2 views 0 comments 0 points 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 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 8 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 62 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 16 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 198 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 25 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 108 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 13 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 21 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 42 views 8 comments 4 points Most recent by Cesar Gonzalez-111557 Reporting and Analytics for SCM -
Suing ASBN on In Transit OTBI ReportSummary a)ASBN with 1 line received , 1 not disappear from In Transit report b) Possibility to add Received Quantity (Receiving In-Transit Advance Shipment Not. Real Tim…Bernd Borstelmann-203269 6 views 0 comments 0 points Started by Bernd Borstelmann-203269 Reporting and Analytics for SCM
-
Does anyone know if there is a Report to track the unused items in our Warehouse?Summary We need to get rid of unused products and can't find a report for unused items (or for used items turnover)Content Is there a standard turnover report for Invent… -
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 27 views 1 comment 2 points Most recent by User_LDHCN Reporting and Analytics for SCM
-
Relate EGP_STRUCTURES_B/EGP_SYSTEM_ITEMS with Catalogue Categories.Content Hi. I made a BOM explosion using EGP_STRUCTURES_B and now I need to filter out some results based on catalogue properties of the items. I did not find meaningful…Gabriel Alejandro Zorrilla 30 views 0 comments 0 points Started by Gabriel Alejandro Zorrilla Reporting and Analytics for SCM
-
Why transfer number is blank with Reports for Supply Requests?Content When I create a Supply request analysis in BI the transfer number is blank
-
Complex Inventory Stock Ageing Report by Original PO Receipt DateSummary Require feasibility check on a complex Inventory Stock Ageing Report (Across Multiple Inventory Orgs)Content We have an unique report requirement for customer re…Balachander G-Oracle 24 views 2 comments 0 points Most recent by Balachander G-Oracle Reporting and Analytics for SCM
-
Access PermissionSummary i need to give one user read only for Purshase and Sales OTBI reportContent Hello i have one use , this user is not have license to Order management module and p…Mahgoub S.Mohamed 27 views 3 comments 0 points Most recent by Karina Ogata Reporting and Analytics for SCM -
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 48 views 8 comments 0 points Most recent by Yogesh Nemchand Reporting and Analytics for SCM