OTBI
Discussion List
-
Subject area for "Total Shipping Cost Recorded" on Shipment pageSummary: Please anyone provide exact attribute and subject area for "Total Shipping Cost Recorded" on Shipment page Content (please ensure you mask any confidential info… -
Getting errors UPDATING an Item in a Price List in Bulk using Import Price Lists Batch FBDIWhile trying to UPDATE an existing Price Lists' Items and Charges, getting the following errors: primary_pricing_uom_flag - Only one price list item record can be the pr…
-
How to Reprice the Sales Orders after Pick ReleaseSummary: How to Reprice the Sales Orders after Pick Release Content (please ensure you mask any confidential information): We have a requirement to reprice the Sales Ord…
-
how to link between sales order and discount list through SQL in oracle fusion (non-matrix rule)Summary: I can link the SO to the discount list name by following the post below if I am using MATRIX_RULE https://community.oracle.com/customerconnect/discussion/commen…
-
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…
-
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…
-
System AlertContent Hi i need system send alert to user when order line status change from waiting shipping to waiting billing Thanks -
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…
-
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 62 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…