Order Management - EBS (MOSC)

MOSC Banner

OM: Apply discount on an order line

edited Jul 18, 2014 3:04AM in Order Management - EBS (MOSC) 2 commentsAnswered ✓

Hi Team

I am trying to apply Discount precisely Coupon while importing Order using Order Import.

I am using the below script:

INSERT INTO oe_headers_iface_all (order_source_id,
                                  orig_sys_document_ref,
                                  order_number,
                                  org_id,
                                  ordered_date,
                                  order_type,
                                  price_list_id,
                                  customer_id,
                                  sold_to_org_id,
                                  booked_flag,
                                  closed_flag,
                                  created_by,
                                  creation_date,
                                  last_updated_by,
                                  last_update_date)
  VALUES   (6,
            'PP_COUPON2',
            8745616,
            82,
            SYSDATE,
            'Standard Sales',
            80026,
            65819,
            65819,
            'N',
            'N',
            -1,
            SYSDATE,
            -1,
            SYSDATE);

----Line----

INSERT INTO oe_lines_iface_all (order_source_id,
                                orig_sys_document_ref,
                                orig_sys_line_ref,
                                org_id,
                                ordered_quantity,

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