4 Replies Latest reply: Jan 2, 2013 9:05 AM by 971206 RSS

    Exemple of API : update line selling price

    971206
      Hi,

      Context : EBS 11.5.10. Standard pricing (No Advance Pricing)

      I would appreciate if someone could send an exemple of API used to update the unit selling price of a sales order line.

      Currently we are using oe_order_pub.process_line, the problem seems that no adjustment is generated by the API (As it does when updating manually the line price).

      Thanks for your help

      Regards

      Antoine
        • 1. Re: Exemple of API : update line selling price
          971206
          Hi,

          Any clue on that ?

          Thanks for your help

          Regards

          Antoine
          • 2. Re: Exemple of API : update line selling price
            971425
            Try oe_order_pub.process_order , you can specify line prce adjustment values here

            Thanks
            MV
            • 3. Re: Exemple of API : update line selling price
              597001
              You can do it through
              oe_order_pub.process_order
              API. Following parameters are handy when you pass adjustment info for a sales order.
              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';
              Also at the line level the folowing parameter must be checked.
              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:
              https://kr.forums.oracle.com/forums/thread.jspa?threadID=684887
              https://kr.forums.oracle.com/forums/thread.jspa?threadID=1122898


              Cheers,
              ND
              Use the "helpful" or "correct" buttons to award points to replies / Mark the thread as answered, if your question is answered.
              • 4. Re: Exemple of API : update line selling price
                971206
                Hi,
                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

                Regards
                Antoine