OTBI
Discussion List
-
How to query the results of all generated cycle countsSummary: Our Client requires to consult through UI or some type of report the results of the all cycle counts that it has generated in order to obtain inventory reliabil…Adriana Rivera 18 views 1 comment 0 points Most recent by Adnan Siddiqui-Oracle Inventory Management
-
What values to pass to lexical references to Physical inventory Tags Data modelSummary: We have customized the Physical Inventory Tags data model and report. Then we tried to modify a column. However, I don't know what values to pass to the 4 lexic…
-
SQL QUERY for Inventory Pending TransactionsSummary: Does anyone have a sql to query pending inventory transactions? Content (please ensure you mask any confidential information): When there are many inventory org…Adriana Rivera 90 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Inventory Management
-
Inventory OTBI Report is working for some users and giving error for otherSummary: I have created OTBI report under the following subject areas (Receiving – Receipts Real Time) and (Receiving – Transactions Real Time). Using Sandbox page integ…
-
OTBI Report not showing item with Zero On-HandSummary: OTBI Report not showing item with Zero On-Hand Content (please ensure you mask any confidential information): Team, We have developed OTBI report using subject …Akancha Sinha 16 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Inventory Management
-
Inventory Reservations Query/ReportSummary: Need a report of the information seen in Manage Reservations and Picks (Item, Reserved Quantity, Document Number, Document Line Number) Content (please ensure y…
-
Finding interface values in final tablesHello everyone, can anyone help me? I'm having trouble identifying some fields that are loaded into the interface table to inventory transactions (INV_TRANSACTIONS_INTER…Ivan Torres NTTDATA 22 views 1 comment 0 points Most recent by Adnan Siddiqui-Oracle Inventory Management
-
how to add a fiscal document status field in OTBISummary: Hi, we need to add the field fiscal document status from shipping forms to OTBI, there is a away to do this? Content (please ensure you mask any confidential in…Alex Pagliarini - Ninecon 1 view 1 comment 0 points Most recent by Vignesh Rajendhiran-Oracle Inventory Management
-
Inventory Valuation OTBI Report Shows Double EntrySummary: An OTBI Report is created for Inventory Valuation according to client's need of parameters. After running the report, output shows double/duplicate entry for Co…
-
How to capture Movement Request Requested Quantity in OTBISummary: Need to capture Movement Request Requested Quantity to OTBI, we have tried with original transaction quantity column in Inventory - Inventory Transaction Real T…Navindu Amarasinghe 32 views 3 comments 0 points Most recent by Navindu Amarasinghe Inventory Management
-
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 90 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 302 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 …
-
How to create a report/Analysis to show Receipts pending for Put AwaySummary: How to create a report/Analysis to show Receipts pending for Put Away Content (required): Version (include the version you are using, if applicable): 23A Code S…Amol Pachpande 363 views 7 comments 2 points Most recent by Adnan Siddiqui-Oracle Inventory Management
-
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…
-
Query to retrieve Trade Operation and corresponding PO detailsSummary: Content (required): Hi, There is a requirement to create a report that displays the following columns; Trade Operation number Trade Operation Name Created By Us…
-
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…
-
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 137 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 column
-
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 50 views 1 comment 0 points Most recent by Piyush Potdar-Support-Oracle Inventory Management