Automatic startup and shutdown Oracle R12 on Linux

Automatic start up and shutdown Oracle EBS R12 on Linux
After installation on Linux, when the server restarted, the application will not started automatically.
 To start the application automaticaly, we need to create some scripts.

1. startDB.sh :to start the database,using oracle database user, create a file containing this script:

#! /bin/sh
. /oracle/VIS/db/tech_st/10.2.0/VIS_hostname.env
/oracle/VIS/db/tech_st/10.2.0/appsutil/scripts/VIS_oracle/addbctl.sh start
/oracle/VIS/db/tech_st/10.2.0/appsutil/scripts/VIS_oracle/addlnctl.sh start VIS

Then save it as startDB.sh.

2. stapDB.sh to stop the database using this script:
#! /bin/sh
. /oracle/VIS/db/tech_st/10.2.0/VIS_hostname .env
/oracle/VIS/db/tech_st/10.2.0/appsutil/scripts/VIS_oracle/addbctl.sh stop
/oracle/VIS/db/tech_st/10.2.0/appsutil/scripts/VIS_oracle/addlnctl.sh stop VIS
Then save it as stopDB.sh


3. startAPP.sh To start application use this script as applmgre:
#! /bin/sh
. /oracle/VIS/apps/apps_st/appl/VIS_hostname.env
$ADMIN_SCRIPTS_HOME/adstrtal.sh apps/apps
Then save it as startApps.sh

4.stopAPP.sh To stop application, use this script:
#! /bin/sh
. /oracle/VIS/apps/apps_st/appl/VIS_hostname.env
$ADMIN_SCRIPTS_HOME/adstpall.sh apps/apps

5. As root, create a file on /etc/init.d named startVIS containing this script:
#! /bin/sh
#
# /etc/init.d/R12_VIS
#

### BEGIN INIT INFO
# Provides: Oracle Applications
# Required-Start: $syslog $network $xvfbserver
# Required-Stop:
# Default-Start: 3 5
# Default-Stop: 0 1 2 6
# Description: Start the Oracle Applications server
### END INIT INFO

case "$1" in
start)
su oracle -c "/home/oracle/startDB.sh"
su applmgr -c "/home/applmgr/startAPP.sh"
#rc_status -v
;;
stop)
su applmgr -c "/home/applmgr/stopAPP.sh"
su oracle -c "/home/oracle/stopDB.sh"
#rc_status -v
;;

*)
echo "Usage: $0 {start|stop}"
exit 1
;;
esac

6.to add startVIS to the services list. Use this command as root:
chkconfig --add startVIS

assigned responsibility not appearing in the navigator page during login

Issue :
It is often experienced in Oracle Applications R12 that user has been assigned a responsibility but not able to see it while accessing it. However , everything seems fine with responsibility ,it is not end dated and looks good.

Solution : there is a concurrent request that does sync up of such users and responsibiltity in R12 version.

run concurrent request  'Workflow Directory Services User/Role Validation' with parameters 10000, yes, yes

OR

User data in the FND_USER, FND_RESPONSIBILITY, WF_LOCAL_USER_ROLES, and WF_USER_ROLE_ASSIGNMENTS tables is not valid.  To synchronize data follow the steps below:

1.  Navigate to the define user form (FNDSCAUS).
2.  Query up the user (that is having the issue) and insure the responsibility is NOT end dated.
3.  END DATE the USER (not the responsibility) and save the record.
4.  UNEND DATE the USER and save the record.
5.  Run the request 'Sync responsibility role data into the WF table'.
6.  Run the request "Synchronize WF LOCAL tables".
7.  Run the request "Workflow Directory Services User/Role Validation" (with parameters 10000, yes, yes, yes).
8.  Have the user log off and back on and verify that the responsibility appears.

Ref: 565130.1]