My Oracle Support Banner

FA: SCM: Pricing: Unit Selling Price Updated to Zero on Some of the Lines When the Updates are Made Through FBDI Withover 500 Lines and Two Manual Price Adjustments. (Doc ID 2887311.1)

Last updated on SEPTEMBER 25, 2022

Applies to:

Oracle Fusion Order Management Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Manage Orders

Unit Selling Price updated to Zero on some of the lines when the updates are made to the sales order.

Imported a Sales Order 44720379062 with 399 lines. List Price is 0 for all the lines on this sales order , Unit Selling Price is brought as a manual adjustment in FBDI File. Prices are shown correctly after the Order Import.
Unit Selling Price (Your Price field) got updated to 0 for lines 1 to 150 when the Sales Order is saved after updating the Quantity on line 8. Price is showing up correctly from lines 151 to 399. For the lines with 0 price, Price adjustments are still showing up when we hit the edit price button. Only your price is showing as 0 which is reflected in Order Total.

Expect the Unit Selling Price (Your Price field) not to be updated to 0 for lines 1 to 150.

The issue can be reproduced at will with the following steps:
1. Import Sales Order via FBDI bring in order with 399 lines and two manual adjustments for each line.
2. Query the Order in UI, change quantity on line 8.
3. Save.
4. Now see lines 1-150, the USP/your price is updated to 0.





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.