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