Using Mobile Devices with Oracle E-Business Suite

Support for iPhones and iPads
Oracle offers several official iPhone apps that are related to the E-Business Suite, including:
●● Oracle Business Approvals for Managers
●● Oracle Business Indicators
●● Maintenance Workbench for Oracle Enterprise Asset Management
●● Oracle CRM On Demand Integration Pack for Oracle E-Business Suite (Opportunity to Quote)
Apple has indicated that all existing iPhone apps will work transparently on the iPad as well.  Oracle teams who currently produce iPhone apps will be only too-pleased to justify their purchase of iPads to do these certifications.

Using smartphones and mobile devices with EBS self-service apps
●● Some E-Business Suite products offer web-based screens that can be accessed by standards-compliant browsers.  These products have HTML-screens, are built using OA Framework, and are sometimes referred to as "Self-Service Web Applications" (SSWA).
●● If a mobile browser is standards-compliant (e.g. passes the latest Acid test), it might work with the E-Business Suite's self-service HTML screens.  However, if you experience any issues with a mobile browser that cannot be reproduced on a certified desktop browser, our recommendation would be to use a desktop browser instead.

Latest Acid Test URL: http://acid3.acidtests.org/

Using smartphones and mobile devices with EBS Forms-based apps
Some E-Business Suite products run in Oracle Forms.  These Forms-based products require the use of Sun's Java Runtime Engine (JRE) to run.  Oracle tests the Sun JRE with Windows-based desktop clients.  Oracle does not test any mobile Java clients with E-Business Suite Forms-based products.

Using standards-compliant mail clients to approve Workflow notifications
Oracle Workflow is a key part of the E-Business Suite's technology stack.  It can be configured to send emails (via SMTP) that notify E-Business Suite users that certain EBS transactions are awaiting their approval.  E-Business Suite end-users can respond to those notification emails by clicking on a link in those emails, or responding with an email containing certain keywords in the body of a reply.
We would expect standards-compliant email clients to be able to handle Workflow notification emails properly, including email clients on mobile devices.  Some mobile email clients are unable to handle standards-based emails, and other email clients may truncate long Workflow notification emails.  These issues may prevent certain email clients on mobile devices from handling Workflow notifications properly.

Cheers !!!!!!!!!!!
Malay Khawas

Purge Concurrent Request and/or Manager Data

Ensure "Purge Concurrent Request and/or Manager Data, FNDCPPUR,"  is run at regular intervals with "Entity" parameter as "ALL".  A high number of records in FND_CONCURRENT tables can degrade the performance.
Functions of FNDCPPUR: It purges data on FND_CONCURRENT tables and log/output files.

Name: Purge Concurrent Request and/or Manager Data
Short Name: FNDCPPUR
Description: Purges Concurrent requests and/or Concurrent Manager data and log/output files

Parameter Listing:
1. Entity: ALL
2. Mode: Age
3. Mode Value : 10
4. Oracle ID: NULL
5. User Name: NULL
6. Responsibility Application: NULL
7. Responsibility: NULL
8. Program Application: NULL
9. Program: NULL
10. Manager Application: NULL
11. Manager: NULL
12. Report: Y
13. Purge Other: Y

For slow performance of "Purge Concurrent Request and/or Manager Data" set the system profile option "Concurrent: Force Local Output File Mode" to "Yes" and then retest. You may get a better performance of the program.

As per our recent purging strategy we are running “Purge Concurrent Request and/or Manager Data” concurrent request everyday at 21:30:00.
Short Name: FNDCPPUR
This request basically deletes data from FND_CONC related tables and log/out files from physical file system, but I have noticed that this request is not performing the task as required. Even we do have log files older than 2-3 Months.

As per Note ID: 822368.1 we have following workarounds(Oracle Apps Version: 11.5.10.2)
1. Apply patch#7834670
2. Set Profile option “Concurrent: Force Local Output File Mode” value to Yes (As of now value is No)
3. Retest the issue

Cheers !!!!
Malay

Issue with GCC RPM Package Installation:

Issue with GCC RPM Package Installation:

