Useful Articles for the Oracle E-Business Suite Technology Stack for System Administration

Note:190583.1 How can I find out which Profile Options are available and the Settings for them?

Note:190585.1 If you are experiencing a problem with a single form, have you applied the latest version of the form?

Note:160151.1 How to Make Help Diagnostics Examine be Password Protected OR Not?

Note:190602.1 How do I set the name of the site that shows up under Help?

Note:190605.1 I changed a profile option, but it does not seem to take effect.

Note:190606.1 Is there a way to Find out what Patches have been Applied?

Note:190609.1 What is needed to have 02 converted to 2002 rather than 0002?

Note:159244.1 How do I obtain Guidelines to change default Applications Schemas Passwords using FNDCPASS?

Note:190611.1 Error Using Any Resp: This process cannot be Drawn

Note:134640.1 How to create a responsibility to access forms/reports from several modules

Note:145245.1 Log on as a Different User Option is always grayed out?

Note:190615.1 Which Release of Applications can FNDCPASS be used?

Note:138159.1 Cannot find 'FND Enable Cancel Query' system profile.

Note:149196.1 Cannot Login to System after Changing APPS/APPLSYS password.

Note:134640.1 How to create a responsibility to access forms/reports from several modules?

Note:130075.1 Log on as a Different User Option is always gray out?

Note:145558.1 When Choosing a Responsibility get java.lang.out of Memory Error

Note:191111.1 How to associate CCMs to a specific data group?

Note:92333.1 The FND_CRM_HISTORY is constantly updated with new records?

Note:149600.1 Table: FND_CONC_PP_ACTIONS is growing exponentially.

Note:189441.1 How to make a message more descriptive?

Note:171261.1 How to lessen the frequency and Applications Message?

Note:191125.1 "Caution" "SRS-VERIFY SUBMISSION". Would like to know how to fix this so that the message does not appear.

Useful Articles for the Oracle E-Business Suite Technology Stack for Applications DBA (Cloning)

Note 230672.1 Cloning Oracle Applications Release 11i with Rapid Clone

Note 406982.1 Cloning Oracle Applications Release 12 with Rapid Clone

Note 811715.1 Descriptive Checklist for performing Rapid Clone with 11iR12

Note 216664.1 FAQ Cloning Oracle Applications Release 11i

How to find out linux release information?

For Oracle Enterprise Linux:
$ rpm -qf /etc/redhat-release
enterprise-release-5-0.0.9
$ cat /etc/enterprise-release
Enterprise Linux Enterprise Linux Server release 5.2 (Carthage)

For RedHat Enterprise Linux:
$ rpm -qf /etc/redhat-release
redhat-release-4AS-5.5
$ cat /etc/redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 4)

For SuSE, use “/etc/SuSE-release”:
$ cat /etc/SuSE-release
SUSE LINUX Enterprise Server 9 (i586)
VERSION = 9

Useful Articles for the Oracle E-Business Suite Technology Stack for Applications DBA (Security)

Note 738923.1 Oracle E-Business Suite Releases 11i and 12 Critical Patch Update note

Note 403537.1 Best Practices for Securing Oracle E-Business Suite Release 12

Note 189367.1 Best Practices for Securing the E-Business Suite Release 11i

To download and Upload rules for a particular form

To download rules for a particular form:

FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt> FND_FORM_CUSTOM_RULES form_name=<form name>

Upload:
FNDLOAD <userid>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt>

How To Control The Output Format Of Report Custom Layout Template in Oracle Apps

Profile 'FND: Default Template Output Type' needs to be defined at SITE level
with any one of the following values:

* EXCEL
* FO
* HTML
* PDF
* RTF

the way to find version of installed family packs in oracle apps?

SELECT PRODUCT_VERSION,PATCH_LEVEL FROM
FND_PRODUCT_INSTALLATIONS WHERE PATCH_LEVEL LIKE ‘%GL%’;

How to schedule a Job in Unix

Use cronjob
crontab -l ( list current jobs in cron)
crontab -e ( edit current jobs in cron )
_1_ _2_ _3_ _4_ _5_ $Job_Name
1 – Minutes (0-59)
2 – Hours ( 0-24)
3 – day of month ( 1- 31 )
4 – Month ( 1-12)
5 – A day of week ( 0- 6 ) 0 -> sunday 1-> monday

Delete Duplicate Rows from Oracle Table

DELETE FROM EMPLOYEES WHERE ROWID NOT IN
(SELECT MIN(ROWID)
FROM EMPLOYEES
GROUP BY LAST_NAME ) ;

