BI Publisher Reports
Discussion List
-
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…
-
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 …
-
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 27 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 2 views 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 52 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 22 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…
-
Explain the Hyperlink Behavior in Transfer Order ReportWe have developed a report named Transfer Order Report, which includes a hyperlink for the Transfer Order Number. We’ve observed the following behavior: If a Transfer Or…
-
Work Order Operation related Item Number Open, Reserved and Required Quantities table or formula?Hi there, I am looking for information regarding the Open, Reserved and Required quantities of an item related to a worked order operation are stored in which table ?? O…
-
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 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 0 comments 0 points Started by Balaji Midhun Kumar Sanagapalli Inventory Management
-
Table for Pick Slip Header StatusSummary: We are looking for the table that contains the Pick Slip Header Pick Status Content (please ensure you mask any confidential information): We are looking for th…
-
Print Min-Max Planning Report is taking more than 1 HourSummary: The problem is with the Print Min Max Planning report scheduled for one of the organizations is terminating due to time out error. This is happening since 18th …Shabbir M Tahasildar 51 views 13 comments 0 points Most recent by Shabbir M Tahasildar Inventory Management