Error: Invalid Value for the field C_ORDER_NUMBER - If The Customer And Bill To Parties Are Different

(Doc ID 2078251.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Depot Repair - Version 12.2.3 and later
Information in this document applies to any platform.


On : 12.2.3 version, Service Request

When attempting to add charge lines to an order when Charges bill-to account is not same as Sales Order header customer account the following error occurs.

Invalid Value for the field C_ORDER_NUMBER

The issue can be reproduced at will with the following steps:

1. Create SR for Customer account.
2. Customer informs that the Bill-To customer is different and that is changed in the SR.
3. Run bulk receiving. That creates sales order for shipping.
4. Trying to add more SR Charges lines to that order using the "Add to Order" field doesn’t work. It doesn't show any available order as the SR Account and Bill to account are different.

Create a SR with Party A and Account A..

In the Contact/Addresses Tab change the Bill to ACcoun to 'Account B' Now create a Charge Line with the defaulted Bill to Account as 'Account B ' and Submit it

Create a Second charge line with Bill to Account as 'Account A' and in the 'Add to Order' LOV observe that No order Numbers are shown.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms