This discussion is archived
7 Replies Latest reply: May 8, 2012 9:32 AM by Hussein Sawwan-Oracle RSS

Question on phase code and status codes

Bharat Newbie
Currently Being Moderated
Hello Everyone,

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

- ----------
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.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points