OTBI
Discussion List
-
How to add a URL on the Sales Order page in Fusion to open a BI report?Summary: We need to add a clickable URL on the Sales Order creation page in Oracle Fusion Order Management that opens a BI report in a new webpage allowing them to run t… -
Has anyone been able to edit seeded data model that uses XML file as a dataset instead of sql query?Summary: I need to edit the Electronic Record for Ship Confirm Report to include custom data. The data model for this report uses an XML file as a dataset instead of an …
-
How to set BIP report to auto download CSV export instead of displaying online?Hi, I have a requirement to create a CSV unload BIP report but if I choose CSV template, when the report is ran, the data is displayed in browser comma separated and the…
-
Required sql query or tables sales order approval rules under Manage Order Approval Rules task.We required SQL query or back end tables where the information of Order management workflow Approval rules stored. Task name: Manage Order Approval Rules. For example Ru…
-
How to create Custom Dashboard in Order ManagementSummary: How to create Custom Dashboard in Order Management Content (please ensure you mask any confidential information): We are looking to create custom interactive da…
-
While im creating a analysis report, when i add the invoice number it duplicates the rowSummary: Im creating a report in analysis when basics fields like Order, source order, customer, item and basic of the order line everything fine. But when i add the inv…
-
Query to get sales order line level revision detailsSummary: Query to get sales order line level revision details Content (please ensure you mask any confidential information): Query to get sales order line level revision…
-
Need query to get the line level error message from the sales orderSummary: We have a business requirement to display the Error Message from the line level of the sales order in Fulfillment lines. We are getting error throw back end que…
-
Is there a column "Ship Lines Together" in the "Fullfilment Lines Real Time" subject area?Summary: Is there a column "Ship Lines Together" in the "Fullfilment Lines Real Time" subject area? Content (please ensure you mask any confidential information): Wareho…
-
What is the link between Sales order and Discount list through SQL in oracle fusion?Hi All, In my project we have done a customization on Discount lists setup which will apply on the sales order based on Attribute Matrix rules. Ex: so we have added a co…
-
Line Status supply Request CompleteSummary Some of the order lines gets stuck with the status "Supply Request Complete"Content Dear, Some of the order lines gets stuck with the status "Supply Request Comp… -
Edit item description on sales order or create the sales order without selecting a item codeSummary: Is there a way to Edit item description on sales order same like we have option on PO level or is there a way to create the sales order without selecting a item…
-
Order In Shipped status in Manage Shipment Lines ScreenSummary Order in shipped status in Manage Shipment Lines Screen but has Closed Status in Order ManagementContent Hello All, We have one Order which is Closed in Order Ma…User_2025-02-05-12-20-44-163 64 views 4 comments 2 points Most recent by Shyam Patel Order Management -
how to check schedules from past date for "Update and Close sales order"Hi , We have scheduled "Update and Close sales order" program on 25th Aug . But we have below queries , can please someone help us to find that: 1) When was last this "U…Aayush Anand 61 views 8 comments 0 points Most recent by Anuradha - User352 -Oracle Order Management
-
How to get the Pick Slip Number associated with Sales Order in Oracle Fusion?Hi, I have a requirement to write a query to get the Pick Slip Number associated with the Sales order. Is there any table in Oracle Fusion which stores the association o…
-
How to get sales order number associated with a work order in Oracle Fusion?Hi, I have a requirement to write a query to get the work order number associated with the Sales order. Is there any table in Oracle Fusion which stores the association …
-
OTBI Subject Area for Transaction Tax Determinants in Order ManagementOTBI Subject Area for Transaction Tax Determinants in Order Management
-
Transit time for a sales order in OTBIIs there any field available for Transit Time for a Sales Order line (calculated by the system) in OTBI Work Area. We would like to have a OTBI with Order, Requested Shi…
-
How to default an Order Type when performing Return All TransactionSummary: How to default an Order Type when performing Return All Transaction Content (please ensure you mask any confidential information): We have a requirement to defa…
-
The PO E-Mail notification cannot be delivered to the recipientsSummary: When all buyers create PO's, all suppliers can't receive PO email notification and send an email to the buyers as shown in the image below Hope to get a solutio…
-
How to use Import Maps for Sales Order uploadSummary: We have a requirement to use import maps for sales order import/upload facility Content (please ensure you mask any confidential information): We would like to …
-
SQL to find Material Transaction for Dropship Sales OrderSummary: SQL to find Material Transaction for Dropship Sales Order Content (please ensure you mask any confidential information): we are looking to get a SQL to find Mat…
-
Default communication Method as E-Mail in Purchase OrderSummary: Is there any way to default the Communication method as E-Mail when I create a Purchase Order without using Communication Method in Supplier Site Content (pleas…
-
The PO E-Mail notification cannot be delivered to the recipientsSummary: When all buyers create PO's all suppliers can't receive PO email notification and send an email to the buyers as shown in the image below Hope to get a solution…
-
Audit log related to sales unit price and purchase unit priceSummary: For the audit report found under tools, which products have audit log related to sales unit price and purchase unit price? Content (please ensure you mask any c…
-
How to view Logical Ship and Receive transaction for Dropship ordersSummary: How to view Logical Ship and Receive transaction for Dropship orders Content (please ensure you mask any confidential information): We have a requirement to rec…
-
In order management old and updated data needed in OTBI in separate lines.Summary: When we create a sales order due to some issues if we cancel the sales order, we are able to see the updated data of the sales order in the OTBI report. The req…
-
Which column in Fulfillment Lines Real Time is the same as fulfillment lines status in the screen?Summary: Which column in Order Management - Fulfillment Lines Real Time is the same as fulfillment lines status in the screen? When I selected "Fulfilment Line Status Na…
-
Facing an Error when changing the ware house in the Order Fulfillment Lines. How to resolve this?Selected shipping method is not available. Already added the required Inventory org to the Shipment method. Still error is populating. How to solve this? -
How to get serial number by sales order line in SQLSummary: I need to get the serial result by order line, Does anyone know how to do it? All I can do is the result below. there are 2 lines with 2 different ship-out date…