My Oracle Support Banner

Sales Order Line Item Unit Price Turns To a Large Negative Value When Saved (Doc ID 2678130.1)

Last updated on JUNE 08, 2020

Applies to:

Oracle Order Management - Version 12.0 and later
Oracle Advanced Pricing - Version 12.0 and later
Information in this document applies to any platform.


Problem Description
Sales Order Line Item Unit Selling Price becomes negative turning to (61,059.389) instead of 0.40 when saved.

The steps are given below.
1. Responsibility: Order Management Super User (or equivalent)
2. Navigate to: Orders, Returns > Sales Orders
    Create sales order
3. First, enter a line for <item A>  for 100 EA
4. This will select a (correct) unit price of 61.06, for a total order price of 6,106.00. This changes the price list to <Secondary Price List>
5. Save the order line. A message pops up stating that the item specified is invalid or does not exist in the warehouse you specified. Please enter a valid item-warehouse combination.
6. Change the item from <item A > to <Item B> . A message will pop-up stating: <item B> and PC not on <Secondary Price List>
    Because of this, the unit price is reset to a null value (as expected).
7. Save the order. The incorrect price will be returned here, as -61,059.38940




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.