Business Intelligence
Discussion List
-
Print Inventory Labels Custom Labels (Print Item Label and Print Location Label)Hello, Is it possible to use custom versions of the Print Inventory Label ESS, either Print Item Label or Print Item Locations? Our logistics operation is facilitated by… -
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…
-
BICC PVO for POR_BROWSE_TREESSummary: Do we have a PVO available for the table POR_BROWSE_TREES? Content (please ensure you mask any confidential information): Version (include the version you are u…
-
Roles and Privileges for Item "view only" and planning tab "editable"Hello All, Hope this post finds you well. We have a requirement in current project where we need to create a role for items where Manage items page will be "view only" w…Lucky Sharma 22 views 5 comments 0 points Most recent by MANALI BISWAS-Oracle Product Master Data Management -
Sync EGO_ITEM_EFF_B to PaaSHi, we have 12M records in ego_item_eff_b table, but as per Oracle we don't have PVO to bring the data to PaaS using the BICC. Can you please let us know whats the best …Sateesh Lakkireddy 25 views 3 comments 0 points Most recent by Hari Kurra-Oracle Product Master Data Management
-
Prevention of Custom Extension Field mismatch in regard to different Instances for BICCSummary: Since Custom extension fields may differ from Instance to Instance is there a way to prevent this on BICC Content (please ensure you mask any confidential infor…Jude David 22 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Setup problem Can't see the catalog contentIt is not possible to view the category name, nor create it, and we are also unable to extract this information via query. When trying to create the Category name within… -
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… -
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…
-
Where can we define the numbering of the pick slips?Hello, when creating a movement request for example, and running the process to run the movement request pick slip report, the system is generating automatically the num… -
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
-
Vendor return reportSummary Availability of vendor return reportContent We would like to a printable template (like PO's) for returning items to vendors. We have got the confirmation of Ora…
-
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 … -
We are unable to process RMA receipts when line number is having decimal valueSummary: FA Application-Module-- OM REST-API (if using)--/fscmRestApi/resources/11.13.18.05/receivingReceiptRequests Content (required): Intermittent : (Yes/No)-- Yes , …
-
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…
-
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
-
Suggestions in Return to Vendor processSummary Suggestions in Return to Vendor processContent Hi All, While responding to a High-Tech Contract Manufacturer Client RFP, looking for suggestions to provide solut… -
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…
-
Need Table Information for MTL Transaction AccountsSummary Need Table Information for MTL Transaction AccountsContent Hi Team, We are trying to find the corresponding table name for MTL_TRANSACTION_ACCOUNTS in Fusion.Ple…Siva Kumar-Oracle 296 views 4 comments 0 points Most recent by Siva Kumar-Oracle Inventory Management -
Transaction Date on receipt what database table stores this info?Summary Transaction Date on receipt what database table stores this info?Content We back-date receipts on PO's and I can't find the transaction date in any receiving tab…Michelle Haynes 166 views 3 comments 0 points Most recent by Lynn Warneka-Oracle Inventory Management
-
PO Received and Remaining Quantity reportSummary Is there any standard report for PO Received and Remaining Quantity reportContent Looking for Purchasing PO PO Received and Remaining Quantity report Version 19B
-
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
-
Create Pick Wave is not releasing all the lines for Transfer Order after 18c upgradeSummary Create Pick Wave is not releasing all the lines for Transfer OrderContent Recently we have 18c upgrade and post upgrade, we have noticed that Create Pick Wave is… -
Job Set with multiple Jobs in itSummary Unable to save Job Set with multiple ESS job: WshPickSelectionListSRSJobContent Hi, Can someone help if any one faced an issue where in we cannot save Jobset wit…Atul Kumar-93431 65 views 1 comment 0 points Most recent by Lynn Warneka-Oracle Inventory Management
-
How to create an Inventory On Hand Balance report using OTBISummary On Hand Inventory Balance report using Oracle Transactional Business IntelligenceContent We've had some requests on how to put together an Inventory On Hand Bala…Lynn Warneka-Oracle 259 views 2 comments 5 points Most recent by Joseph DiPrinzio Inventory Management