Thursday, September 26, 2013

A User Cannot See Newly Assigned Responsibilities

Issue: a new responsibility has been assigned to user ,but user not able to see the responsibility .

Solution :
1.clear the cache from functional administrator
2.runt the current request 'Workflow Directory Services User/Role Validation'

also can run
"Sync responsibility role data into the WF table."
"Synchronize WF LOCAL tables"

Thursday, June 13, 2013

VirtualBox Commands for Linux

1.Install Dependency Packages for VirtualBox

# yum update
# yum install binutils qt gcc make patch libgomp glibc-headers glibc-devel kernel-headers kernel-devel dkms

2.Install VirtualBox 4.2.10

    # yum install VirtualBox-4.2

3.Rebuild Kernel Modules for VirtualBox 4.2.10

# /etc/init.d/vboxdrv setup
OR
# service vboxdrv setup

4.Start VirtualBox

#VirtualBox

5.Update VirtualBox

# yum update VirtualBox-4.2


6.Remove VirtualBox

# cd /etc/yum.repos.d/
# rm -rf virtualbox.repo
# yum remove VirtualBox-4.2

Enable X11 forwarding




 Enable X11 forwarding

While doing ssh use the option -X to enable X11 forwarding.

$ ssh username@hostname -X
Enable trusted X11 forwarding, by using the -Y option,

$ ssh username@hostname -Y

Oracle virtualbox installation error on linux 5.6 (64 bit)



Oracle virtualbox installation error on linux 5.6 (64 bit) 

The errors while configure oracle virtual box on Linux.
Download VirtualBox for Redhat 5 64bit
Oracle VirtualBox Download

Error 1: 

[root@abc]# rpm -Uvh VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64.rpm
warning: VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64.rpm: Header V4 DSA signature: NOKEY, key ID 98ab5139
error: Failed dependencies:
        libSDL-1.2.so.0()(64bit) is needed by VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64

Solution:- 

========
when you face above error, you should install two rpms like follows [you can get it from your OS DVD (/media/RH../Packages/)]

SDL-1.2.14-2.el6.i686.rpm
SDL-1.2.14-2.el6.x86_64.rpm


[root@acb]# rpm -Uvh SDL-1.2.10-8.el5.i386.rpm
warning: SDL-1.2.10-8.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing...                ########################################### [100%]
   1:SDL                    ########################################### [100%]
[root@abc]# rpm -Uvh SDL-1.2.10-8.el5.x86_64.rpm
warning: SDL-1.2.10-8.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing...                ########################################### [100%]
   1:SDL                    ########################################### [100%]
Again I try to Install VirtualBox,
[root@abc]# rpm -Uvh VirtualBox-4.1-4.1.4_74291_rhel5-1.x86
warning: VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64.rpm: Header V4 DSA signature:
Preparing...                ########################################### [100%]
   1:VirtualBox-4.1         ########################################### [100%]

Creating group 'vboxusers'. VM users must be member of that group!

No precompiled module for this kernel found -- trying to build one. Messages
emitted during module compilation will be logged to /var/log/vbox-install.log.

Stopping VirtualBox kernel modules [  OK  ]
Uninstalling old VirtualBox DKMS kernel modules [  OK  ]
Trying to register the VirtualBox kernel modules using DKMS [FAILED]
  (Failed, trying without DKMS)
Recompiling VirtualBox kernel modules [FAILED]
  (Look at /var/log/vbox-install.log to find out what went wrong)
This time virtulbox was installed but i got a dkms error. this condition , you need to download
dkms-2.1.1.2-1.el5.rf.noarch.rpm package.
dkms-2.1.1.2-1.el5.rf.noarch.rpm
[root@abc]# rpm -Uvh dkms-2.1.1.2-1.el5.rf.noarch.rpm
warning: dkms-2.1.1.2-1.el5.rf.noarch.rpm: Header V3 DSA signature: NOKEY, key ID 6b8d79                                                                     e6
error: Failed dependencies:
        kernel-devel is needed by dkms-2.1.1.2-1.el5.rf.noarch
