1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Open sales headers with no open lines

Discussion in 'Oracle SCM & Manufacturing' started by mist, Nov 13, 2013.

  1. mist

    mist Active Member

    Messages:
    59
    Likes Received:
    2
    Trophy Points:
    160
    Hi all,

    I found 598 records where the sales order header is open but there are no open lines, How can i change the status please help me on this

    Thank you in advance
    Best Regards,
    Mist
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Mist,

    Try submitting the program as shown in the below screenshot:
     

    Attached Files:

    mist likes this.
  3. mist

    mist Active Member

    Messages:
    59
    Likes Received:
    2
    Trophy Points:
    160
    Hi Bharat,
    Thanks for quick reply and i am not getting any changes to me and could you please send me the navigation please and i checked on the oe_order_lines_all(flow_status_code=Closed) , wf_item_activity_statuses (activity_status='COMPLETE') , is there any others joins b/w two tables please help me

    Thank you
    Mist
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Have you submitted the program ?

    We can see this program in Order Management or in System Administrator responsibility. You can submit from anyone of the responsibility.

    From there view menu option --> Requests --> Submit a New Request (Press Button) --> OK (Press Button). Then search for program name in the List of Values and enter parameters as shown in the below screenshot.

    Program Name: Workflow Background Process

    Once you done the program completed then you can see the status in OE_ORDER_HEADERS_ALL (FLOW_STATUS_CODE = Closed)
     
    mist likes this.
  5. mist

    mist Active Member

    Messages:
    59
    Likes Received:
    2
    Trophy Points:
    160
    Thanks Bharat,

    It is working fine now.

    Thank you
     
  6. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Order Header got closed now after running that ?
     
  7. mist

    mist Active Member

    Messages:
    59
    Likes Received:
    2
    Trophy Points:
    160
    Yes

    Regards,
    Mist
     
    Bharat likes this.