phase codes and status codes | Oracle Applications Concurrent Request
Table to find status code and phase code: FND_CONCURRENT_REQUESTS
Phase Code:
| C | Completed |
| I | Inactive |
| P | Pending |
| R | Running |
Status Code:
| A | Waiting |
| B | Resuming |
| C | Normal |
| D | Cancelled |
| E | Error |
| G | Warning |
| H | On Hold |
| I | Normal |
| M | No Manager |
| P | Scheduled |
| Q | Standby |
| R | Normal |
| S | Suspended |
| T | Terminating |
| U | Disabled |
| W | Paused |
| X | Terminated |
| Z | Waiting |
You can find me on Fiverr & LinkedIn
If you are looking for a query to find concurrent request that submitted by a specific user and the status of request with some additional info, Then you you can try this Query.
In this case you need to enter the user name and you will get required output
Query:
SELECT
user_concurrent_program_name,
responsibility_name,
request_date,
request_id,
phase_code,
status_code
FROM
fnd_concurrent_requests fndcr,
fnd_concurrent_programs_tl fndcp,
fnd_responsibility_tl fndr,
fnd_user fndu
WHERE
fndcr.CONCURRENT_PROGRAM_ID = fndcp.concurrent_program_id
and fndcr.responsibility_id = fndr.responsibility_id
and fndcr.requested_by = fndu.user_id
and user_name = upper(:user_name);
If anything else to know about this issue, Please comment below.
