Inventory
Discussion List
-
Email Both PDF and XML Format with Bursting QueryI have a custom packing slip report that is triggered off a customized scheduled process and the bursting query in the data model of my report handles the email output. … -
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… -
Update the code in Min Max Planning packageSummary: To update the code in the Min Max Planning package Content (required): Hello Gurus, In the Min Max ESS Planning ESS Job, it has an event trigger (before and aft…
-
please suggest database tables/how to calculate Available to reserve and Available to transact QtySummary: We want to fetch Available to reserve and Available to transact Qty based on lot details from the database tables. Can you please suggest the database tables/ho…KOTTHURI ASHOKBABU 28 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
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, Julia -
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…
-
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 45 views 2 comments 0 points Most recent by JULIANA CASSIANO REIS Reporting and Analytics for SCM
-
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 58 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 42 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 136 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 16 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 17 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 50 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 32 views 5 comments 0 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 80 views 5 comments 5 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 526 views 1 comment 4 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 123 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…Pdhogan 30 views 2 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Reporting and Analytics for SCM -
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 267 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 37 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 45 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 65 views 8 comments 4 points Most recent by Cesar Gonzalez-111557 Reporting and Analytics for SCM