ORA-01403: No Data Found In Package OE_Order_GRP Procedure Automatic_Account_Creation (Doc ID 1929471.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

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

Symptoms

You are running a custom Concurrent Program. This program uses one Procedure.
It will try to update the OE_ORDER_LINES_ALL table columns(REVREC_SIGNATURE_DATE,accepted_by,REVREC_COMMENTS,ACCEPTED_QUANTITY)
When attempting to update the order lines through the OE_ORDER_GRP,
the following error occurs.

ERROR
Header_id:2155763,Line Id:6646460
ORGID Condition...Main Update part
message is: ORA-01403: no data found in Package OE_Order_GRP Procedure Automatic_Account_Creation
message index is: 1
Order Line Update Failed

The below code is used in the custom program to update the order lines table columns
--This is to UPDATE order line
l_line_tbl_index :=1;
-- Changed attributes
l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
l_header_rec.header_id := v_cur.header_id;
l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
l_line_tbl(l_line_tbl_index) := OE_ORDER_PUB.G_MISS_LINE_REC;
l_line_tbl(l_line_tbl_index).operation := OE_GLOBALS.G_OPR_UPDATE;
l_line_tbl(l_line_tbl_index).header_id := v_cur.header_id;
l_line_tbl(l_line_tbl_index).line_id := v_cur.line_id;
l_line_tbl(l_line_tbl_index).REVREC_SIGNATURE_DATE := SYSDATE;
l_line_tbl(l_line_tbl_index).accepted_by := Fnd_Global.USER_ID;
l_line_tbl(l_line_tbl_index).REVREC_COMMENTS := 'Auto Accepted';
l_line_tbl(l_line_tbl_index).ACCEPTED_QUANTITY := v_cur.ordered_quantity;

-- CALL TO PROCESS ORDER
OE_ORDER_PUB.process_order (
p_api_version_number => 1.0
, p_init_msg_list => fnd_api.g_true
, p_return_values => fnd_api.g_true
, p_action_commit => fnd_api.g_true
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
, p_header_rec => l_header_rec
, p_line_tbl => l_line_tbl
, p_action_request_tbl => l_action_request_tbl
-- OUT PARAMETERS
, x_header_rec => p_header_rec
, x_header_val_rec => x_header_val_rec
, x_Header_Adj_tbl => x_Header_Adj_tbl
, x_Header_Adj_val_tbl => x_Header_Adj_val_tbl
, x_Header_price_Att_tbl => x_Header_price_Att_tbl
, x_Header_Adj_Att_tbl => x_Header_Adj_Att_tbl
, x_Header_Adj_Assoc_tbl => x_Header_Adj_Assoc_tbl
, x_Header_Scredit_tbl => x_Header_Scredit_tbl
, x_Header_Scredit_val_tbl => x_Header_Scredit_val_tbl
, x_line_tbl => p_line_tbl
, x_line_val_tbl => x_line_val_tbl
, x_Line_Adj_tbl => x_Line_Adj_tbl
, x_Line_Adj_val_tbl => x_Line_Adj_val_tbl
, x_Line_price_Att_tbl => x_Line_price_Att_tbl
, x_Line_Adj_Att_tbl => x_Line_Adj_Att_tbl
, x_Line_Adj_Assoc_tbl => x_Line_Adj_Assoc_tbl
, x_Line_Scredit_tbl => x_Line_Scredit_tbl
, x_Line_Scredit_val_tbl => x_Line_Scredit_val_tbl
, x_Lot_Serial_tbl => x_Lot_Serial_tbl
, x_Lot_Serial_val_tbl => x_Lot_Serial_val_tbl
, x_action_request_tbl => p_action_request_tbl
);

Cause

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