How to compile Forms in 11i and R12

Compile Forms in 11i

$ f60gen module=<formname>.fmb userid=apps/<apps_pwd> output_file=$XX_TOP/forms/US/<formname>.fmx


Compile Forms in R12

$ frmcmp_batch <formname>.fmb userid=apps/<apps_pwd> output_file=$XX_TOP/12.0.0/form/US/<formname>.fmx module_type=form compile_all=special

Oracle will retire several certification tracks effective November 1, 2011

Exams to be retired November 1:

1Z0-109 Oracle WebLogic Server 10g Developer
1Z0-110 Oracle Weblogic Portal 10g Developer
1Z0-200 Oracle 11i E-Business Essentials
1Z0-207 Oracle Comm. Billing & Revenue Mgmt.: Pricing
1Z0-208 Oracle Comm. Billing & Revenue Mgmt.: Server Developer
1Z0-209 Oracle Comm. Billing & Revenue Mgmt.: System Administrator
1Z0-211 Oracle 11i General Ledger Fundamentals
1Z0-212 Oracle 11i Payables Fundamentals
1Z0-213 Oracle Receivables 11i Fundamentals
1Z0-221 Oracle 11i Inventory Management Fundamentals
1Z0-222 Oracle 11i Purchasing Fundamentals
1Z0-223 Oracle 11i Order Management Fundamentals
1Z0-231 Oracle 11i 2.6 Implement Workflow
1Z0-232 Oracle 11i System Administration
1Z0-233 Oracle 11i Install, Patch and Maintain Applications
1Z0-235 Oracle 11i Applications DBA: Fundamentals I
1Z0-236 Oracle 11i Applications DBA Fundamentals II
1Z0-255 Hyperion Essbase 7.1.2 Consultant
1Z0-257 Hyperion Financial Management 4.1 Consultant
1Z0-259 Hyperion Planning 4.1 Consultant
1Z0-262 Hyperion Planning 4.1 Administrator
1Z0-263 Hyperion System 9 BI+ 9.0 Administrator
1Z0-273 Hyperion Financial Management 4.1 Administrator I & II
1Z0-301 Oracle9iAS: Basic Administration
1Z0-615 Siebel 7.7 Consultant Core Exam
1Z0-620 Siebel 7.7 Analytics Application Developer Professional Exam
1Z0-630 Siebel 7.7 Analytics Server Architect Professional Exam
1Z0-640 Siebel 7.7 Analytics Data Warehouse Developer Professional Exam

Just Words

Believe that anything you can imagine you can achieve it real.
Having the devotion,passion and dedication to learn & Work

“Knowledge grows when it is shared“.

How To Prevent the Profile Option MO: Operating Unit being set to NULL at Site Level

steps
1.Login to the application as SYSADMIN
2.Responsibility : System Administrator
3.Function: Profiles --> System
4.Choose from the menu: Help --> Diagnostics --> Custom Code --> Personalize
5.Create a new Rule
oSeq : 10
oDescription : MO: Operating Unit
oLevel : Function
oEnabled : [checked]
6.Specify the following Condition:
oTrigger Event : WHEN-VALIDATE-RECORD
oTrigger Object : PROFILE_VALUES
oCondition : :PROFILE_VALUES.PROFILE_OPTION_NAME = 'ORG_ID' AND :PROFILE_VALUES.SITE_VISIBLE_VALUE IS NULL
oProcessing Mode : Not in Enter-Query Mode
7.Assign the following Actions to the Rule:
oSeq : 10
oType : Message
oDescription : MO: Operating Unit
oLanguage : All
oEnabled : [checked]
oMessage Type : Error
oMessage Text : You must specify a profile option value at Site level for the profile option 'MO: Operating Unit'.
8.Save the changes
9.Close the System Profile Values form

Result
An error message will appear if an end user now tries to remove the profile option value.

Useful Queries

--Finding Invaled Objects
select count(*) from dba_objects where status ='INVALID'

--To Check which node is running what service
select * from fnd_nodes

--Information about the bugs fixed in Installation
select * from ad_bugs

--Information about the applied patches
select * from ad_applied_patches

--Stores values for various profile options
select * from fnd_profile_option_values

--Information about various profile options
select * from fnd_profile_options

--To Find database version
select * from v$version

--To Determine Oracle Apps 11i Version ?
select release_name from fnd_product_groups;

How to list E-Business Suite Profile Option values for all levels using SQLPlus

