Business Intelligence - BI
Discussion List
-
Which table we can use for every day's inventory quantity onhandHi team, We are using cst_del_onhand_valuations table to get quantity_onhand and inventory valuation for our customized inventory balance BI report. But this table is a … -
Movmnt of Stock frm 1 Inv Org to Other Such That Its Current Bucket in Inv Aging Reprt isn't ChangedSummary: Business user wants to transfer two items (one item has 1 quantity and the other item has 2 quantities) from one of their inventory orgs to the other in such a …
-
Assistance Required for Converting OTBI Query to Oracle Standard TablesSummary: I am reaching out to seek your expertise regarding the conversion of an OTBI query subject area into Oracle standard tables. Specifically, I am looking to under…Guthi Mallikarjun 18 views 3 comments 0 points Most recent by Guthi Mallikarjun Inventory Management
-
Views created for the inv_material_txns table?Hi Experts, I was looking to tune my BI Report Query. I have used inv_material_txns table frequently in the query, I wanted to understand if there is any view created fo…Divyam Sachan 2 views 1 comment 0 points Most recent by Arun Yadav - Support-Oracle Inventory Management
-
Receipt Traveler ReportSummary Receipt Traveler Report is not getting submittedContent We are integrating with RFSMART for Receiving. Though Manage Receiving Parameters has "Print receipt trav…User_2025-02-10-18-21-36-111 49 views 2 comments 0 points Most recent by ArtiomSpinu Inventory Management -
DFF Value is not available in the BI Subject Areas - INV_LOT_ATTRIBUTESSummary: Do not see new DFF created in 'Inventory - Inventory Balance Real Time'. Please see attached. Content: Name Lot Attributes Flexfield Code INV_LOT_ATTRIBUTES App… -
Stock on hand based on a past date or time intervalSummary See on hand stock based on a past date or time interval filterContent Hi. There is any report or way to get in the stock on hand based on a past date or time int…
-
On-hand quantity on a historical dateContent We have a requirement where we need to get the inventory on-hand quantities of items by day @ 11:59:59pm since Jan 1, 2021. Is there a standard report that can b…User_2025-02-11-12-16-08-273 478 views 3 comments 2 points Most recent by Becca Edwards Inventory Management
-
Is it possible to schedule a BICC job to run twice in a day? If yes, how can this be achieved?Summary: My goal is to schedule a BICC job to run twice in a day but turns out its not possible to have 2 active schedules for a job Content (please ensure you mask any …Neha Aishwarya 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Review Item Supply and DemandSummary: Hi Team, is it possible to extract all the details from "Review Item Supply and Demand" View like all the fields : date - document type - document number - sour…
-
Is there an SQL statement or Analytic in OTBI for Interorg Transfer reportingSummary: Our business users are printing out Interorg Transfers, but once the Transfer is saved the Shipment Number field is "Grayed Out" and this make reading it on the…
-
Supplier Lot to Internal Lot Report in Business IntelligenceSummary: Need to view Supplier Lots with our Internal Lots for Inventory On Hand Balance. We work with Contract Manufacturing, so keeping track of their Lot with our own…
-
Table Column not available in BICC PVO FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InventoryLocatorThe column LOCATOR_NAME from table INV_ITEM_LOCATIONS is not available in the BICC PVO FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InventoryLocatorExtractPVO.
-
Calculation logic required for Available to Transact and Available to ReserveSummary: We have a business requirement to show the On-hand Quantity, Available to Transact and Available to Reserve on a Part request screen. We need the Available to T…Sorujit Das-125523 177 views 10 comments 1 point Most recent by Bhavani Rikkula Inventory Management
-
PVO unavailable for the table INV_PICK_SLIP_NUMBERSI was looking for a PVO for the table INV_PICK_SLIP_NUMBERS, but figured that there's no PVO available for the table. Is there a way I can create a PVO for the table INV…
-
Which criteria (OTBI Subject Area) need to create a report for identify slow moving itemSummary: Which criteria (OTBI Subject Area) need to create a report for identify slow moving item Content (please ensure you mask any confidential information): How to i…
-
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.
-
What role is needed to run "Item Txn with Average Cost report".Summary: What role is needed to run "Item Txn with Average Cost report". Customer don't want to give user same role as store manger, because it will have a licencing imp…
-
Not able to successfully send rest api post request to generate BI publisher report in Fusion CloudSummary: I'm trying to make a post-call to generate a BI publisher report. The fusion cloud rest api is returning RequestId -1 despite the request was fulfilled with 201…
-
Deep link for lines to be PutAwaySummary: I have one report that allows all the receipt lines to be PutAway. I would like to click on Receipt Number and then the window of the PutAway will be open using…Giuseppe Galluzzo 51 views 4 comments 0 points Most recent by Lynn Warneka-Oracle Inventory Management
-
Is shipment Hyperlink is possible in BIP reports.Summary: In the BIP report, Once the user clicks on the shipment number it should take to inventory Manage shipment page in display mode. Please confirm . .Content (plea…KOTTHURI ASHOKBABU 22 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri 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…
-
Adding a column similar to the DFF to a table in the UISummary: The review completed transaction user interface allows us to export every column to an Excel file. The customer asks that the review completed transaction user …Tharushi Sathsarani 32 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Inventory Management
-
How to Identify dashboard reports / infolets from Oracle Fusion UI ScreenSummary: Identify dashboard reports / infolets from Oracle Fusion UI Screen Content (required): Hi, I have a requirement to identify the dashboard reports / infolets fro… -
Is there a report or SQL that will show all adjustments of stock counts for items since inceptionSummary: There will be an audit soon in our client organization, is there any seeded report or SQL that will show all adjustment of Stock count done in an Inventory sinc…
-
Can I set the parameter to require in Print Movement Request Pick Slip Report ESS job?Same as question. I am going to set From Movement Request and To Movement Request these two parameters to require. Any idea? I can't edit the row :( -
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…User_2025-02-06-14-16-15-309 42 views 5 comments 0 points Most recent by Manishsrf7 Inventory Management
-
Unable to find BICC PVO for Item EFF informationSummary: Unable to find BICC PVO for Item EFF information, we are looking for this data to share the extract with a Third Party. Content (required): Version (include the…Sagunthala Anbazhagan 160 views 1 comment 1 point Most recent by Magesh Kesavapillai-Oracle Product Master Data Management -
Print ZPL labelsSummary Print ZPL labelsContent Hi, We have a requirement to print ZPL labels on non-local Zebra printers. The availability and configuration of a Zebra printer (using a…Fabricio Reis 214 views 1 comment 0 points Most recent by Fabricio Reis Reporting and Analytics for ERP