This content has been marked as final. Show 4 replies
Any clue on that ?
Thanks for your help
Try oe_order_pub.process_order , you can specify line prce adjustment values here
You can do it through
API. Following parameters are handy when you pass adjustment info for a sales order.
Also at the line level the folowing parameter must be checked.
l_adj_rec.list_header_id := 8988; -- Modifier id l_adj_rec.list_line_id := 16596; -- Modifier line id l_adj_rec.automatic_flag := 'N'; l_adj_rec.list_line_type_code := 'DIS'; -- Change this if it is a surcharge, pass 'SUR' l_adj_rec.arithmetic_operator := 'AMT'; -- Percentage or amount l_adj_rec.operand := 10; --How much? l_adj_rec.operation := oe_globals.g_opr_create; l_adj_rec.line_index := 1; l_adj_rec.update_allowed := 'Y'; l_adj_rec.applied_flag := 'Y'; -- Rhis is required to change the price of the line l_adj_rec.change_reason_code := 'MANUAL'; l_adj_rec.change_reason_text := 'Manually applied adjustments';
p_line_tbl(1).calculate_price_flag := 'P'
Check the following MOS notes:
How Does One Use The OE_ORDER_PUB.PROCESS_ORDER Api For Manual Adjustment or Freight Application? [ID 959783.1]
Can One Use oe_order_pub.process_order API to Create an Order Line With a Selling Price Different Than the List Price? [ID 1072272.1]
Pricing API to check whether a modifier line is qualified for an sales order line id [ID 1220034.1]
Process Order API - How To Scripts [ID 1265721.1]
FAQ on Order Import [ID 1275116.1]
Process Order API In Order Management [ID 746787.1]
Process Order API - Errors / Issues [ID 1266249.1]
Please refer the following threads for detail:
Use the "helpful" or "correct" buttons to award points to replies / Mark the thread as answered, if your question is answered.
Feed back has been delayed, due to 'Long technical resource unavailability'
Using your answer, the issue is now solved, using the code behing the link : https://kr.forums.oracle.com/forums/thread.jspa?threadID=684887
with this change : l_adj_rec.arithmetic_operator := 'NEWPRICE'; -- Percentage or amount
Thanks very much