BI Publisher Reports
Discussion List
-
How to create automatic receipts for expense items ?Summary: How to create receipts automatically for expense items ? Content (required): There is a requirement to create automatic receipts for expense items ? Without Sup… -
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…
-
Issue when trying to create a Custom ESS job from Standard ESS - Print Min-Max Planning ReportSummary: We are trying to create a Custom ESS Job By duplicating the standard ESS Job 'Print Min-Max Planning Report'. We were able to successfully create the Custom ESS…
-
Invoking REST API/SOAP in BIP for Fetching available to reserve and available to transactHi Team, We need to retrieve available to reserve and available to transact , but we've observed discrepancies when querying through SQL. Our goal is to achieve this via…
-
How to get Integration Status column from Movement Requests?Hi, We have WMS integration and we are trying to build a report for Movement Request details in Fusion Cloud. Except 'Integration Status' field, we are able to get all t…
-
How can we add tabs in a new page created through application composer?How can we add tabs in a new page created through application composer. I unable to find a page l layout to create tabs. There is only drill down format
-
Report to extract Review Item Supply and Demand UI detailsSummary: Hi Team, Need to build a report to extract the Review Item Supply and Demand UI details, but couldn’t find the exact schema details to do the same. Can anyone p…
-
Is it possible to transfer Inventory Aging on Transfer Orders?Summary: Capture Inventory Aging on Transfer Orders Content (please ensure you mask any confidential information): We are looking at a way to see if it is possible to ca…
-
Need to get reason code from database for backordered transfer ordersSummary: Trying to write a query from INV_MATERIAL_TXNS to inv_material_txns_exceptions and INV_TRANSACTION_REASONS_TL to get the reason code but I cannot find the link.… -
How to include the substitute information in the Receipt Traveler Report?Hello, How to modify the "Receipt Traveler" report to include a new field to show if an item was received as a substitute? For example I am receiving ItemA which can be …
-
Custom report to get Available to reserve column in Inventory managemntHi Team, We have a requirement to get a custom report where Available to reserve column should have the below formula Available to Reserve equals the quantity on hand mi…
-
Item Monthly Consumption And Usage RateSummary: We have a requirement to display a report showing how items are consumed and their usage rate. Is there a seeded report that provides this information? And if y…
-
Not able to find backing Requisition number field for Transfer Order in OTBISummary: Not able to find backing Requisition number field for Transfer Order in OTBI Content (please ensure you mask any confidential information): We are creating an O…Akancha Sinha 21 views 2 comments 0 points Most recent by JustinLitalien Reporting and Analytics for SCM -
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…
-
Sub Inventory is not Populating in manage Reservations and Picks pageSummary: Actually when we are fetching the Available to reserve value in a report based on Sub Inventory the correct values are not getting fetched in the report. When w…
-
Serial Numbers not picking in the reportWith a series of old transaction IDs. We need the data for each transaction to be extracted and displayed individually in the EBR report because we need this information…
-
How to create dependent value set for BIP ESS parameterSummary: We have custom Sales Order Pick Slip Report having 2 parameters. Sales Order -Lov controlled Pick Slip Number - Here the requirement is, the LOV should show tho… -
How to Query the Available to Transact and Available to Reserve Quantity of an Item in an inventoryI need a query to get the Available to Transact and Available to Reserve quantities of an item in inventory. I request you anyone can help on getting a query. Thanks in …
-
Duplicate Count SequenceSummary: In the UI, a specific sequence has one record but upon checking in BI Reports, there are two records with different items but having the same count sequence. Ho… -
I need to design a report to export data for Inactive ItemsI need to design a report to export data for Inactive Items, please help to provide SQL to acquire column data that we need or official Inactive Items Report. Want to pr…
-
Does the ERP 24B version have a Pick Slip Report, contains status information, GIN (Issued) Date?Summary: Does the ERP 24B version have a Pick Slip Report, to view pending status and success data with GIN Date (Issued) and Pick Slip Date information? Content (please…
-
Need PVO details from tables INV_UOM_CLASS_CONVERSIONS,INV_UOM_CONVERSIONSSummary: Hi Team, We need to extract complete data from INV_UOM_CLASS_CONVERSIONS,INV_UOM_CONVERSIONS tables and send it aws . Can you please help us with PVO details Co…
-
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…
-
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…
-
Total Unit Cost for Manage Standard Cost ( Supply Chain Execution->Cost Account->Manage Standar CostSummary: Integration requirement is there to get the Total unit Cost Content (please ensure you mask any confidential information): I have tried using below REST API but…Jignesh_HAE 31 views 8 comments 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing
-
Query To Get Supply Quantity from the Print Min-Max Planning Report in Oracle FusionSummary: When working with the Print Min-Max Planning Report in Oracle Fusion, you may need to extract specific information, such as the Supply Quantity. This quantity r… -
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.
-
Sync INV_RESERVATIONS SaaS table to PaaS tablesWe have a use case where we need the data from INV_RESERVATIONS SaaS tables to be synced to PaaS tables. The synced data is then further used in an extension that is dev…Abhinav_Vashistha 31 views 1 comment 0 points Most recent by Lynn Warneka-Oracle Inventory Management
-
Extract Ship Method Data for Integration with WMSSummary: Hi Everyone, We are looking for a way to extract ship method data (Freight Carrier, Service Level, Mode of transport, Organization Assignments and DFFs) from Or…
-
Is there any option to remove the delimiter from the EFF/DFF value setsI have created a Item EFF and data type is number with max limit of 8 number. while entering the EFF data at item level the numbers are separated by commas Is there any …Venkatesh Guntavari 21 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Product Master Data Management