Business Intelligence - BI
Discussion List
-
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…
-
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…Becca Edwards 86 views 8 comments 0 points Most recent by Prasanth Senthivel-Oracle 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 2 views 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 108 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 52 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 21 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…
-
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 136 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 222 views 1 comment 0 points Most recent by Fabricio Reis Reporting and Analytics for ERP
-
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…
-
Automatically transfer goods from Staging sub-Inventory to Storage Sub-Inventory in Oracle fusionSummary Automatically transfer goods from Staging sub-Inventory to Storage Sub-Inventory in Oracle fusionContent Is it possible to automatically transfer goods from the …Pragyanand Das 38 views 2 comments 0 points Most recent by ElSayed Fouda.-Oracle 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…
-
DFF on movement request in the reportSummary DFF on movement request in the report not visibleContent User have created some DFFs in Movement Request line and it have value, but when run Print Movement Requ…
-
Shipments Document SequenceSummary Shipments Document SequenceContent Hello, How can I set up or define a sequence for my shipment documents based on the business unit? Thank you. Version Oracle F…Mohammad Alhindawi 59 views 1 comment 0 points Most recent by Lynn Warneka-Oracle Inventory Management