Business Intelligence - BI
Discussion List
-
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 … -
How to configure callback for BICC jobs using soap web serviceSummary: We are trying to trigger BICC job using SOAP webservice in OIC and once job is completed expecting to receive a callback which triggers another integration to p…
-
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…
-
Print Receipt Traveler ReportSummary: Does 'Print Receipt Traveler Report' ESS job auto trigger work when receipt is created from the Procurement > My Receipts (New) page? Content (please ensure you…
-
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 69 views 3 comments 0 points Most recent by Sentil Inventory Management -
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…
-
Is Incentive compensation is available in BICC. If yes, can I know the relevant PVO details for theSummary: Is Incentive compensation is available in BICC. If yes, can I know the relevant PVO details for the CN_TP_TRANSACTIONS_ALL table? Content (please ensure you mas…
-
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 22 views 8 comments 0 points Most recent by Guthi Mallikarjun Inventory Management
-
SQL Query to extract Item LocatorsSummary: SQL Query to extract Item Locators Content (please ensure you mask any confidential information): Hi - I wondered if anyone might be able to help please, with a…
-
Auto-Printing the Receipt after submittingClient Requirement: after creating the receipt and submitting it, the client wants to auto-print a custom report we have developed for him. is this functionality standar… -
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 …
-
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 1 view 1 comment 0 points Most recent by Arun Yadav - Support-Oracle 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 548 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 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.
-
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…
-
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 53 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 31 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…