# rpm -ivh gcc-4.4.4-13.el6.x86_64.rpm
warning: gcc-4.4.4-13.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
error: Failed dependencies:
 cloog-ppl >= 0.15 is needed by gcc-4.4.4-13.el6.x86_64
 cpp = 4.4.4-13.el6 is needed by gcc-4.4.4-13.el6.x86_64


Install glibc-header:

# rpm -ivh glibc-headers-2.12-1.7.el6.x86_64.rpm
warning: glibc-headers-2.12-1.7.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:glibc-headers          ########################################### [100%]

Install glibc-devel:

# rpm -ivh glibc-devel-2.12-1.7.el6.x86_64.rpm
warning: glibc-devel-2.12-1.7.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:glibc-devel            ########################################### [100%]

Install cpp package:(it will fail)

# rpm -ivh cpp-4.4.4-13.el6.x86_64.rpm
warning: cpp-4.4.4-13.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
error: Failed dependencies:
 libmpfr.so.1()(64bit) is needed by cpp-4.4.4-13.el6.x86_64

As it is asking for libmpfr.so, we need to install mpfr RPM:

# rpm -ivh mpfr-2.4.1-6.el6.x86_64.rpm
warning: mpfr-2.4.1-6.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:mpfr                   ########################################### [100%]

Install cloog-ppl RPM:(to correct further issues)

# rpm -ivh cloog-ppl-0.15.7-1.2.el6.x86_64.rpm
warning: cloog-ppl-0.15.7-1.2.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
error: Failed dependencies:
 libppl.so.7()(64bit) is needed by cloog-ppl-0.15.7-1.2.el6.x86_64
 libppl_c.so.2()(64bit) is needed by cloog-ppl-0.15.7-1.2.el6.x86_64

As it needs libppl.so, install ppl RPM:

# rpm -ivh ppl-0.10.2-11.el6.x86_64.rpm
warning: ppl-0.10.2-11.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:ppl                    ########################################### [100%]

Install cloog-ppl RPM:

# rpm -ivh cloog-ppl-0.15.7-1.2.el6.x86_64.rpm
warning: cloog-ppl-0.15.7-1.2.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:cloog-ppl              ########################################### [100%]

Install cpp package:(it would be successful)

# rpm -ivh cpp-4.4.4-13.el6.x86_64.rpm
warning: cpp-4.4.4-13.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:cpp                    ########################################### [100%]

Now, try with GCC Installation:

# rpm -ivh gcc-4.4.4-13.el6.x86_64.rpm
warning: gcc-4.4.4-13.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing… ########################################### [100%]
1:gcc ########################################### [100%]

Cheers !!!!!!!
Malay Khawas

OAF Page Migration

OAF Page Migration

