BI Publisher Reports
Discussion List
-
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 559 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 21 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Inventory Management
-
Which tables have review completed transaction data?Summary Hello , I want to know that which table have review completed transactions data . if any have query and know the table name please guide me. Kindly check the att…
-
E-Signature Data Model can't be modified to add LotAttributeDFF (Is there an alternative solution?)Summary: Our customer uses E-Signatures for the following in line transaction types: *Inventory Lot Update *Miscellaneous Transaction *Quality Inspection Disposition *Wo…Federico Elicetche 2 views 1 comment 0 points Most recent by Lynn Warneka-Oracle Inventory Management -
Vendor return reportSummary Availability of vendor return reportContent We would like to a printable template (like PO's) for returning items to vendors. We have got the confirmation of Ora…User_2025-01-28-02-43-26-951 47 views 3 comments 1 point Most recent by CaioMSMancini Inventory Management -
how to add a fiscal document status field in OTBISummary: Hi, we need to add the field fiscal document status from shipping forms to OTBI, there is a away to do this? Content (please ensure you mask any confidential in…Alex Pagliarini - Ninecon 1 view 1 comment 0 points Most recent by Vignesh Rajendhiran-Oracle Inventory Management -
Pick Slip Report ESS Job not sending Attachment for adhoc email address with Bursting enabledSummary: We have enabled bursting for Pick Slip Report ESS job but when trying to pass adhoc email address while submitting the ESS job, only Bursting proces is working …
-
Movement Request line - Status and status date history information tableSummary: In the Movement Request line, we can find status and status date information in INV_TXN_REQUEST_LINES. If there is a change in status from approved to closed, w…Guthi Mallikarjun 473 views 1 comment 0 points Most recent by Hari Kurra-Oracle Inventory Management
-
Query to get the all the items and instrumental serial numbers.Summary: Content (required): need a query to get the all the items and instrumental serial numbers. Is there any thing like product_type='INST'? Version (include the ver…Guthi Mallikarjun 512 views 2 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Inventory Management