OTBI
Discussion List
-
revision vs lot for inventory transactionsSummary: What are the pros/cons for using revision functionality in oracle vs using lots? Content (required): Hi, We have a requirement to track item revisions in certai… -
Is there a report or SQL that will show all Miscellaneous transaction carried out on Inventory ItemsSummary: There will be an upcoming audit in our client's organization. Is there a seeded report or SQL query that can display all Miscellaneous transaction reports condu… -
Inventory Aging ReportSummary Any Custom or Standard Inventory Aging Report available in FusionContent Looking for Inventory Aging report with 1-2, 3-4,5 Years Buckets data for the inventory … -
Is there a OTBI Subject Area for listing the Movement RequestsSummary: Content (required): We need to get a list of all the Movement Requests along with their status. Is there a OTBI Subject Area for that? Version (include the vers… -
Unable to create a receipt in my receipts?Summary Unable to create a receipt in my receipts?Content Hi all, Unable to create a receipt in my receipts? PO created through work order(WO). Thanks, Dev Thota. Versio…Dev Thota 93 views 8 comments 2 points Most recent by Poorna Chandra Rao. Garlapati Inventory Management -
How to create an OTBI report to show SO to AR flow?Summary: How to create an OTBI report to show SO to AR flow? I need SO Line info like Status and AR transactions details. Content (required): Version (include the versio…
-
How to identify slow moving items in Oracle fusion inventorySummary: Hi All, How to identify slow moving items in Oracle fusion inventory. Is there any report available for slow moving items ? Content (required): Version (include…Mangesh Shastri 421 views 5 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Inventory Management
-
Using Country of Origin field in Inventory TransactionsSummary: We have disabled the checkbox for tracking inventory by Country of Origin in Organization Parameters. But the Country of Origin field is available on receiving …
-
Infolets: need to extract the query of the Receipt Lines infoletsSummary: Could I extract the query under the "Receipt Lines" infolets? I need to extract the same details about the lines to be received, to be inspected and to go to Pu…Giuseppe Galluzzo 31 views 2 comments 0 points Most recent by Giuseppe Galluzzo Inventory Management
-
How to View the Oracle Inventory Seeded Infolets And Get The Queries Behind Them?Summary: How to view details of Inventory Management seeded Infolets? Content (required): We need to edit/view details of oracle seeded infolets, currently we are unable… -
Oracle Cloud Inventory KPIs(Key Performance Indicators)Summary List of KPIs in Oracle Cloud Inventory management ModuleContent Hi everyone, Could you please help to list out all the KPIs with short description which can be s…User_2025-02-06-14-16-15-309 42 views 5 comments 0 points Most recent by Manishsrf7 Inventory Management -
Net weight, Tare weight, Net weight UOM, Tare weight and Gross weight fields are not appear.Summary: Net weight, Tare weight, Net weight UOM, Tare weight and Gross weight fields are not appear in receiving window Content (required): Hi, As per 21D update this a…Navindu Amarasinghe 131 views 3 comments 0 points Most recent by Lynn Warneka-Oracle Inventory Management -
Supply Chain Operations DashboardSummary: We are looking for setup/configuration for accessing Supply Chain Operations Dashboard Content (required): We are looking for accessing Supply Chain Operations …Muhammad Tabrani 31 views 3 comments 0 points Most recent by Lynn Warneka-Oracle Inventory Management
-
MATERIAL TRANSACTION: REFERENCE SOURCE TYPESummary INV_GENERIC_DISPOSITIONS HAS NO DATAContent Hi All, I need to get the reference number for each transaction. like for example sales order and it is reference num… -
Do we have any Subject Area to capture Available Quantity to ReserveSummary Do we have any Subject Area to capture Available Quantity to ReserveContent Hi Experts, Do we have any Subject Area to capture Available Quantity to Reserve , I …Ghanshyam M-Oracle 51 views 6 comments 0 points Most recent by Ghanshyam M-Oracle Inventory Management -
Inventory Transactions short cut keysSummary which short cut keys can be used to accelerate the data entryContent Dear, I am looking for a shortcut key on the inventory transaction screen, for example, whil… -
Where can i find Good Receipt status in AnalysisSummary Where can i find Good Receipt status in AnalysisContent Hi I am trying to build OTBI Report for Invoice, po, receipt.... need to include receipt status columnUser_2025-02-11-08-59-18-251 28 views 1 comment 0 points Most recent by Sushan Peiris Inventory Management
-
How to restrict the user to use only primary or secondary UOM instead to select any UOM on miscellanSummary How to restrict the user to use only primary or secondary UOM instead to select any UOM on miscellaneous transaction screenContent Does anyone notice that by def…Kaleem Khan 83 views 1 comment 0 points Most recent by Piyush Potdar-Support-Oracle Inventory Management
-
Locator flag restriction issue with Create pickSummary Locator flag restriction issue with Create pickContent Dear, Locator restriction flags are enabled on item master, as this flags provide the flexibility to the u…
-
ITEM ISSUANCE WITH COST REPORTSummary This report including Item issance with cost details and accounts.Content Please find the attached Catalog file. unarchive the catalog in your OTBI reports.
-
Suggestions in Return to Vendor processSummary Suggestions in Return to Vendor processContent Hi All, While responding to a High-Tech Contract Manufacturer Client RFP, looking for suggestions to provide solut…
-
Sand Box published Cause Invenotry Management Page to crashSummary After publishing a sandbox I faced an issue that the Inventory Page is behaving abnormallyContent Hi guys, I was trying to add a analysis (infotile) using a sand…User_2025-02-04-19-25-35-076 46 views 3 comments 1 point Most recent by Ramprasad Swaminathan Inventory Management
-
Country of Origin - How to enableSummary I cannot see the "enable inventory tracking by country of origin"Content Hello, In 20A we expected to see COO (country of origin) as a new attribute in PIM or In…User_2025-02-04-16-34-29-464 155 views 2 comments 0 points Most recent by Pradeep - Adroit Inventory Management
-
SQL for duration of inspection requiredSummary Measure key metricContent SQL Guru's need some help figuring out what tables to get: For receiving, we want to measure the duration of a receiving task to captur…
-
How can get the average price per item from the OTBI or SQLSummary How can get the average price per item from the OTBI or SQLContent Hi, How can get the average price per item from the OTBI or SQL, we need the latest average pr…Farooq Syed, CPA, PMP, CISA 22 views 1 comment 0 points Most recent by Akancha Sinha Inventory Management -
Transaction Date on receipt what database table stores this info?Summary Transaction Date on receipt what database table stores this info?Content We back-date receipts on PO's and I can't find the transaction date in any receiving tab…Michelle Haynes 199 views 3 comments 0 points Most recent by Lynn Warneka-Oracle Inventory Management
-
PO Receipt related reportSummary PO Receipt details report including NotesContent Is there any Purchase order Receipt related report available with details and notes comments as per the attached…
-
Unable to generate lot numbers while receiving the POSummary Unable to generate lot numbers while receiving the POContent We have enabled the lot control at item level and created the PO. When trying to receive the PO from…