Dependencies rpm package need. the above kernel-devel get it from OS DVD.
[root@abc]# rpm -Uvh kernel-devel-2.6.18-238.el5.x86_64.rpm
warning: kernel-devel-2.6.18-238.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID                                                                      37017186
Preparing...                ########################################### [100%]
   1:kernel-devel           ########################################### [100%]
[root@abc]# rpm -Uvh dkms-2.1.1.2-1.el5.rf.noarch.rpm
warning: dkms-2.1.1.2-1.el5.rf.noarch.rpm: Header V3 DSA signature: NOKEY, key ID 6b8d79                                                                     e6
Preparing...                ########################################### [100%]
   1:dkms                   ########################################### [100%]
Again I try to install Oracle Virtulbox
[root@abc]# rpm -Uvh VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64.rpm
warning: VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64.rpm: Header V4 DSA signature: NOKEY,                                                                      key ID 98ab5139
Preparing...                ########################################### [100%]
        package VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64 is already installed


It show package already Installed, just remove this rpm package and install it again.
[root@abc]# rpm -e VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64
[root@abc]# rpm -Uvh VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64.rpm
warning: VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64.rpm: Header V4 DSA signature: NOKEY,                                                                      key ID 98ab5139
Preparing...                ########################################### [100%]
   1:VirtualBox-4.1         ########################################### [100%]

Creating group 'vboxusers'. VM users must be member of that group!

No precompiled module for this kernel found -- trying to build one. Messages
emitted during module compilation will be logged to /var/log/vbox-install.log.

Stopping VirtualBox kernel modules [  OK  ]
Uninstalling old VirtualBox DKMS kernel modules [  OK  ]
Trying to register the VirtualBox kernel modules using DKMS [  OK  ]
Starting VirtualBox kernel modules [  OK  ]
[root@abc]#

Rebuild Kerel Modules for VirtualBox 

#service vboxdrv setup
Or /etc/init.d/vboxdrv setup

Start VirtualBox

#VirtualBox
OR
Now Everything was okay.
Go to –> Applications –> System Tools –> Oracle VM VirtualBox

Monday, June 10, 2013

How to add or remove the "About This Page" link on E-Business Suite Framework pages


1.In order to add the "About This page " link ,need to set profile at user level

         Personalize Self-Service Defn =yes
         FND: Diagnostics = Yes
         FND: Personalization Region Link Enabled = YES
         Disable Self-Service Personal = NO (Only at Site)

2.In order to remove  the "About This page " link ,need to set profile at user level

            Personalize Self-Service Defn =No
            FND: Diagnostics = No

Ref:  400042.1

Wednesday, May 8, 2013

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]

Thursday, March 7, 2013

PO: Notification Lines Display Limit




Profile to 'PO: Notification Lines Display Limit' to restrict the no of lines displace in requisition , this parameter can be set a user level.

Ref: Number of Requisition Lines in Notification Exceeds Profile Option PO: Notification Lines Display Limit Value [ID 1343304.1]

Purge Obsolete Workflow Runtime



Issue : PR Returned and Rejection notification doesnot last for more than one day in worklist

Solution : Change the age parameter in Purge Obsolete Workflow Runtime Data request to run each day with the following parameters:

Item Type = NULL
Item Key = NULL
Age = 0                                 -----7 
Persistence Type = Temporary
Core Workflow Only = Y
Commit Frequency = 500
Signed Notifications = N

with these parameter Age to 7. only  notifications older than 1 week should be purged

Thursday, February 28, 2013

ORA-20100: Error: FND_FILE failure. Unable to create file

Issue : ORA-20100: Error: FND_FILE failure. Unable to create file 
        when run any request which are in large .


Solution : check the paremeter  UTL_FILE_DIR and delete the old tmp files 

Monday, February 11, 2013

File -> Export, it flashes and then goes away, with nothing being exported

