BI Publisher Reports
Discussion List
-
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… -
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…
-
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 3 views 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…
-
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…Akancha Sinha 21 views 3 comments 0 points Most recent by Muhammad Waqar_Pwc Reporting and Analytics for SCM -
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
-
BI SQL query to get the Review Item supply and Demand in oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
What is the purpose of the CST_I_INCOMING_TXN_COSTS interface table in Oracle Fusion?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…mario.santiago 51 views 8 comments 0 points Most recent by Shabbir M Tahasildar Inventory Management
-
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… -
Move the Privilege for running HITB and Lot report from a Custom INV View only Job RoleSummary: Please help to identify the privilege for running HITB and Lot Report from a custom INV View only job role. We want to remove this privilege and transfer to ano…
-
Inventory Ageing ReportSummary: We have SQL Code, regarding Aging Buckets. developed a report but for 1 item it is giving the data with in 1 sec., but it won't work out for my client. we need …Sumalatha Challa 12 views 1 comment 0 points Most recent by Aditi Srivastav-Oracle Inventory Management
-
Getting duplicates when trying to get total unit cost of an item based on the LOT NumberSummary: For a particular organization, when we are trying to fetch the total unit cost of an item based on the LOT Number we are getting duplicate rows. There are no pr…
-
CCC - Facing issue to get the Correct Source Organization and Destination Organization.Summary: Hello Folks, We have a requirement to get Source and Destination Org according to each Transaction Type and Transaction ID for Transfer Order Transactions in Re…