Order Management - EBS (MOSC)

MOSC Banner

OE_ORDER_PVT Procedure process_order - ORA-01403 no data found

edited Mar 27, 2018 5:32PM in Order Management - EBS (MOSC) 5 commentsAnswered

Hi ,

We are facing issue in oe_order_pub.process_order API while performing delete operation on manual price adjustment.

Actually sometime it is working properly but sometime it is giving error as 'ORA-01403: no data found in Package OE_Order_PVT procedure process order'


Can anybody please help.


Sample code is as follows-

  l_line_adj_tbl := oe_order_pub.g_miss_line_adj_tbl;

                     l_num_count := 1;

                     FOR rec_line_price_adj_id IN

                        cur_line_price_adj_id (l_num_line_id)

                     LOOP

                        l_line_adj_tbl (l_num_count) :=

                                             oe_order_pub.g_miss_line_adj_rec;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center