NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

Self Service Form

1 comment
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

1 comment :

Post a Comment

Query for Checking the Object Accessed by a particular SID

No comments
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

No comments :

Post a Comment

Upgrading the Java Plugin in Oracle Apps R12

2 comments
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

2 comments :

Post a Comment

Some Useful Unix Commands

No comments
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 

No comments :

Post a Comment

The persistent store "_WLS_AdminServer" could not be deployed: weblogic.store.PersistentStoreException

No comments
<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




No comments :

Post a Comment

Chekcing Fragmentation in Table for Oracle DB

1 comment
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' ;

1 comment :

Post a Comment

Checking RUP Patchset Level in Oracle Apps

No comments
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') ;

No comments :

Post a Comment

Checking Forms Server is in Socket mode or Servlet Mode

No comments
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

No comments :

Post a Comment

FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508

No comments
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

No comments :

Post a Comment

Finding Value Set name from Flex value

No comments
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%');

No comments :

Post a Comment

Creating Custom Top in Oracle Application

No comments
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%'

No comments :

Post a Comment

There was an error while opening the file store file “_WLS_ADMINSERVER000000.DAT”

No comments
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

No comments :

Post a Comment

TXK Technology Inventory Report

No comments
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.

No comments :

Post a Comment

REP-0185: Bad load arguments supplied when starting up the Reports Server

No comments
In Oracle Apps 11i there might be issue while starting the report server after clone.


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

No comments :

Post a Comment

Enabling Maintenace Mode without using ADADMIN

No comments
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

No comments :

Post a Comment

Overview of appsweb.cfg file

3 comments
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

3 comments :

Post a Comment

Finding the Apps password into the Configuration File

No comments
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.

 

No comments :

Post a Comment

Overview of the Service Groups in Oracle Apps R12

1 comment
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

1 comment :

Post a Comment