7 Replies Latest reply: May 8, 2012 11:32 AM by Hussein Sawwan-Oracle RSS

    Question on phase code and status codes

      Hello Everyone,

      SQL> select status_code,count(*) from fnd_concurrent_requests where phase_code='P' group by status_code;

      S COUNT(*)
      - ----------
      I 69
      Q 40

      As per the meaning of status_codes, there should be 40 in standby and 69 in normal but when I check from frontend , I could not match this count, nothing is there in normal status , instead I see all in scheduled state for which the code is F as per oracle documentation, Can some help me understand this equation.

      Thank You.