Order Management Analytics
Discussion List
-
we can't fix the Amount and Price at line level for sales order extension.We have a Requirement for sales order extension when we click on save button after entering mandatory fields the groovy script come into play for item flipping at line l…
-
How do we notify credit check person / team that these xyz orders are on credit holdSummary: Is there any mechanism to notify a individual or designated team , that ,they need to action on credit check hold orders for bunch of identified order which are…
-
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…
-
Getting Error Order management can't run process instance 300001340280525 for sales order.Summary: Hi Team, Business created a order and order having an error with "Order management can't run process instance 300001340280525 for sales order . (DOO-2685208) De…
-
How to update the Requested date without creating the sales order revisionSummary: There is a business requirement to update the Requested date without creating the sales order revision. The way we are overriding the scheduled ship date and sc…
-
Setting Up Printer for Packing Slip in Oracle Fusion (Not Pick Slip)Summary: Hello everyone, I need guidance on setting up a printer in Oracle Fusion specifically for packing slips. Please note, this is for packing slips and not pick sli…
-
Issue with Processing RMA for Sales Order – Returnable Quantity ErrorSummary: Hello Everyone, I hope this email finds you well. I am writing to bring to your attention an issue we are encountering while attempting to process a Return Mate…
-
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…
-
The Intraclass PVO returns a null conversion rate despite valid setups in front-end and back-end.We have written a Groovy script to perform calculations based on the ordered quantity in a sales order and the conversion rate from the Manage Units of Measure for Intra…John Peter Noble-Oracle 11 views 1 comment 0 points Most recent by John Peter Noble-Oracle Order Management
-
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…
-
How to update/add Sales Order line EFFSummary: How to update/add Sales Order line EFF Content (please ensure you mask any confidential information): Hi , As per the below document, we are trying to add EFF v…
-
Sales Orders Updated Through REST API not following Order Management ExtensionSummary: As per Oracle Standard functionality, Schedule ship date recalculates from the updated date on sales order whatsoever attribute might be changed. Business wants…
-
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…
-
BIP Report - Full Scan on doo_headers_eff_bSummary: Hi Team We have defined index enabled EFFs on Sales Order header however the SQLs are not doing Index scan when using EFFs columns for data selection. On Furthe…bala_07-Oracle 11 views 1 comment 0 points Most recent by Anuradha - User352 -Oracle Order Management
-
Pause tasks need to be released automatically once stock is available for an item.There is an business requirement that pause task need release automatically once stock is available for an item or order lines. Thanks, Yuvaraj
-
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 …
-
Export reservation data as excelSummary: Can we export the reservation related info from the Create Reservations screen as below ? HIghlighted red Content (please ensure you mask any confidential infor…
-
Clearing of Overridden Field in the Sales OrderThe Overridden field in the sales order line is enabled under multiple scenarios. When this Overridden field is enabled for multiple lines in the sales order , then any …
-
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…
-
How to enable the Date Increment Procedure for the Custom ESS jobSummary: There is a business requirement to schedule the custom ESS job for every week and the date needs to be an increment of 7 days in the argument parameter. As of n…Yuvaraj Meganathadu 86 views 5 comments 0 points Most recent by Yuvaraj Meganathadu Supply Chain Orchestration
-
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…
-
Hi all, how to create an EFF in Order Management on the basis of order Type.Summary: We have a requirement to create an EFF in Order Management on the basis of Order Type. We need some EFF fields to be populated and make it mandatory for a speci…
-
Calculate number of billing periods automaticallySummary: Can number of billing periods be calculated automatically? This will prevent manual errors resulting in incorrect revenue if not caught. For example, if we inpu…
-
Sales Order Line status get stuck in Cancellation PendingSummary: Hi Team, Sales order line status get stuck in cancellation pending. What could be the reason? Followed the Docs: FA: SCM: OM: Sales Order Lines Stuck In Cancell…
-
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…
-
Is it possible to create a WO in unreleased status when it is created against SOSummary We have a scenario where for every Sales order a WO is created in released status automatically without manual interventionContent We have a scenario where for e…
-
Schedule Ship date should exclude Weekends and Public HolidaysSummary: We have to business requirement to exclude the SSD from Weekends and Public holidays. For this we did the following- We already have a 7 day workday pattern, an…
-
Payment Term Relationship by Product Family and Customer Account Order ManagementBe able to store the relationship between customer account and payment term according to the family/category or item. Example Product Family 1 Account 1000 - Payment Ter…Valentina Talani-Oracle 21 views 1 comment 0 points Most recent by Anuradha - User352 -Oracle Order Management
-
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?
-
Need to add the additional (Partially shipped) status in Header Status in OMSummary: There is a business requirement to add the Partially shipped additional status to header status. If sales order lines are shipped partially, then Partially ship…