Order Management - EBS (MOSC)

MOSC Banner

Release sales order lines , 4000 lines in each sales order

edited Dec 17, 2012 10:15PM in Order Management - EBS (MOSC) 2 commentsAnswered
Dear Gurus,
I have 4 sales orders where each order is having 4000 lines each.

Now the user is unable to release the hold from the Front end.

So , I decided to develop some script to release the hold , for this i developed a procedure  where the agenda is to release the hold . the script is as follows.
=============================================================================================================================
create or replace 
PROCEDURE      XXONT_RELEASEHOLDS (p_user_name         VARCHAR2,
                                               p_order_num_low     NUMBER,
                                               P_Order_Num_High    Number
                                               ) IS
 CURSOR cur_orders_hold
   IS  
      SELECT  
               hdra.header_id
               ,hdra.order_number
               ,hsrc.hold_source_id
               ,hsrc.hold_id
        FROM   oe_order_headers_all hdra,

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