BI Publisher Reports
Discussion List
-
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…
-
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…
-
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 …
-
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…
-
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 15 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…
-
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 18 views 3 comments 0 points Most recent by Guthi Mallikarjun Inventory Management
-
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 …
-
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 …
-
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…
-
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 54 views 12 comments 0 points Most recent by Shabbir M Tahasildar 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 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…
-
what is the table for Movement Requests information?Hello, I would like to get some movement requiests data for report. on the report, I need quantity and subinventory colimns but I couldn't find them in WSH_PICKING_BATCH…Misato Yoda 11 views 2 comments 0 points Most recent by Santhosh Mani - Trinamix Inventory Management
-
How to get Item on hand quantity for backdatedBusiness wants to know the Item on hand quantity balance for the backdated, for example, the user wants to extract the on hand for the previous year i.e. Dec month 2024.…
-
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…
-
Which table / column can I find the commodity code for an Item?I need to find the table where commodity code is stored for an item. source→ Item → Specifications→ User Defined Attributes → CSD Service → CommodityArun P_Kumar 34 views 2 comments 0 points Most recent by Thierry Lamote Product Master Data Management
-
How to link RCV_SHIPMENT_LINES and CST_TRANSACTIONSHi We need to print Consumption Transactions Information: Purchase Order Receipt Number Consumption Advice Work Order Number Work Order Transaction Type Right Now we don…
-
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…
-
Issue when trying to create a Custom ESS job from Standard ESS - Print Min-Max Planning ReportSummary: We are trying to create a Custom ESS Job By duplicating the standard ESS Job 'Print Min-Max Planning Report'. We were able to successfully create the Custom ESS…Pavan P 21 views 2 comments 0 points Most recent by Andrada-Oracle Fusion Applications Administration
-
Custom report to get Available to reserve column in Inventory managemntHi Team, We have a requirement to get a custom report where Available to reserve column should have the below formula Available to Reserve equals the quantity on hand mi…
-
How to Query the Available to Transact quantity of an Item in an inventorySummary: Have to fetch the Available to Transact quantity in BIP report.
-
Invoking REST API/SOAP in BIP for Fetching available to reserve and available to transactHi Team, We need to retrieve available to reserve and available to transact , but we've observed discrepancies when querying through SQL. Our goal is to achieve this via…Lokesh P 28 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to include the substitute information in the Receipt Traveler Report?Hello, How to modify the "Receipt Traveler" report to include a new field to show if an item was received as a substitute? For example I am receiving ItemA which can be …