BI Publisher Reports
Discussion List
-
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 42 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 32 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 31 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 333 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 571 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 11 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 11 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…
-
Is there any option to run sql for bulk data export (Inventory movement, Sales Order details etc)Hi, Is there any option to run sql for bulk data export (Inventory movement, Sales Order details etc) for one year. We are using reports but it is not working due to tim…
-
Oracle fusion database table for Context based DFF segment API namesSummary: We need to extract API names of context based serial numbers DFF attributes from database table. However, we can't figure the appropriate table which holds thes…
-
Deep link for lines to be PutAwaySummary: I have one report that allows all the receipt lines to be PutAway. I would like to click on Receipt Number and then the window of the PutAway will be open using…Giuseppe Galluzzo 51 views 4 comments 0 points Most recent by Lynn Warneka-Oracle Inventory Management
-
STOC REPORTIs there a standard report that shows stock by organization, subinventory, locator and lot and other similar things? The Manage Item Quantities query does not allow expo…
-
Is shipment Hyperlink is possible in BIP reports.Summary: In the BIP report, Once the user clicks on the shipment number it should take to inventory Manage shipment page in display mode. Please confirm . .Content (plea…KOTTHURI ASHOKBABU 22 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Inventory Management