BI Publisher Reports
Discussion List
-
Use Current Cost Flag Yes or No on Miscellaneous Transaction UISummary: Content (required): Hello Experts we are using Actual Cost Method. When User does Miscellaneous Transaction then user select "Use Current Cost Flag" and Provide…Ashish_Kumar 161 views 11 comments 0 points Most recent by Shabbir M Tahasildar Inventory Management -
Item extract issueSummary: We want to extract Item master data which is more than 4 million. Currently i have prepared BIP Report for extracting data but it seems due to huge count its no… -
Buyer planner group summaries query forSummary: In Buyer Planning we have plan information along with Group Summaries. Can someone help us to provide the sql query or tables where group name for that supplier…
-
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 …
-
Error Table Details for "Print Min-Max Planning Report" ESS JobBusiness case: Our goal is to create a custom report that captures error details related to the min/max replenishment process. Expectation when running the Print Min-Max…
-
Min-Max Report - On Order Quantity CalculationSummary: Min-Max Report - On Order Quantity Calculation Content (please ensure you mask any confidential information): We are having a descrepancy in the data were seein…
-
Not able to find backing Requisition number field for Transfer Order in OTBISummary: Not able to find backing Requisition number field for Transfer Order in OTBI Content (please ensure you mask any confidential information): We are creating an O… -
Query to retrieve Trade Operation and corresponding PO detailsSummary: Content (required): Hi, There is a requirement to create a report that displays the following columns; Trade Operation number Trade Operation Name Created By Us…
-
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…
-
Pick Confirmation by Work Order - Trying to locate the pick time on WO'sSummary: Work Order Release Date: KnownExisting Report Location Date/ Time Stamp of PickConfirmation by Work Order: Unknown Report Location ???? Date/ Time Stamp of PO C…
-
Email server settings to get emails on Ship confirmation output.Summary: We have configured the Shipping Document output Preferences with the correct "From" and "To" email IDs, and set the Ship Confirmation job set accordingly. After…SIVASANKARAN GOPALAN 1 view 0 comments 0 points Started by SIVASANKARAN GOPALAN Inventory Management
-
what is the PVO name for EGO_ITEM_EFF_B table to extract via BICCSummary: We need to extract EGO_ITEM_EFF_B table from oracle fusion application. we are using BICC connector to extract all these tables but we are unable to find PVO fo… -
Am not able to see the inventory org, item category and currency printing in the report.Summary: Hi All, When running As of Date inventory valuation report, am not able to see the inventory org, item category and currency printing in the report. could you p…
-
Can someone please provide underlying sql query for Available To ReserveSummary: Looking for underlying sql query to get "Available to Reserve" and "Available to Transact" qtys on onhand UI. I tried with joining multiple tables and condition…
-
How to change the Currency in Total Price column in "Print Transfer Order Status Report"Hello Experts, We have a client requirement to change the $ to euro symbol in "Total Price" column in "Print Transfer Order Status Report" (Requisition View) Currently w…Balaji Midhun Kumar Sanagapalli 11 views 1 comment 0 points Most recent by Graeme Gerber Inventory Management
-
How to correct the Error Manual Recovery in Print Inventory Labels ESS JobSummary: We are generating the barcode labels for the Locators in our new Warehouse. However, when we run the Print Inventory Label, the Error Manual Recovery appeared i…
-
How to create a query/ extract data by joining WSH : interface errors and Delivery InterfaceHow to create a query/ extract data by joining WSH : interface errors and Delivery Interface
-
How can we configure the date picker parameter in an ESS job to show JST instead of the default UTC?Summary: We have an ESS job where the 'Territory' is set to Japan, and the 'Time Zone' is set to (UTC+09:00) Tokyo – Japan Time (JT) in the Process Options. However, in …
-
How to print "order number" barcode to receive goodsHi community, in mobile inventory management you can receive goods by scanning order number barcodes. I want to ask whether there are predefined BIP templates or some fe…
-
transaction type match with Event Type NameSummary: Transaction_Type should match with event_type_code giving the cross match. Content (please ensure you mask any confidential information): Version (include the v…
-
Issue related to Available to Reserve that needs to be printAs I am verifying the tables to get OnHand quantity INV_ONHAND_QUANTITIES_DETAIL, for pending quantity related I am using this table INV_MATERIAL_TXNS. But the problem I…
-
Adding a sorting option in Min-Max planning reportSummary: Hi, there's a requirement to add an additional Sorting option in the Min-Max Planning seeded report. Currently it has option to Sort By Buyer, Category, Invento…
-
DOR Draft Version Removing or Disable Before The request is approvedSummary: this is the DOR after approval that we want to keep it but before approval the Dor is Draft Version and this is what we need to hide or remove
-
Movmnt of Stock frm 1 Inv Org to Other Such That Its Current Bucket in Inv Aging Reprt isn't ChangedSummary: Business user wants to transfer two items (one item has 1 quantity and the other item has 2 quantities) from one of their inventory orgs to the other in such a …
-
Question about DOS_SUPPLY_TRANSFER_ORDER_DTLS tableSummary: Question about DOS_SUPPLY_TRANSFER_ORDER_DTLS table Content (please ensure you mask any confidential information): We have a question about the DOS_SUPPLY_TRANS…
-
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…
-
Print Receipt traveler report is not triggeringSummary: when we are creating expense destination receipts the Print Receipt traveler report is not triggering. For inventory destination receipts was triggering automat…
-
About linking transfer order details and shipment detailsSummary: I want to link transfer order details and shipping details. What is the join key for "WSH_DELIVERY_DETAILS" and "INV_TRANSFER_ORDER_LINES"? Content (required): …
-
query for inbound quantitySummary: From which table we can fetch inbound and receiving quantity coming up in inventory management->manage item quantities
-
Request to Replicate Oracle GET_POSTING_STATUS() FunctionalitySummary: We need to replicate the functionality of the Oracle standard function GET_POSTING_STATUS(). Requirements: Explain what GET_POSTING_STATUS() does in Oracle, inc…Guthi Mallikarjun 1 view 1 comment 0 points Most recent by Adnan Siddiqui-Oracle Inventory Management