select p.profile_option_name SHORT_NAME,
       n.user_profile_option_name NAME,
       decode(v.level_id,
               10001, 'Site',
               10002, 'Application',
               10003, 'Responsibility',
               10004, 'User',
               10005, 'Server',
               10006, 'Org',
               10007, decode(to_char(v.level_value2), '-1', 'Responsibility',
                             decode(to_char(v.level_value), '-1', 'Server',
                             'Server+Resp')),
               'UnDef') LEVEL_SET,
       decode(to_char(v.level_id),
               '10001', '',
               '10002', app.application_short_name,
               '10003', rsp.responsibility_key,
               '10004', usr.user_name,
               '10005', svr.node_name,
               '10006', org.name,
               '10007', decode(to_char(v.level_value2), '-1', rsp.responsibility_key,
                          decode(to_char(v.level_value), '-1',
                            (select node_name from fnd_nodes
                             where node_id = v.level_value2),
                        (select node_name from fnd_nodes
                         where node_id = v.level_value2)||'-'||rsp.responsibility_key)),
               'UnDef') "CONTEXT",
       v.profile_option_value VALUE
from fnd_profile_options p,
     fnd_profile_option_values v,
     fnd_profile_options_tl n,
     fnd_user usr,
     fnd_application app,
     fnd_responsibility rsp,
     fnd_nodes svr,
     hr_operating_units org
where p.profile_option_id = v.profile_option_id (+)
  and p.profile_option_name = n.profile_option_name
  and upper(p.profile_option_name) in (
            select profile_option_name from fnd_profile_options_tl
            where  upper(profile_option_name) like upper('%&profile_name%')
            and    upper(profile_option_name) in (select profile_option_name
              from   fnd_profile_options_tl
              where  upper(user_profile_option_name) like upper('%&user_profile_name%')))
  and    usr.user_id (+) = v.level_value
  and    rsp.application_id (+) = v.level_value_application_id
  and    rsp.responsibility_id (+) = v.level_value
  and    app.application_id (+) = v.level_value
  and    svr.node_id (+) = v.level_value
  and    org.organization_id (+) = v.level_value
  order by short_name, user_profile_option_name, level_id, level_set;

Bash Script To Remove Files Older Than 7 Days

find /path -name "*" -mtime +7 -exec rm -f {} \ ;

How to control access to the database and understand validnode checking

You can configure the sqlnet.ora file to allow and deny access to the database
via the validnode checking parmeters.


TCP.VALIDNODE_CHECKING
Use to specify whether to screen access to the database.Value is either YES or ON

TCP.EXCLUDED_NODES
Use to specify which clients using the TCP/IP protocol are denied access to the database.
Hostname and ipaddress can be used

TCP.INVITED_NODES
Use to specify which clients using the TCP/IP protocol are allowed access to the database.
Hostname and ipadddress can be used.


Example sqlnet.ora file (set where database is running)

TCP.VALIDNODE_CHECKING = YES
TCP.EXCLUDED_NODES= (138.3.33.33)
TCP.INVITED_NODES=(138.4.44.44, hammer)

Hide Diagnostics Menu Entry In Oracle Applications

Use the system profiles: 'Hide Diagnostics menu entry'
to control the visibility of the Diagnostics menu

Invalid Objects

select owner, object_name, object_type

from all_objects

where status != 'VALID'

order by owner, object_type, object_name;

How to find an AD patchset level

select PATCH_LEVEL from fnd_product_installations where APPLICATION_ID=50;

Configuring VNC

Created by: eng.Abd el Rahman Samy

Log in as root then:

•Set your VNC password by the command:
vncpasswd

•Edit /etc/sysconfig/vncservers so that it contains the line:
VNCSERVERS="1:root"

•Enable vncserver as a system service.
chkconfig --level 345 vncserver on

•Start vncserver so it creates the user's xstartup file.
service vncserver start

•Stop vncserver.
service vncserver stop

•Edit /root/.vnc/xstartup and uncomment the first two lines started with ( unset & exec ) to be run.

•Start vncserver.
service vncserver start
Test the connection by running VNC viewer on the windows machine

•Enter server name then session number in the vncviewer as:
:1

Limiting Active Requests by User

As System Administrator you can limit the number of requests that may be active (status of Running)
for an individual user. This ensures that a user cannot monopolize the request queue. For example,
if a user with an Active Request Limit of 5 submits 20 requests, only 5 requests will be run at the same time.
The remaining requests will be run when the number of active requests for the user drops below 5.
Use the Profile Options window to set the Concurrent: Active Request Limit profile.
To set a global limit for all users, set this option at the site level.
You can then modify limits for individual users by setting this profile option at the User level.