BI Publisher Reports
Discussion List
-
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…
-
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…
-
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…
-
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…
-
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…
-
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
-
Optimal way to join WSH_DELIVERY_DETAILS and INV_TRANSFER_ORDER_LINESSummary: Hi Team, Is there any other way to join WSH_DELIVERY_DETAILS with INV_TRANSFER_ORDER_LINES which will give optima execution plan. We are now using the below que…Baswanth Kumar Reddy-Oracle 12 views 1 comment 0 points Most recent by Adnan Siddiqui-Oracle Inventory Management
-
how to get reservations against shipment line?Summary: if more than one reservation exist against one fulfilment line, delivery detail line splitted based on the reservations created. In this case, how to get the re…
-
query to get movement request attachmenti want query to get movement request attachments details
-
Query To get the COGS (Cost of Goods Sold) in a BI ReportHello, I am trying to get the total COGS (Cost of Goods Sold) for every customer in the business unit. Can anyone help provide a query that helps in calculating the COGS…Patrick Chrabieh 164 views 1 comment 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing
-
Deeplink Manage Item Quantities (INV_ONHAND_DETAILS,VIEW)I can see deeplink is available for Manage Item Quantities. Could you please provide the sample URL format. Deeplink Manage Item Quantities (INV_ONHAND_DETAILS,VIEW). I …
-
how is INV_CONS_ADVICE_REVISIONS table populated?Hi Team, For a consumption advice, I am seeing 2 revisions- 1 & 2 present in front-end while database table INV_CONS_ADVICE_REVISIONS is just fetching revision 1. Would …
-
how to get quantity wise serial numbers in Delivery Note reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Can we get Label Printer Model suggestions that can print Label in PDF format?We have made a custom report fetches the data of the Purchase Order (PO) and Return Merchandise Authorization (RMA) which are meant to be received in client’s sub-invent…
-
Receiving Account Distribution Report - Oracle FusionSummary: Is the "Receiving Account Distribution Report" from EBS available in Cloud Fusion as a standard report? If so, what is the revised report name? If not, has anyo…
-
I want to pick Inspected by column on po receivingHello, I want to pick Inspected by column on po receiving as attached in screen short in inventory management oracle fusion Need to know the table which is storing this …