Cannot Update Value Column 'Acceptance Name (CONTINGENCY NAME)' Using OE_ORDER_PUB (Doc ID 1682616.1)

Last updated on SEPTEMBER 22, 2023

Applies to:

Goal

We need to update one column which is on the sales order line level, the column name is 'Acceptance Name', and in the order line base table, the corresponding column name is 'CONTINGENCY_ID'. We tried to use API OE_ORDER_PUB to update this column, but it cannot work.

We checked the code in OE_ORDER_PUB, there isn't 'CONTINGENCY_ID' in the line record Line_Val_rec_Type in the API, but we can only find 'CONTINGENCY_NAME', we tried to update the value to the column 'CONTINGENCY_NAME' in the record, it didn't work. And we had tried to call the standard API directly in SQL Developer, also not work.

Please kindly suggest on how to update the value for column 'Acceptance Name' for a sales order line.

Steps taken to debug issue:
Found Bug 10411303: CANNOT CHANGE ACCEPTANCE NAME AND ACCEPTANCE TYPE AFTER BOOKING

By design user cannot change Acceptance Name and Acceptance Type.

As a result the API will not be able to change/modify the field.

There is an existing ER 10411303 : CANNOT CHANGE ACCEPTANCE NAME AND ACCEPTANCE TYPE AFTER BOOKING for this issue.

ER has been implemented via Bug 20082987.

Customer responded with:
Even when we are trying to update Acceptance Name before Order is Booked by populating contengency_id in
l_line_tbl(l_line_tbl_index).CONTINGENCY_id := v_contingency_id;

in OE_ORDER_PUB.process_order

Please advise if customer will be able to accommodate the business need to update the column and if so please
provide detailed steps on how to accomplish it.
 

Solution

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