BI Publisher Reports
Discussion List
-
what is the table for Movement Requests information?Hello, I would like to get some movement requiests data for report. on the report, I need quantity and subinventory colimns but I couldn't find them in WSH_PICKING_BATCH…Misato Yoda 11 views 2 comments 0 points Most recent by Santhosh Mani - Trinamix Inventory Management -
How to get Item on hand quantity for backdatedBusiness wants to know the Item on hand quantity balance for the backdated, for example, the user wants to extract the on hand for the previous year i.e. Dec month 2024.…
-
Which table / column can I find the commodity code for an Item?I need to find the table where commodity code is stored for an item. source→ Item → Specifications→ User Defined Attributes → CSD Service → CommodityArun P_Kumar 81 views 2 comments 0 points Most recent by Thierry Lamote Product Master Data Management
-
How to link RCV_SHIPMENT_LINES and CST_TRANSACTIONSHi We need to print Consumption Transactions Information: Purchase Order Receipt Number Consumption Advice Work Order Number Work Order Transaction Type Right Now we don…
-
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…Pavan P 21 views 2 comments 0 points Most recent by Andrada-Oracle Fusion Applications Administration
-
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…
-
How to Query the Available to Transact quantity of an Item in an inventorySummary: Have to fetch the Available to Transact quantity in BIP report.
-
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…Lokesh P 21 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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 …
-
How to create a custom parameter in "Receipt Traveler Report"Summary: I'm trying to create a custom version of the “Receipt Traveler Report” with a new parameter (Receipt creation date). I extracted the .xdm and included the param…Aline Teixeira 22 views 1 comment 0 points Most recent by Kavita Yetakuri-Oracle Inventory Management
-
How to Query Available to Reserve Quantity to show in Custom Report or Any calculation (Formula)How to Query Available to Reserve Quantity to show in Custom Report or Any calculation (Formula)
-
cost organization- inventorySummary: we are trying to build BIP inventory report, we need to add “Cost Organization”? is there any way ? For example in the case of PTO “Valuation Unit” the “Cost Or…
-
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…Cesar Saveedra 161 views 6 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Inventory Management
-
Request for Details and References of INV_MO_PICK_SLIP PackageSummary: Please provide details of the INV_MO_PICK_SLIP package, including the specification and package body. Additionally, provide references to the packages used with…
-
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 602 views 3 comments 2 points Most recent by Becca Edwards Inventory Management -
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.… -
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…
-
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…