BI Publisher Reports
Discussion List
-
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 62 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…
-
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…
-
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 62 views 13 comments 0 points Most recent by Shabbir M Tahasildar Inventory Management -
Can we bring Available to Transact (ATT) value from REST API to BIP report ?Summary: Can we bring Available to Transact (ATT) value from REST API to BIP report ? Content (please ensure you mask any confidential information): Hi, We have a requir…
-
Dear Team, Is there any subject area to create OTBI report for Inventory Aging?Summary: Dear Team, Is there any subject area to create OTBI report for Inventory Aging? Content (please ensure you mask any confidential information): Version (include …
-
Need a SQL query to fetch Miscellaneous transactions in Oracle Fusion CloudSummary: Need a SQL query to fetch Miscellaneous transactions in Oracle Fusion Cloud. I'm building a report to capture the Account Alias Issue type of transactions. Cont… -
To print the attachment conditionally in rtf based on PBREAKHi, I have one POC to be implemented where in the feasibility is to check if its possible to insert a page break in the batch slip report if the operation level attachme…Mazher Shaikh 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Transitioning Oracle BIP Reports from Packages to Standard TablesSummary: Can we convert Oracle BIP reports to use only Oracle standard tables instead of Oracle standard packages? We should not call standard packages in the report. We…
-
Custom Delivery Note Reports to be printed automaticallyWe have developed a customer delivery note report. we want that to be printed to the specific users printer as soon as the shipment is confirmed in oracle fusion. The pr…
-
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 …
-
Copy of 'Print Movement Request Pick Slip Report' does not show parameters screenSummary: I have created a copy of 'Print Movement Request Pick Slip Report' process in order to make required the parameters 'From Movement Request' and 'To Movement Req… -
Key colimn for joining INV_RESERVATIONS and DOO_HEADERS_ALLI would like to get data of Manage Reservations and Picks. More specifically, I need order number, quantity, customer, and shipping status from demand tab. According to …
-
How to query Receiving Quantity & Inbound quantityHi Experts, I am developing a report to show Item On hand quantities along with the Lot and corresponding Sales Order details. I am also trying to show the Receiving Qua…
-
How to join INV_TXN_REQUEST_HEADERS with INV_TXN_REQUEST_LINES?Summary: I want to join INV_TXN_REQUEST_HEADERS and INV_TXN_REQUEST_LINES, so I use HEADER_ID as a join key. But execution data is not be 1=1 low. Which column should I …
-
Which SQL table stores expected receipts for interorg transfers?Summary: I'm writing an SQL and need to retrieve the expected receipts for interorg transfers. In order words, the interorg has been created at the source organization a…
-
What is the key column for joining WSH_DELIVERY_DETAILS and DOO_ tables?Summary: I would like to join WSH_DELIVERY_DETAILS with DOO_HEADERS_ALL, DOO_LINES_ALL or DOO_FULFILL_LINES_ALL. Could you teach me the key column, please? Content (plea…
-
Can we create 2 User Defined Dependent List of Values for ESS Job Parameter?Summary: Need to create an ESS job for a BIP report and a parameter will get autopopulated based on value we select for other ESS Parameter on which the parameter is dep…