My Oracle Support Banner

Manual updating for “Customer_Item_Net_Price” or "Customer Net Price" field in sales order form (Doc ID 1199906.1)

Last updated on SEPTEMBER 05, 2019

Applies to:

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

Goal

Business Case
When a business have a need of updating the "Customer_Item_Net_Price" field at the OM order line level.
But it is not allowed for updating this field from the Order from.

User wants to clarify the following questions?
Customer Business requirement:


. Wanted to update this field.

. using EDI Purchase order inbound process which creates orders via EDI POI 850 transaction interface.
  As a result of this, they are populating the Customer_Item_Net_Price with customer's PO price from the PO EDI message.

. But in the future, if we get the purchase order price change request,
  we need to update the Customer_Item_Net_Price because customer requests to have a different price.

Question:
Can you please let me know what would be the implication if we change this field from backend (e.g. using update SQL)?

Solution

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
Goal
Solution


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