OTBI
Discussion List
-
Is it possible to see a list of immovable inventory in OTBI or in the standard functions?Is it possible to see a list of immovable inventory that has not moved from subinventory for more than a certain period of time in OTBI or in the standard functions?Takaaki Kozaki-Oracle 12 views 2 comments 0 points Most recent by Regie Mercado Inventory Management -
Physical Inventory Adjustment ReportSummary: Physical Inventory Adjustment Report Content (please ensure you mask any confidential information): Is there any Seeded report to view the adjustment made durin… -
How to restrict the List of Inventory orgs from LOV on reportSummary: We have custom report for Inventory on hand. User has to select the Inventory org as a LOV Parameter. How do we restrict the list of Orgs in LOV? Currently any …Shrikant Bhavsar 11 views 1 comment 0 points Most recent by Shabbir M Tahasildar Inventory Management
-
Tabla de Oracle Cloud para sacar el bill-to y ship-to location del proveedorDears , Please help me with the Oracle Cloud Table to get the bill-to and ship-to location from the supplier.
-
MATERIALS REQUIREMENTHello and good day! Dearest Oracle Community friends, I am trying to create an OTBI for materials requirement below, would anyone know how to create the formula for tota… -
Economic production quantitySummary: Hello All, One of my customer follows the Quote to Cash process for building Configure to Order (CTO) items. They do not manufacture, but assemble products base…Vishnuvarth Subramanian-Oracle 21 views 1 comment 0 points Most recent by Radhakrishnan Angappan-Oracle Manufacturing
-
OTBI REPORT FOR TRACEABILITYHello and good day! Dear Oracle friends, If I will create an OTBI for Traceability, what are the possible subject areas and data fields I need? Hope to hear from the com…
-
Missing column in Subject Area for ReservationsSummary: Missing column (Subinventory) in Subject Area for Reservations Content (please ensure you mask any confidential information): I am trying to create a report, ba…IdK1992 2 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to get Miscellaneous Transaction Serial Numbers range if the serial numbers are consequetive?Summary: I have some report requirement to get the transaction serial numbers as: serial_from, serial_to, and range. The only source table I have is the serial number on…
-
SHARING OF OTBI REPORTHello and good day! Dear Oracle community friends, If a user has limited access to other modules (e.g. Procurement and Inventory Management users) and one user in that m…Regie Mercado 42 views 12 comments 0 points Most recent by Regie Mercado Reporting and Analytics for SCM
-
Is there any REST API to get the details on Outbound Shipment RequestSummary: Is there any REST API to get the details on Outbound Shipment Request
-
Combining order management & Cost accounting subject area not giving data in OTBI reportSummary: How to combine order management & cost accounting subject areas in OTBI report? Content (please ensure you mask any confidential information): We have an OTBI r…Manisha Shrivastava 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
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 29 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 381 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 13 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 21 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 41 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 92 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 403 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 …