Self Service Form
If we want to launch the form directly without login to front end then we can use the selfservice form link.
If the form is in servlet mode :
Servlet mode:- http://<server name>:<port>/forms/frmservlet
If the form is in socket mode :
Socket mode:- http://<server name>:<port>/OA_HTML/frmservlet
If the form is in servlet mode :
Servlet mode:- http://<server name>:<port>/forms/frmservlet
If the form is in socket mode :
Socket mode:- http://<server name>:<port>/OA_HTML/frmservlet
Query for Checking the Object Accessed by a particular SID
If we want to check the objects that a particular session id(SID) is accessing in oracle we can use the below SQL.
SELECT a.object,
a.owner,
a.type,
a.sid,
s.username,
s.osuser,
s.program
FROM v$access a,
v$session s
WHERE a.sid = s.sid
AND a.sid = &sid_to_check
ORDER BY a.object
SELECT a.object,
a.owner,
a.type,
a.sid,
s.username,
s.osuser,
s.program
FROM v$access a,
v$session s
WHERE a.sid = s.sid
AND a.sid = &sid_to_check
ORDER BY a.object
Upgrading the Java Plugin in Oracle Apps R12
Upgrading the Java Plugin in Oracle Apps R12
Steps to be followed:
1.Login to the Middle Tier(Web Node)
2.Set Application Environment
3.Shutdown Services on Web node
4.Go to the Jinitiator folder in Common Top
cd $COMMON_TOP/webapps/oacore/util/jinitiator
5.Copy the new version of Java Plugin to jintiator location
cp j2se16033.exe .
6. Run the txkSetPlugin.sh Script on Web Node(If multi node then run on all webnodes) $FND_TOP/bin/txkSetPlugin.sh 16033
7.Start services on web node
Some Useful Unix Commands
1.Deleting files older than N number of days ?
find . -name '*.trc' -mtime +[N in days] -exec rm {} \;
Command will delete files older then N days in that directory
2.Copying file keeping timestamp preserve
cp -ip file.txt file_txt_bkp
3.Listing files modified in last N days
find . -mtime -<ndays> -exec ls -lt {} \;
4.Sorting files based on Size of file ?
ls -l | sort -nrk 5 | more
du -sm *|sort -nr|head -10
5.Finding CPU & Memory detail
->cat /proc/cpuinfo (CPU)
->cat /proc/meminfo (Memory)
->topas
6.Finding if any service is listening on particular port or not ?
netstat -an | grep {port no}
7.Finding Process ID (PID) associated with any port ?
lsof | grep {port no.}
lsof should be installed and in path.Many times it will be installed eith root user.Make sure you have that permission.
9.Finding a pattern in some file in a directory ?
grep pattern file_name ( find pattern in particular file )
grep -i pattern file_name (find pattern ignoring the case)
10.Create symbolic link to a file ?
ln -s pointing_to_original_file symbolic_link_name
example
ln -s /home/text.txt test.txt
11.History of command executed in the unix box
fc -l
fc -e - ls ( Would execute the last ls command.)
History command will also do the same
history
12. Compressing a bigfile
zip -r new.zip new
or
compress file_name
13.Creating a tar file
tar -cvwf file.tar myfile.txt
14.Extracting the files from a tar file
tar -xvwf myfile.tar(System would unarchive (untar) the myfile.tar file into the current directory.)
tar -xvwzf myfile.tar.gz(System would unarchive (untar) the myfile.tar.gz file in the current directory.)
14.Extracting a gz file?
Use guzip command as follows:
gunzip file.gz
OR
gzip -d file.gz
15.Extract a tar.gz or .tgz file?
Files with extension tar.gz or .tgz are tar files compressed with gzip. On Unix system extract them with following command:
gunzip < file.tar.gz | tar xvf -
gunzip < file.tgz | tar xvf -
If you have GNU tar (Linux system) you can use the z option directly:
tar xvzf file.tar.gz
tar xvzf file.tgz
16.Using mailx command
echo "This is going to be body of the mail" |mailx -s "Subject:Testing" "false@gmail.com"
17.Checking the file system free and used space
df -gt
find . -name '*.trc' -mtime +[N in days] -exec rm {} \;
Command will delete files older then N days in that directory
2.Copying file keeping timestamp preserve
cp -ip file.txt file_txt_bkp
3.Listing files modified in last N days
find . -mtime -<ndays> -exec ls -lt {} \;
4.Sorting files based on Size of file ?
ls -l | sort -nrk 5 | more
du -sm *|sort -nr|head -10
5.Finding CPU & Memory detail
->cat /proc/cpuinfo (CPU)
->cat /proc/meminfo (Memory)
->topas
6.Finding if any service is listening on particular port or not ?
netstat -an | grep {port no}
7.Finding Process ID (PID) associated with any port ?
lsof | grep {port no.}
lsof should be installed and in path.Many times it will be installed eith root user.Make sure you have that permission.
9.Finding a pattern in some file in a directory ?
grep pattern file_name ( find pattern in particular file )
grep -i pattern file_name (find pattern ignoring the case)
10.Create symbolic link to a file ?
ln -s pointing_to_original_file symbolic_link_name
example
ln -s /home/text.txt test.txt
11.History of command executed in the unix box
fc -l
fc -e - ls ( Would execute the last ls command.)
History command will also do the same
history
12. Compressing a bigfile
zip -r new.zip new
or
compress file_name
13.Creating a tar file
tar -cvwf file.tar myfile.txt
14.Extracting the files from a tar file
tar -xvwf myfile.tar(System would unarchive (untar) the myfile.tar file into the current directory.)
tar -xvwzf myfile.tar.gz(System would unarchive (untar) the myfile.tar.gz file in the current directory.)
14.Extracting a gz file?
Use guzip command as follows:
gunzip file.gz
OR
gzip -d file.gz
15.Extract a tar.gz or .tgz file?
Files with extension tar.gz or .tgz are tar files compressed with gzip. On Unix system extract them with following command:
gunzip < file.tar.gz | tar xvf -
gunzip < file.tgz | tar xvf -
If you have GNU tar (Linux system) you can use the z option directly:
tar xvzf file.tar.gz
tar xvzf file.tgz
16.Using mailx command
echo "This is going to be body of the mail" |mailx -s "Subject:Testing" "false@gmail.com"
17.Checking the file system free and used space
df -gt
The persistent store "_WLS_AdminServer" could not be deployed: weblogic.store.PersistentStoreException
<Error> <Store> <BEA-280061><The persistent store "_WLS_AdminServer" could not be deployed: weblogic.store.PersistentStoreException:
[Store:280105]The persistent file store "_WLS_AdminServer" cannot open file _WLS_ADMINSERVER000000.DAT.
If there is above issue while starting the weblogic server then the *.lok files and *.DAT files should be cleared.
Solution:
The files has to be cleared from $DOMIAN_HOME/servers/(server_name)
find . -name '*.DAT' -print -exec rm {} \;
find . -name '*.lok' -print -exec rm {} \;
For Example
For Admin server
$DOMAIN_HOME/servers/<server name>/tmp/Adminserver.lok
$DOMAIN_HOME/servers/<server name>/data/ldap/ldapfiles/Embedded.lok
$DOMAIN_HOME/servers/<server name>/data/store/default/_WLS_ADMINSERVER000000.DAT
$DOMAIN_HOME/servers/<server name>/data/store/diagnostics/WLS_DIAGNOSTICS000000.DAT
For Managed servers
$DOMAIN_HOME/servers/<server name>/tmp/<servername>.lok
$DOMAIN_HOME/servers/<server name>/data/ldap/ldapfiles/Embedded.lok
$DOMAIN_HOME/servers/<server name>/data/ldap/store/default/_WLS_<servername>000000.DAT
$DOMAIN_HOME/servers/<server name>/data/ldap/store/diagnostics/WLS_DIAGNOSTICS000000.DAT
[Store:280105]The persistent file store "_WLS_AdminServer" cannot open file _WLS_ADMINSERVER000000.DAT.
If there is above issue while starting the weblogic server then the *.lok files and *.DAT files should be cleared.
Solution:
The files has to be cleared from $DOMIAN_HOME/servers/(server_name)
find . -name '*.DAT' -print -exec rm {} \;
find . -name '*.lok' -print -exec rm {} \;
For Example
For Admin server
$DOMAIN_HOME/servers/<server name>/tmp/Adminserver.lok
$DOMAIN_HOME/servers/<server name>/data/ldap/ldapfiles/Embedded.lok
$DOMAIN_HOME/servers/<server name>/data/store/default/_WLS_ADMINSERVER000000.DAT
$DOMAIN_HOME/servers/<server name>/data/store/diagnostics/WLS_DIAGNOSTICS000000.DAT
For Managed servers
$DOMAIN_HOME/servers/<server name>/tmp/<servername>.lok
$DOMAIN_HOME/servers/<server name>/data/ldap/ldapfiles/Embedded.lok
$DOMAIN_HOME/servers/<server name>/data/ldap/store/default/_WLS_<servername>000000.DAT
$DOMAIN_HOME/servers/<server name>/data/ldap/store/diagnostics/WLS_DIAGNOSTICS000000.DAT
Chekcing Fragmentation in Table for Oracle DB
The below mentioned script can be used to check the table Fragmentation
Column owner Format A6
Column table_name Format A25
Column "Fragmented-Actual" Format A15
Column "Fragmented Size" Format A17
Column "Actual Data Size" Format A17
SELECT
owner,table_name,
round((blocks*8),2)||' kb' "Fragmented Size",
round((num_rows*avg_row_len/1024),2)||' kb' "Actual Data Size",
(round((blocks*8),2) - round((num_rows*avg_row_len/1024),2) )||' kb' "Fragmented-Actual"
FROM dba_tables
WHERE table_name = '&table_name' ;
Column owner Format A6
Column table_name Format A25
Column "Fragmented-Actual" Format A15
Column "Fragmented Size" Format A17
Column "Actual Data Size" Format A17
SELECT
owner,table_name,
round((blocks*8),2)||' kb' "Fragmented Size",
round((num_rows*avg_row_len/1024),2)||' kb' "Actual Data Size",
(round((blocks*8),2) - round((num_rows*avg_row_len/1024),2) )||' kb' "Fragmented-Actual"
FROM dba_tables
WHERE table_name = '&table_name' ;
Checking RUP Patchset Level in Oracle Apps
Below script can be used to Find the RUP Patchset level in Oracle Apps
SELECT
bug_number,
decode(bug_number,
'4334965', '11i.ATG_PF.H RUP3',
'4676589', '11i.ATG_PF.H.RUP4',
'5473858', '11i.ATG_PF.H.RUP5',
'5903765', '11i.ATG_PF.H.RUP6',
'6241631','11i.ATG_PF.H.RUP7') RUP_Patch_Description
FROM ad_bugs
WHERE
bug_number in ( '4334965','4676589','5473858','5903765','6241631') ;
SELECT
bug_number,
decode(bug_number,
'4334965', '11i.ATG_PF.H RUP3',
'4676589', '11i.ATG_PF.H.RUP4',
'5473858', '11i.ATG_PF.H.RUP5',
'5903765', '11i.ATG_PF.H.RUP6',
'6241631','11i.ATG_PF.H.RUP7') RUP_Patch_Description
FROM ad_bugs
WHERE
bug_number in ( '4334965','4676589','5473858','5903765','6241631') ;
Checking Forms Server is in Socket mode or Servlet Mode
We have certain ways through which we can check if the forms is in servlet mode or socket mode.
R12
$grep connectMode $FORMS_WEB_CONFIG_FILE
connectMode=servlet
or
$ grep s_frmConnectMode $CONTEXT_FILE
<forms_connect oa_var="s_frmConnectMode">servlet</forms_connect>
11i
$ grep connectMode $FORMS60_WEB_CONFIG_FILE
connectMode=socket
or
$ grep s_frmConnectMode $CONTEXT_FILE
<forms_connect oa_var="s_frmConnectMode">socket</forms_connect>
From Frontend
- Check "connectMode" in Jinitiator Console Window
R12
$grep connectMode $FORMS_WEB_CONFIG_FILE
connectMode=servlet
or
$ grep s_frmConnectMode $CONTEXT_FILE
<forms_connect oa_var="s_frmConnectMode">servlet</forms_connect>
11i
$ grep connectMode $FORMS60_WEB_CONFIG_FILE
connectMode=socket
or
$ grep s_frmConnectMode $CONTEXT_FILE
<forms_connect oa_var="s_frmConnectMode">socket</forms_connect>
From Frontend
- Check "connectMode" in Jinitiator Console Window
FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508
Error:
FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508
Cause:
This may be occur while opening forms after clone or if the CUSTOM.pll and CUSTOM.plx files may be missing or got corrupted.
One more reasons may be that the forms path is not properly defined.
Solution:
Copy the custom.pll and custom.plx files from backup location to the $AU_TOP/resource directory structure.
Verify that the $FORMS60_PATH or FORMS_PATH has the correct path to the resource directory in the SID_HOSTNAME.env file in APPL TOP.
i.e
FORMS60_PATH=$AU_TOP/resource:$AU_TOP/forms/US:$AU_TOP/resource/US
export FORMS60_PATH
or
FORMS_PATH=$AU_TOP/resource:$AU_TOP/forms/US:$AU_TOP/resource/US
export FORMS_PATH
FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508
Cause:
This may be occur while opening forms after clone or if the CUSTOM.pll and CUSTOM.plx files may be missing or got corrupted.
One more reasons may be that the forms path is not properly defined.
Solution:
Copy the custom.pll and custom.plx files from backup location to the $AU_TOP/resource directory structure.
Verify that the $FORMS60_PATH or FORMS_PATH has the correct path to the resource directory in the SID_HOSTNAME.env file in APPL TOP.
i.e
FORMS60_PATH=$AU_TOP/resource:$AU_TOP/forms/US:$AU_TOP/resource/US
export FORMS60_PATH
or
FORMS_PATH=$AU_TOP/resource:$AU_TOP/forms/US:$AU_TOP/resource/US
export FORMS_PATH
Finding Value Set name from Flex value
Below command can be used for finding the value set name from a know flex value.
select ff.flex_value_set_id ,ff.flex_value_set_name,fv.flex_value
from apps.fnd_flex_values fv , apps.fnd_flex_value_sets ff
where ff.flex_value_set_id = fv.flex_value_set_id
and (
upper(attribute1) like '%&&VALUE_SET_VALUE%'
or upper(attribute2) like '%&&VALUE_SET_VALUE%'
or upper(attribute3) like '%&&VALUE_SET_VALUE%'
or upper(attribute4) like '%&&VALUE_SET_VALUE%'
or upper(attribute5) like '%&&VALUE_SET_VALUE%'
or upper(attribute6) like '%&&VALUE_SET_VALUE%'
or upper(attribute7) like '%&&VALUE_SET_VALUE%'
or upper(attribute8) like '%&&VALUE_SET_VALUE%'
or upper(attribute9) like '%&&VALUE_SET_VALUE%'
or upper(attribute10) like '%&&VALUE_SET_VALUE%');
select ff.flex_value_set_id ,ff.flex_value_set_name,fv.flex_value
from apps.fnd_flex_values fv , apps.fnd_flex_value_sets ff
where ff.flex_value_set_id = fv.flex_value_set_id
and (
upper(attribute1) like '%&&VALUE_SET_VALUE%'
or upper(attribute2) like '%&&VALUE_SET_VALUE%'
or upper(attribute3) like '%&&VALUE_SET_VALUE%'
or upper(attribute4) like '%&&VALUE_SET_VALUE%'
or upper(attribute5) like '%&&VALUE_SET_VALUE%'
or upper(attribute6) like '%&&VALUE_SET_VALUE%'
or upper(attribute7) like '%&&VALUE_SET_VALUE%'
or upper(attribute8) like '%&&VALUE_SET_VALUE%'
or upper(attribute9) like '%&&VALUE_SET_VALUE%'
or upper(attribute10) like '%&&VALUE_SET_VALUE%');
Creating Custom Top in Oracle Application
Below are the steps to create custom top in Oracle Application
Step 1: Go to APPL_TOP Dircetory in UNIX
Cd $APPL_TOP
Step 2: Create Custom Top Under APPL_TOP Dir
Mkdir CUSTNAME_TOP (Name of Directory)
Make sure all the files and Directories are same as Other Product Dir.
Step 3: Add Custom Top entry in APPLSYS.env file
Step 4: Login Oracle apps using SYSADMIN or AOL
Navigate: Applications->Register
Add your Custom top Entry Here
Application: CustomeApplication name
Short name: CUSTNAME
BasePath: CUSTNAME_TOP
Description: CustomApplication.
Step 5: Restart the Internal Concurrent Manager (ICM) for New Changes to take effect.
Step 6: Validate Custom Entry in
Select BASEPATH,PRODUCT_CODE,APPLICATION_SHORT_NAME
From fnd_application
Where application_Short_name like 'CUSTNAME_TOP%'
Step 1: Go to APPL_TOP Dircetory in UNIX
Cd $APPL_TOP
Step 2: Create Custom Top Under APPL_TOP Dir
Mkdir CUSTNAME_TOP (Name of Directory)
Make sure all the files and Directories are same as Other Product Dir.
Step 3: Add Custom Top entry in APPLSYS.env file
Step 4: Login Oracle apps using SYSADMIN or AOL
Navigate: Applications->Register
Add your Custom top Entry Here
Application: CustomeApplication name
Short name: CUSTNAME
BasePath: CUSTNAME_TOP
Description: CustomApplication.
Step 5: Restart the Internal Concurrent Manager (ICM) for New Changes to take effect.
Step 6: Validate Custom Entry in
Select BASEPATH,PRODUCT_CODE,APPLICATION_SHORT_NAME
From fnd_application
Where application_Short_name like 'CUSTNAME_TOP%'
There was an error while opening the file store file “_WLS_ADMINSERVER000000.DAT”
If we are facing an error like
<Error> <Store> <BEA-280061> <The persistent store “_WLS_AdminServer” could not be deployed: weblogic.store.PersistentStoreException: java.io.IOException: [Store:280021]There was an error while opening the file store file “_WLS_ADMINSERVER000000.DAT”
Solution
The may be *.lok and *.DAT files which need to be removed.
Command
find . -name "*.DAT" -print -exec rm {} \;
find . -name "*.lok" -print -exec rm {} \;
These has to be removed form $DOMAIN_HOME for Admin Server and Managed Server
<Error> <Store> <BEA-280061> <The persistent store “_WLS_AdminServer” could not be deployed: weblogic.store.PersistentStoreException: java.io.IOException: [Store:280021]There was an error while opening the file store file “_WLS_ADMINSERVER000000.DAT”
Solution
The may be *.lok and *.DAT files which need to be removed.
Command
find . -name "*.DAT" -print -exec rm {} \;
find . -name "*.lok" -print -exec rm {} \;
These has to be removed form $DOMAIN_HOME for Admin Server and Managed Server
TXK Technology Inventory Report
We can get the Technology Inventory Report for Oracle Database and Application.
Command:
perl $FND_TOP/patch/115/bin/txkInventory.pl will give a HTML output.
Synatx:
$ cd $FND_TOP/patch/115/bin
$ perl txkInventory.pl
Enter Apps password ? apps
Enter Report File name ? /temp/txk.html
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** STDOUT = $INST_TOP/apps//logs/appl/rgf/TXK/txkInventory.pl_Thu_Sep_13_07_02_02_2012_stdout.log
The output Reportfile /temp/txk.html will be generated successfully.
Command:
perl $FND_TOP/patch/115/bin/txkInventory.pl will give a HTML output.
Synatx:
$ cd $FND_TOP/patch/115/bin
$ perl txkInventory.pl
Enter Apps password ? apps
Enter Report File name ? /temp/txk.html
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** STDOUT = $INST_TOP/apps//logs/appl/rgf/TXK/txkInventory.pl_Thu_Sep_13_07_02_02_2012_stdout.log
The output Reportfile /temp/txk.html will be generated successfully.
REP-0185: Bad load arguments supplied when starting up the Reports Server
In Oracle Apps 11i there might be issue while starting the report server after clone.
Error :
Error :
07/11/12-15:02:02
:: starting Reports Server for Instance_name on port 7010.
REP-0185:
Bad load arguments supplied when starting up the Reports Server
07/11/12-15:02:10
:: adrepctl.sh: exiting with status 0
Solution:
Please move the file
$ORACLE_HOME/reports60/server /REP60_"$TWOTASK".ora to $ORACLE_HOME/reports60/server /REP60_"$TWOTASK".ora_bkp
Please try restarting the server.
adrepctl.sh start
Enabling Maintenace Mode without using ADADMIN
Enabling and Disabling of maintenance mode can be done through ADADMIN.
But the same can be also done from executing SQL scripts as below.
Enabling Maintenance Mode:
sqlplus apps/appspassword
SQL>$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE
Disabling Maintenance Mode:
sqlplus apps/appspassword
SQL>$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE
Overview of appsweb.cfg file
appsweb.cfg is an important file for forms configuration. It basically
defines the paramater and its values used by forms.
This file will contain the below
information:
Form Server Name,Server Port,Domain
Name,Database Connection parameters,Connect mode and JInitiator version.Trace
on the forms can be also enabled from appsweb.cfg file.
The same information can also be
obtained from context file.
Location of the appsweb.cfg file
$OA_HTML/bin
or
$COMMON_TOP/html/bin
s_f60webcfg parameter can be checked
from context file to find the forms configuration file path.
Below are the some parameter name
from appsweb.cfg file and context file to find the details regarding forms.
|
ContextFileParameter
|
appsweb.cfg file parameter name
|
Description
|
Example Value
|
|
s_formshost
|
serverName
|
Name of FormsServer
|
test
|
|
s_formsdomain
|
domainName
|
Domain name of forms server
|
mydomain.com
|
|
s_frmConnectMode
|
connectMode
|
Connecting mode(Socket or Servlet)
|
socket
|
|
s_jinit_ver_comma
|
jinit_ver_name
|
Jinitiator Version delimited by ,
|
1,3,1,18
|
|
s_jinit_clsid
|
jinit_class_id
|
Jinitiator Class ID
|
PQRST-0014-0002-0031-ZYXWV
|
Finding the Apps password into the Configuration File
The Apps Password is stored in a flat files other than from being stored in Database.
Files which need to checked for apps password
File name: wbdbsvr.app
Location of the file: $IAS_ORACLE_HOME/Apache/modplsql/cfg/
File name: CGIcmd.dat
Location of the file : $ORACLE_HOME/reports60/server
If you are changing apps password then it would be required to change password in above files in 11i.
Overview of the Service Groups in Oracle Apps R12
All the services that are running in Oracle Apps R12 are now categorized into Service Groups from R12 version of Apps. According to these services groups different services run on single or multi-node.
Below are the name of the service group and the services associated with it.
Service Group Name
|
Services Running
|
Root Service Group
|
Oracle Process Manager(OPMN)
|
Web Entry Point Services
|
HTTP Server
|
Web Application Services
|
OACORE OC4J,Forms OC4J,OAFM OC4J
|
Batch Processing Services
|
Application TNS Listener, Concurrent Managers, Fulfillment
Server
|
Other Service Group
|
Oracle Forms Services, Oracle MWA Service
|
As per the node configuration the Service Group Associated with the each node might look as below.May vary as per your configuration
Node Type
|
Service Group Enabled
|
Web
Node
|
Root Service Group, Web Entry Point Services, Web
Application Services
|
Forms
Node
|
Root Service Group, Web Application Services, Other
Service Group
|
Concurrent
Processing Node
|
Root Service Group, Batch Processing Services
|
Subscribe to:
Posts
(
Atom
)
Posts
1 comment :
Post a Comment