Order Management - EBS (MOSC)

MOSC Banner

How to remove HOLD based on Customer Criteria.

edited Aug 12, 2014 4:09AM in Order Management - EBS (MOSC) 6 commentsAnswered ✓

Hi All

I have imported an Order in EBS using order import program and also applied using Hold on the order using criteria based on Customer. I used the below script:

INSERT INTO oe_headers_iface_all (order_source_id,
                                  orig_sys_document_ref,
                                  creation_date,
                                  created_by,
                                  last_update_date,
                                  last_updated_by,
                                  operation_code,
                                  sold_to_org_id,
                                  order_type,
                                  booked_flag)
        VALUES   (6,
         'TESTING1',
         SYSDATE,
         -1,
         SYSDATE,
         -1,
         'INSERT',
         3046,
         'Standard Sales',
         '');

INSERT INTO oe_actions_iface_all (order_source_id,
                                  orig_sys_document_ref,
                                  org_id,
                                  operation_code,
                                  hold_id,
                                  hold_type_code,
                                  hold_type_id,

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