Friday, May 1, 2020

The stage registered as the first stage of this set is invalid.


  
  I have created request set using two concurrent programs.
  I ran the request set through SRS Window and I got below error.

  Error:  The stage registered as the first stage of this set is invalid.

  Action:

  In Request set Verify that the "Start Stage" is correct as follows:

   i)  Login to Oracle application and go to "System Administrator" responsibility

   ii)  Navigate to Request > Set


   iii) Query your request set

   iv) Click on the button "Link Stages"

   v)  Check the field "Start Stage" if empty then fill with the valid concurrent program name.

Then run your request set. 

Query to get Sales Order Customer details

  SELECT  ooha.order_number      ,  ooha.org_id      ,  ooha.sold_to_org_id bill_cust_account_id      ,  ooha.ship_to_org_id ship_to_site_us...