Happy New Year

You might be wondering where I have been for so long, Officially we were busy in our Dev server movement to some other location internally and at personal front we blessed with a Baby Boy on Christmas Eve (24th Dec). So was busy or would say too busy to look at this site. Today got some time so thought of sharing good news with you all and Wish Happy New Year to all of you out there. On Funny side :
"May all your troubles last as long as your New Year's resolutions."

Happy Troubleshooting !!!

What is significance of 0 & Y while using ( FNDCPASS, FNDLOAD, WFLOAD .....) .

Another in a row for Basics:

-'0' refers to the ( Concurrent Program ) request ID , as Invocation isNOT from the concurrent program SRS where in each Concurrent Request is assigneda non-zero id.

- 'Y' is the value for a flag that indicates the method of invocation is directly from the command-line not from the SRS.

Note: SRS (Standard Request Submission)
Happy Troubleshooting !!!

Meaning of Codes in FND_CONCURRENT_REQUESTS table?

Back to Basics, we use this daily and forget what they mean internally. so Today I thought of going back to Apps DBA Basics and giving meaning of the codes in the status_code and phase_code columns of the FND_CONCURRENT_REQUESTS table?

STATUS_CODE Column:
A Waiting
B Resuming
C Normal
D Cancelled
E Error
F Scheduled
G Warning
H On Hold
I Normal
M No Manager
Q Standby
R Normal
S Suspended
T Terminating
U Disabled
W Paused
X Terminated
Z Waiting

PHASE_CODE column.
C Completed
I Inactive
P Pending
R Running

Happy Troubleshooting !!!