BI Publisher Reports
Discussion List
-
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…
-
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 51 views 8 comments 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing
-
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 40 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 38 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 417 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 611 views 1 comment 1 point Most recent by Manikandan S R-Support Oracle-Oracle Costing -
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 … -
CREATE MISCELLANEOUS ISSUE AND RECEIPT BIP REPORTSummary: Hello experts, our client has a requirement to display Miscellaneous Issues through a BIP report, so we need the Oracle Fusion table names that store this infor…
-
we have some queries in Landed cost related, Please give the clarification for below question?Summary: we have some queries in Landed cost related, Please give the clarification for below question? User wrongly create landed cost for a PO(663), we updated the cos…
-
Getting null response from erpintegration when making get callSummary: We are trying to fetch the process id detail from this integration, document does say that this operation is supported however we are getting null repsonse. Con…
-
gl_date in rcv_shipment_headerSummary: gl_date column in rcv_shipment_header Table Content (please ensure you mask any confidential information): Currently we have gl_date as blank in rcv_shipment_he…Akancha Sinha 17 views 1 comment 0 points Most recent by Arun Yadav - Support-Oracle Inventory Management -
Can we customize the Inventory BIP reports grid and save the view for the user?Summary: Need the ability to customize the grid and query, then save the layout so it is available as a favorite layout. Content (required): Version (include the version…Hrishikesh Dahane 17 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How can I modify the Electronic Record for Inventory Miscellaneous Transaction Report?Summary: I need to add the Reference and Reason field to the RTF Template so that the approving user can make an informed decision without calling the user requesting th…
-
How to get subinventory and AvailableToTransact Qty of an item in an Org using webservice/BI reportSummary: Need to fetch Sub Inventory along with Available To Transact quantity of an item in an Org using webservice/BI report Content (please ensure you mask any confid…
-
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…
-
Cycle countSummary: Unable to find base table for BU association and vendor details for the Inventory Cycle Count Import template. Content (please ensure you mask any confidential …
-
How to get Miscellaneous Transaction Serial Numbers range if the serial numbers are consequetive?Summary: I have some report requirement to get the transaction serial numbers as: serial_from, serial_to, and range. The only source table I have is the serial number on…
-
Oracle SCM reportsWe are implementing Oracle Inventory, Cost accounting, receiving and product management. Would like to now existing reports from the application and OTBI. please can you…