1. SCP the Directory Structure from Source(DEV) to Target(CRP2).
$ scp -r appldev@mkkserver1:${xx_srcjavatopxx}/xxmkk/oracle/apps/eam/cwsa/* ${JAVA_TOP}/xxmkk/oracle/apps/eam/cwsa/

2. Determine the Name of the XMLs that needs to be imported, webui and lov xmls are the one.
find . -name "*.xml" -print | grep webui

3. Run the XMLImporter Command in TARGET Instance:
adjava oracle.jrad.tools.xml.importer.XMLImporter XXMKKCreatePropVehiclePG.xml -username apps -password ${xx_appspassword} -rootdir ${JAVA_TOP} -dbconnection "(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=mkkserver2.mkkdomain.net)(PORT=1527)) (CONNECT_DATA= (SERVICE_NAME=MKKCRP2) (INSTANCE_NAME=MKKCRP2)))"

4. Restart only OACORE Service, nothing else is required.

HTTP Converted to HTTPS | SSLTERMINATOR in Context File

HTTP Converted to HTTPS | SSLTERMINATOR in Context File

While trying to open using http://mkkserver1.mkkdomain.net:8004/OA_HTML/AppsLocalLogin.jsp its opening the login page and can launch forms, but when going to any JSP Pages like OAM again its throwing error.

IEHTTP Header Log showing the following message:
HTTP/1.1 302 Moved Temporarily
Date: Mon, 14 Mar 2011 06:48:17 GMT
Cache-Control: no-cache
Pragma: no-cache
Expires: Thu, 01 Jan 1970 00:00:00 GMT
Location: https://mkkserver1.mkkdomain.net:8004/OA_HTML/AppsLocalLogin.jsp
Keep-Alive: timeout=15 >>>> Though it was http only, its getting converted to https
Connection: Keep-Alive
Transfer-Encoding: chunked
Content-Type: text/html

I have checked the $CONTEXT_FILE and verified that webentry, login URLs are perfect, but there is no HTTPS. Basically SSLTERMINATOR is creating the issue

Comment out SSLTERMINATOR in xml file and run autoconfig again. That will resolve the issue.
Hash out the s_enable_sslterminator parameter in $CONTEXT_FILE
Old Value: <sslterminator oa_var="s_enable_sslterminator"/>
New Value: <sslterminator oa_var="s_enable_sslterminator">#</sslterminator>

Changing Password of Java Keystores(WebLogic 11g)

Changing Password of Java Keystores(WebLogic 11g)


Set the environment by running setDomainEnv.cmd
${MW_HOME}/user_projects/domains/<domain name>/bin


cd ${JAVA_HOME}/lib/security/cacerts
keytool -list -v -keystore cacerts
It will prompt for password: enter the password ("changeit" is the default cacert password).


Take a backup of the cacerts files and run keytool store password:
keytool -storepasswd -keystore cacerts


Confirm that the Keystore Password is changed:
keytool -list -v -keystore cacerts


Now in the console you can apply the new password for the java keystore passphrase.


Use the below command for changing the password of a custom keystore:
keytool -storepasswd -new new_storepass -keystore <your_custom_keystore.jks>


Cheers !!!!!!!!!!!!!!!!!!!!

Details on ORA_NLS

Details on ORA_NLS:

You can check which NLS setting are valid for this platform by connecting to the database as a DBA and issuing the following command:
SELECT * FROM V$NLS_VALID_VALUES;

If this only returns US7ASCII then ORA_NLSxx was INCORRECTLY set during database startup.

To find out what character set you have, issue the following command:
SELECT * FROM NLS_DATABASE_PARAMETERS;

cd $ORACLE_HOME/nls/data
strings * | grep -i we8mswin1252
where we8mswin1252 is the NLS_CHARACTERSET used.

what is OI_NLS32?
OI_NLS32 is a parameter used by the Oracle Universal Installer and should NOT be altered.

What is the use of this ORA_NLSxx parameter?
ORA_NLSxx is used to indicate where Oracle RDBMS/client software can locate the defintions of Charactersets (used in NLS_LANG or as NLS_CHARACTERSET/NLS_NCHAR_CHARACTERSET), NLS_SORT, NLS_LANGUAGE (or derived/related parameters) or NLS_TERRITORY (or derived/related parameters).
Those definitions are stored in .nlb files who can be found in the ORA_NLSxx directory.

The Priority of NLS Parameters:
select * from NLS_INSTANCE_PARAMETERS;
Priority of NLS Parameter Settings: SESSION >>>> INSTANCE >>>> DATABASE.
NLS instance settings take precedence over NLS database settings, NLS session settings take precedence over NLS instance and NLS database settings.

HOW TO Add Concurrent Program to Request Group from Back End

HOW TO Add Concurrent Program to Request Group from Back End:

set serveroutput on
DECLARE
BEGIN
APPS.FND_PROGRAM.add_to_group
(
PROGRAM_SHORT_NAME => 'XXCTO_GPO_PRINT_REPORT',
PROGRAM_APPLICATION => 'XXCTO',
REQUEST_GROUP => 'XXCTO_REPORT_TEST',
GROUP_APPLICATION => 'SYSADMIN'
);
COMMIT;
exception
when others then
dbms_output.put_line('Request Already Exixts in Request Group');
END;
/

Changing Apps Password in EBS, what needs to be done in OID

Changing Apps Password in EBS, what needs to be done in OID

After updating the APPS user password in the E-Business Suite, user updates From OID to Ebiz fail with the following error:

Using Service Name to connect - URL : jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<<<ebs-db-host>>>)(PORT=1571))(CO
NNECT_DATA=(SERVICE_NAME=<<<ebs-db-sid>>>))),user : APPS
Exception Connecting to DB using service name :java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Retrying with SID ..
Using SID Name to connect - URL : jdbc:oracle:thin:@<<<ebs-db-host>>>:1571:<<<ebs-db-sid>>>,user : APPS
Using Service Name to connect - URL : jdbc:oracle:thin:@<<<ebs-db-host>>>:1571:<<<ebs-db-sid>>>,user : APPS
Exception Connecting to DB :java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Update the Oracle Internet Directory provisioning profile with the new APPS password. This can be done by running the Oracle Internet Directory oidprovtool command-line utility.

oidprovtool operation=modify \
profile_mode=INBOUND profile_status=enabled \
ldap_host=<OID Server hostname> ldap_port=<OID Server Port> \
ldap_user_dn="cn=orcladmin" ldap_user_password=<orcladmin Password> \
application_dn="<The LDAP distinguished name of the application>" \
interface_connect_info=<E-Business Suite connect info of the format, host:port:Sid:username: new updated password>

profile_mode = Run the following SQL as the APPS user
SELECT * FROM fnd_user_preferences WHERE preference_name = 'provisiontype';
1 = BOTH             
2 = INBOUND
3 = OUTBOUND    
4 = BOT

application_dn = Run the following SQL as the APPS user
SELECT * FROM fnd_user_preferences WHERE preference_name = 'USERNAME'

interface_connect_info = E-Business Suite connect info of the format, host:port:Sid:username:password

oidprovtool operation=modify \
profile_mode=INBOUND profile_status=enabled \
ldap_host=<<<ldap-host-name>>> ldap_port=3060 \
ldap_user_dn=cn="orcladmin" ldap_user_password=welcome1 \ 
application_dn="orclApplicationCommonName=ebizqa,cn=EBusiness,cn=Products,cn=OracleContext,dc=us,dc=oracle,dc=com" \
interface_connect_info=ebiz30qa:1521:ebizqa:apps:welcome2

orclODIPProfileName=EA3EFF8640819A51F0301990304E5D0B_EA960F743D5D7552F0301990304E34B3, cn=Provisioning Profiles, cn=Changelog Subscriber,cn=Oracle Internet Directory
The Provisioning Profile for the Application has been modified.

Oracle Developer Suite 10g and Windows 7

Oracle Developer Suite 10g and Windows 7

Yes it is certified... Refer the MOS Note for details......
Certification of Oracle Developer Suite 10g (10.1.2) on Windows 7 (32-bit) [ID 1292919.1]
Win 7 (32 bit) is supported for Dev Suite 10g

Oracle Developer Suite 10g and Windows 7 (64-bit):

Tips to Install:
>> Extract the setup files (version 101202) downloaded from otn.
>> Right click the installer setup.exe and go to properties, set compatibility to Windows XP SP2
>> Edit the virtual memory size to custom size from 1024m to 8000m, Restart it
>> Run the install using setup.exe

In my current assignment most of the PC's and Laptop's are Win 7.... Its working fine....

Profile Options Setup for the Implementation Team/Super User Support Team

Profile Options Setup for the Implementation Team/Super User Support Team

Personalize Self-Service Defn
Description: Personalize Self-Service Definitions
Value at User Level Should be Yes

FND: Diagnostics
Description: Enables Diagnostics Global Button
Value at User Level Should be Yes

Utilities:Diagnostics
Description: Value determines whether diagnostic utilities, such as Examine, may be used
Value at User Level Should be Yes

Hide Diagnostics menu entry
Value at User Level Should be No

How to Resend Failed/Error Workflow Notifications?

How to Resend Failed/Error Workflow Notifications?

Run "Resend Failed/Error Workflow Notifications" concurrent program to resend FAILED notifications.
This concurrent program will resend all the failed notifications to the user again.

How to check whether RELAY is Enabled in SMTP Server for the EBS Application Server

How to check whether RELAY is Enabled in SMTP Server for the EBS Application Server:

$ telnet smtpmail.mailserv.com 25
Trying...
Connected to smtpmail.mailserv.com.
Escape character is '^]'.
220 smtpmail.mailserv.com Microsoft ESMTP MAIL Service ready at Fri, 10 Feb 2012 17:32:03 +0200
EHLO applnode1.mkkdomain.net
250-smtpmail.mailserv.com Hello [10.0.9.74]
250-SIZE
250-PIPELINING
250-DSN
250-ENHANCEDSTATUSCODES
250-STARTTLS
250-X-ANONYMOUSTLS
250-AUTH NTLM LOGIN
250-X-EXPS GSSAPI NTLM
250-8BITMIME
250-BINARYMIME
250-CHUNKING
250-XEXCH50
250 XRDST
MAIL FROM: mkhawas1@mailserv.com
250 2.1.0 Sender OK
RCPT TO: mkhawas2@mailserv.com
250 2.1.5 Recipient OK
DATA
354 Start mail input; end with <CRLF>.<CRLF>
Subject: Test message from Malay Khawas
Test message body
.
250 2.6.0 <3f67d977-2da0-45c2-9819-fc935c4fa4d8@smtpmail.mailserv.com> Queued mail for delivery
quit
221 2.0.0 Service closing transmission channel
Connection closed.


Cheers !!!!!!!

IMPORTANT SQLs - Related to Concurrent Processing

Find the OPP Logfile of a Request ID:


SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name
FROM apps.fnd_conc_pp_actions fcpp, apps.fnd_concurrent_processes fcp
WHERE fcpp.processor_id = fcp.concurrent_process_id
AND fcpp.action_type = 6
AND fcpp.concurrent_request_id = &req_id;

==================************==================

Query to Find Out the Schedule Concurrent Requests and Request Sets:

SELECT fcr.request_id,
DECODE(fcpt.user_concurrent_program_name,
'Report Set',
'Report Set:' || fcr.description,
fcpt.user_concurrent_program_name) CONC_PROG_NAME,
argument_text PARAMETERS,
NVL2(fcr.resubmit_interval,
'PERIODICALLY',
NVL2(fcr.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')) PROG_SCHEDULE_TYPE,
DECODE(NVL2(fcr.resubmit_interval,
'PERIODICALLY',
NVL2(fcr.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')),
'PERIODICALLY',
'EVERY ' || fcr.resubmit_interval || ' ' ||
fcr.resubmit_interval_unit_code || ' FROM ' ||
fcr.resubmit_interval_type_code || ' OF PREV RUN',
'ONCE',
'AT :' ||
TO_CHAR(fcr.requested_start_date, 'DD-MON-RR HH24:MI'),
'EVERY: ' || fcrc.class_info) PROG_SCHEDULE,
fu.user_name USER_NAME,
requested_start_date START_DATE
FROM apps.fnd_concurrent_programs_tl fcpt,
apps.fnd_concurrent_requests fcr,
apps.fnd_user fu,
apps.fnd_conc_release_classes fcrc
WHERE fcpt.application_id = fcr.program_application_id
AND fcpt.concurrent_program_id = fcr.concurrent_program_id
AND fcr.requested_by = fu.user_id
AND fcr.phase_code = 'P'
AND fcr.requested_start_date > SYSDATE
AND fcpt.LANGUAGE = 'US'
AND fcrc.release_class_id(+) = fcr.release_class_id
AND fcrc.application_id(+) = fcr.release_class_app_id
and DECODE(fcpt.user_concurrent_program_name,
'Report Set',
'Report Set:' || fcr.description,
fcpt.user_concurrent_program_name) like '%'
ORDER BY CONC_PROG_NAME;

Cheers !!!!!!!

After Cloning Managers are not coming up

After Cloning Managers are not coming up

Method#1:
● Clean the FND_NODE Info:
EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;
●● Run Autoconfig on DB node and then Apps Node
●●● Run $FND_TOP/patch/115/sql/afdcm037.sql script
●●●● Start Services (adstrtal.sh)

Method#2:
● Ensure Concurrent :GSM Enabled profile is set to ‘Y’
●● Run $FND_TOP/patch/115/sql/afdcm037.sql
●●● Do Relinking of FND Conc Libraries:
cd $FND_TOP/bin
adrelink.sh force=y "fnd FNDLIBR"
adrelink.sh force=y "fnd FNDSM"
adrelink.sh force=y "fnd FNDFS"
adrelink.sh force=y "fnd FNDCRM"

Before bringing the managers up, execute CMCLEAN….. In most of the cases it helped….


Cheers !!!!!!!

How to change the SCAN Listener Port After Installation?

How to change the SCAN Listener Port After Installation?

Modify SCAN listener port:
$ ${GRID_HOME}/bin/srvctl modify scan_listener -p <new-SCAN-port>

Restart SCAN listener so the new port will be effective:
$ ${GRID_HOME}/bin/srvctl stop scan_listener
$ ${GRID_HOME}/bin/srvctl start scan_listener

Confirm the change:
$ ${GRID_HOME}/bin/srvctl config scan_listener

Cheers !!!!!!!

Enable Tracing for CRSD Module

Enable Tracing for CRSD Modules:($GRID_HOME/log/<nodename>/crsd/crsd.log)

List all crsd modules: 
${GRID_HOME}/bin/crsctl lsmodules crs

Find out the current trace level for all crsd modules - the output can be used to to revert back to original trace level once the issue is solved:
${GRID_HOME}/bin/crsctl get log crs all

Set trace level to 5 for all modules: 
${GRID_HOME}/bin/crsctl set log crs all:5
Alternatively trace level for each modules can be set individually:
${GRID_HOME}/bin/crsctl set log crs CRSPE:5

Once the issue is solved, set trace level back to original value for all crs modules
$GRID_HOME/bin/crsctl set log crs AGENT:1



Cheers !!!!!!!

Cluster Verification Utility - Concepts and Details

Cluster Verification Utility - Concepts and Details

<<<<<<<<< cluvfy NTP >>>>>>>>>

cluvfy comp clocksync -n all -verbose
....
Result: Clock synchronization check using Network Time Protocol(NTP) passed
Oracle Cluster Time Synchronization Services check passed
Verification of Clock Synchronization across the cluster nodes was successful.

The Cluster Time Synchronization Service (CTSS) is one of the new processes in the Oracle Clustware 11gR2 layer , the CTSS is installed during the GRID infrastructure installation.

CTSS Daemon is responsible for the time management within the cluster. It makes sure each node in the cluster is using the same time. First, CTSS will determine if a Network Time Protocol (NTP) daemon is running in the system and if NTP is not running, then  CTSS will run in active mode and perform the same task as the NTP daemon. If NTP daemon is running,  CTSS will be started  in observer mode.

●● We need to check if there is a time difference on the nodes.
●● We need to make sure ntp is running properly and with -x option



Cheers !!!!!!!

AWR Snapshot - Details

How to Change the AWR Snapshot Settings:

Default is 60 Minutes. Following will change to 30 Minutes:
EXEC DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS( interval => 30);

Changes the interval setting to two hours and the retention setting to two weeks for the local database:
execute dbms_workload_repository.modify_snapshot_settings(interval => 120,retention => 20160);

If you query the DBA_HIST_WR_CONTROL table after this procedure is executed, you will see the changes to these settings.
SELECT * FROM DBA_HIST_WR_CONTROL;

By setting the value of the interval as 0, we set the new interval between each snapshot collection as 110 years:
execute DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(interval => 0);

The default settings for 'interval' and 'retention' are (60 min and 7 days respectively), and values for both 'interval' and 'retention' dbms_workload_repository.modify_snapshot_settings(...) procedure is expressed in minutes. 

How to Manually Create Snapshots:

When you wish to create performance snapshots outside of the fixed intervals, then DBMS_WORKLOAD_REPOSITORY package can also be used:
EXEC DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT('TYPICAL');

How to Manually Drop Snapshots Range:

DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE( 
low_snap_id IN NUMBER, 
high_snap_id IN NUMBER 
dbid IN NUMBER DEFAULT NULL);


Cheers !!!!!!!

HOW TO - Send Output of Concurrent Request to User's Mail ID

HOW TO - Send Output of Concurrent Request to User's Mail ID

Setup SMTP Related Profile Option:
FND:SMTP Host
FND:SMTP Port

In Submit Request window click on Delivery Option, Go to Email Tab and key in the Mail Details.

Review the Logfile for following Messages:

+------------- 2) DELIVER -------------+
Emailing output to user1@mail.com
Beginning post-processing of request 2065107 on node <<<<<HOSTNAME>>> at 20-JUN-2012 09:50:56.
Post-processing of request 2065107 completed at 20-JUN-2012 09:51:07.
+--------------------------------------+

Cheers !!!!!!!