Issue : File -> Export, it flashes and then goes away, with nothing being exported in oracle EBS


Solution:
         Need to check the Alert log for any ORA-1653  temporary tablespaces, and allocate more space.
        found : ORA-1653: unable to extend table CTXSYS.DR$WAITING by 1598 in  tablespace CTXD

       so  increased the tablespace CTXD .



Ref:Information You Should Upload When Creating an SR for File Export and Attachments [ID 427964.1]


Monday, January 21, 2013

PRC: Refresh Project Summary Amounts



If you proceed with the change to an earlier PA Reporting Period when projects have been accumulated in a later PA period, you need to run the PRC: Refresh Project Summary Amounts process before viewing information in the Project Summary Inquiry (PSI) window.

Thursday, January 17, 2013

JVM tunning for Oracle EBS



Configuring various JVM tuning parameters for Oracle E-Business suite 11i and R12 [ID 567551.1]
JVM: Guidelines to setup the Java Virtual Machine in Apps Ebusiness Suite 11i and R12 [ID 362851.1]

Custom Reports with PDF output heap issue




Issue : The following issue in custom report for pdf output


"Error occurred during initialization of VM
Could not reserve enough space for object heap
"



Solution :
change all concurrent requets options from  "-Xms1024M -Xmx1024M"   to "-Xms128M -Xmx512M"


Ref:

Configuring various JVM tuning parameters for Oracle E-Business suite 11i and R12 [ID 567551.1]
JVM: Guidelines to setup the Java Virtual Machine in Apps Ebusiness Suite 11i and R12 [ID 362851.1]

Sunday, January 13, 2013

oracle.apps.xdo.oa.cp.JCP4XDODataEngine Could not reserve enough space for object heap



when we ran any request for pdf or xml getting error :

======================================================================

Error occurred during initialization of VM
Could not reserve enough space for object heap
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

oracle.apps.xdo.oa.cp.JCP4XDODataEngine
Program exited with status 1
====================================================

Solution : go Concurrent Manager ->Administrator 
         Output Post Processor   restart and activate 

or 
a)
SELECT xcp.xdo_cfg_name "Property",DECODE (TO_CHAR (xcv.config_level),'10', 'Site','30', 'DataSource','50', 'Template','???')"Level",DECODE (TO_CHAR (xcv.config_level),'10', '','30', xd.application_short_name || '|' || xd.data_source_code,
'50', xt.application_short_name || '|' || xt.template_code,
'???') "Context",DECODE (TO_CHAR (xcv.config_level),'10', '','30', 
xd.data_source_name,'50', xt.template_name,'???') "Context Details",xcv.VALUE
FROM xdo_config_values xcv, xdo_ds_definitions_vl xd,xdo_templates_vl xt,xdo_config_properties_b xcp
WHERE xcp.property_code = xcv.property_code
AND xd.application_short_name(+) = xcv.application_short_name
AND xd.data_source_code(+) = xcv.data_source_code
AND xt.application_short_name(+) = xcv.application_short_name
AND xt.template_code(+) = xcv.template_code
ORDER BY xcv.config_level; 

b) 
select 
DEVELOPER_PARAMETERS 
from FND_CP_SERVICES
where SERVICE_ID = (select 
MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 
'FNDCPOPP'); 
ANS:J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx512m

and update 

3.1 Increase Java heap size for the OPP to higher value. The maximum is 2048MB 
(2GB).

UPDATE fnd_cp_services
SET developer_parameters ='J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m
WHERE service_id = (SELECT manager_type
FROM fnd_concurrent_queues WHERE concurrent_queue_name = 'FNDCPOPP');

Note This update will override the default -Xms384m setting for the JVM as defined by AFJSMARG environment variable in the Apps environment file.

$ echo $AFJSMARG
-server -Xmx384m 
-XX:NewRatio=2 -XX:+UseSerialGC 
-Doracle.apps.fnd.common.Pool.leak.mode=stderr:off -verbose:gc