Process Order API Errors With ORA-01403: No Data Found In Package OE_Order_GRP Procedure Automatic_Account_Creation (Doc ID 1929471.1)

Last updated on JULY 12, 2024

Applies to:

Symptoms

When running a custom Concurrent Program that uses one procedure to update the OE_ORDER_LINES_ALL table columns through the OE_ORDER_GRP, the following error occurs:

ERROR

STEPS:

The below code is used in the custom program to update the order line 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);

Changes

Cause

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