BI Publisher Reports
Discussion List
-
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… -
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…
-
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…
-
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 11 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…
-
Unable to see the child inventory org in EGP_COMPONENTS_B tableWe are not able to fetch the parent items for a child item using EGP_COMPONENTS_B table because it is having Master_Org_Id in PK2_VALUE instead of specific child_org_id.… -
Unable to see the child inventory org in EGP_COMPONENTS_B tableUnable to see the child inventory org in EGP_COMPONENTS_B table. We have a requirement to fetch item where used details in which we need to fetch the details of parent i…User_12LVE 61 views 4 comments 0 points Most recent by Manali Biswas-Oracle Product Master Data Management
-
What is the logic for segregating the serial number between OnHand and Inbound quantities?Not able to segregate within the OnHand and Inbound details as we are getting the serial number based on Inventory_Item_id and because of this we see records are getting…
-
Assistance Required for Converting OTBI Query to Oracle Standard TablesSummary: I am reaching out to seek your expertise regarding the conversion of an OTBI query subject area into Oracle standard tables. Specifically, I am looking to under…Guthi Mallikarjun 21 views 8 comments 0 points Most recent by Guthi Mallikarjun Inventory Management
-
Replicating Oracle Function FND_CURRENCY.GET_FORMAT_MASK() using oracle standard tablesSummary: Need to replicate the functionality of the Oracle standard function FND_CURRENCY.GET_FORMAT_MASK()using oracle standard tables Requirements: Explain what FND_CU…