BI Publisher Reports
Discussion List
-
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 32 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 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…
-
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… -
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 23 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 11 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 131 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 …
-
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…