Installations/Configurations-Applications

December 1, 2017 How to Enable/Disable Maintenance Mode without using ADADMIN

APPS DBAInstallations/Configurations-Applications

Enable/Disable Maintenance Mode without using ADADMIN

We can Enable or Disable Maintenance mode without using ADADMIN through following given procedure:

Enable Maintenance Mode:

$sqlplus apps/appspassword

SQL>$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE

Disable Maintenance Mode:

$sqlplus apps/appspassword

SQL>$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

December 1, 2017 How to Add Responsibility to User from Back End

APPS DBAInstallations/Configurations-Applications

How to Add Responsibility to User from Back End

SYNTAX

fnd_user_pkg.addresp(username => Application User Name
,resp_app => Responsiblity_Application_Short_Name
,resp_key => Responsibility_Key
,security_group => Security_Group ‘Mostly it is ‘STANDARD’ so it can be hard coded it’
,description => Any comments you want
,start_date => Sysdate From Today
,end_date => Sysdate + any number of days which is required);

EXAMPLE

BEGIN
fnd_user_pkg.addresp (‘SYEDSAADALI‘,’SYSADMIN‘,’SYSTEM_ADMINISTRATOR‘,’STANDARD‘,
‘Add Sysadmin Responsibility to SYEDSAADALI‘, SYSDATE, SYSDATE + 100);
COMMIT;
DBMS_OUTPUT.put_line (‘Responsibility Added Successfully’);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ( ‘ Responsibility is not added due to ‘ || SQLCODE || SUBSTR (SQLERRM, 1, 100));
ROLLBACK;
END;

November 8, 2017 Different Statuses of Concurrent Manager

APPS DBAInstallations/Configurations-Applications

Different Statuses of Concurrent Manager

PENDING STATUS

Normal – Request is waiting for the next available manager. Currently all manager are running other requests.

Standby – Program to run request is incompatible with other program(s) currently running. The requests will be in the Conflict Resolution Manager’s queue. Once the other request with which the request is incompatible gets completed then the request will be executed.

Scheduled – Request is scheduled to start at a future time or date.

Waiting – A child request is waiting for its Parent request to mark it ready to run Request which runs sequentially will wait for a prior request to complete.

RUNNING STATUS

Normal – Request is running normally.

Paused – Parent request pauses for all its child requests to finish.

Resuming – All requests submitted by the same parent request (i.e. child requests) have completed running. The Parent request resumes running.

Terminating – Request is terminated forcefully by choosing the Cancel Request button in Concurrent Request window from front end.

COMPLETED STATUS

Normal – Request completed successfully.

Error – Request failed to complete successfully.

Warning – Request completed with warnings.

Cancelled – Pending or Inactive request is cancelled by choosing the Cancel Request button in the Concurrent Requests window from front end.

Terminated – Request is terminated by choosing the Cancel Request button in the Concurrent Requests window from front end. This states comes after Running-Terminating state.

INACTIVE STATUS

Disabled – Program to run request is not enabled. We need to Contact System Administrator.

On Hold – Pending request is placed on hold forcefully by choosing the Hold Request button in the Concurrent Requests window.

No Manager – No manager is defined to run the request or the manager needed to run the request is down. We need to Contact System Administrator. A status of No Manager is also given when all managers are locked by run-alone requests.

November 8, 2017 How to Stop Concurrent Manager Properly

APPS DBAInstallations/Configurations-Applications

How to Stop Concurrent Manager Properly

Step 1. Go to Oracle Application Scripts Home

$cd /apps/ebs/inst/apps/PROD_apps/admin/scripts

Step 2. Stop Concurrent Manager with the following script

$adcmctl.sh stop <appsusername/password>

Step 3. Check the Processes for Concurrent Manager, is it still running.

$ps -ef |grep FNDLIBR

Step 4. If there are processes running the we can manually kill the processes.

$kill -9 `ps -ef|grep FNDLIBR|awk ‘{print $2}’`

$ps -ef|grep FNDLIBR|awk ‘{print $2}’|xargs kill -9