Oracle Application TOP

How to find Application TOP

To find oracle application top you can use below Query...

Query:

SELECT variable_name,
  VALUE
   FROM fnd_env_context
  WHERE variable_name LIKE 'AP\_TOP' ESCAPE '\'
 AND concurrent_process_id =
  (SELECT MAX(concurrent_process_id) FROM fnd_env_context
  )
 ORDER BY 1;

 

Please not that you can find more important info from this "fnd_env_context" table that i have used above. 

So, I request you to check this table in details. 

If you are oracle apps dba then it will be helpful for you.

 

 You can find me on Fiverr & LinkedIn

adpreclone.pl Fails on Applications Tier With Error Message "Edit session is enabled in domain"

Edit session is enabled in domain.Please activate all of your changes before proceed clone

 

if you are facing same error while running adpreclone.pl on Application server, then try this solution.

Solution:

a) Login to the WLS Console

b) Review the "Change Center" and click the "Release Configuration"

c) You should see the domain in "Lock & Edit" mode.

d) Re-run adpreclone on the Applications Tier.

 

You can find me on Fiverr & LinkedIn

How to change session time out in oracle application

 In this post we will learn how to change session time out.

you can do it for any specific user by using user ID or you can ignore user ID if you want to change it for all user in oracle application

It is a system administrator job, So you must have system administrator responsibility. 

Now, just follow below 3 images, 

I have mentioned every single point in image by red circle, you just follow images.

You can find me on Fiverr & LinkedIn

phase codes and status codes | Oracle Applications Concurrent Request

 

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