Order Management Analytics
Discussion List
-
Service item should wait until Inventory item went for awaiting billing in oracle fusionSummary: Hi Team, Business is having a service item and a inventory, Business wants service item should be in awaiting billing only after inventory item is shipped? Busi… -
Order in OM get stuck with Credit Hold error even though its released by credit analystSummary: Hi Team, Order was created from cpq and it got stuck with credit hold. It was released by credit analyst but still stuck with credit hold reason. Order screensh…
-
Sales Order ErrorSummary: We got below error for one of the sales order lines. Can someone help me to fix this? Task Schedule in process 300000706922305 timed out before an acknowledgmen…
-
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…
-
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…
-
Need to Insert original item number in RA_INTERFACE_LINES_ALL table post sales order shippingHi, I have a Groovy script that runs in the backend whenever I enter sales order details and click the save button. The script flips the item in our system. However,when…B.Anil 1 view 2 comments 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
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…
-
What is the PVO to get Users Time zone?Hi All, I have a Requirement to get the user's time zone and based on that do some calculation to default schedule ship date in the sales order through Order Management …John Peter Noble-Oracle 12 views 1 comment 0 points Most recent by Anuradha - User352 -Oracle Order Management
-
Error when updating item post sales order shipment via rest apiSummary: Hi, I have requirement to update the item after a sales order has been shipped.i am using the REST API endpoint: /fscmRestApi/resources/11.13.18.05/invoices/{in…
-
Cant find organization in send receipt confirmation ESS JobSummary: Dears, I tried to run "Send Receipt Confirmation" ESS job but i cant find the organizations. Please check the image below Your support is highly appreciated. Th…
-
Availability of rest api to update itemnumber in RA_INTERFACE_LINES_ALL table after shipmentcreationHi, I would like to know if there is any rest api available to update the item number in the RA_INTERFACE_LINES_ALL table after a shipment is created against a sales ord…
-
How to update itemnumber in AR_INTERFACE_LINES_ALL table after sales order shipmentHello, In our oracle fusion implementation , after a sales order is shipped, the data is inserted into the AR_INTERFACE_LINES_ALL table. we need to update the item numbe…
-
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… -
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…
-
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…User_2025-02-05-12-20-44-163 64 views 4 comments 2 points Most recent by Shyam Patel Order Management -
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 571 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…
-
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…
-
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…