For Apps Newbies (Must Read)
Following some points are very important to Understand before moving to apps dba field. These points are helpful for those who are new in this field. Get familiar with 11i E-business Suite File Systems. Understand of Concurrent managers. Get familiar with some important tables (fnd_xxxxx, AD_xxx). Some Examples are: FND_LOGINS,FND_USER,FND_DM_NODES,FND_NODES,FND_RESPONSIBILIT Y,FND_DATABASES,FND_APPLICATION, FND_CONCURRENT_PROGRAMS,FND_CONCURRENT_REQUESTS FND_CONCURRENT_PROCESSES, AD_APPLIED_PATCHES, AD_BUGS, AD_INSTALL_PROCESSES Test the patches multiple time in test environment before applying to production. Understanding of patch application work process is very important. Monitor the rollback segments, it is the very important Always check the invalid object. Always check the log file Oracle Application System is extremely indexed, so remember to rebuild them periodically according to the system performance. Never add any additional index without asking to Oracle and always documents the process.
How to Trace Concurrent Programs for a Specific ERP User
1-First get the ERP user login id . 2- Pull up the SYSTEM profile - make sure in the find screen to select the user & add the user, and add the profile value, in one line, at the profile option value called, ‘Initialization SQL Statement - Custom’, you can put this in your find as well... 3- Now you need to add the value under the user filed, below the user name, copy this in notepad in one line and paste it. You can change the identifier and the dump file size as well. NOTE IF YOU MAKE A MISTAKE USER WILL NOT BE ABLE TO LOGIN. begin fnd_ctl.fnd_sess_ctl('','','TRUE','TRUE','LOG', 'ALTER SESSION SET EVENTS=''10046 TRACE NAME CONTEXT FOREVER, LEVEL 8'' tracefile_identifier=''BENMGL'' max_dump_file_size=''unlimited'''); end;