i. To verify whether the patch has been already applied query for the patch number in ad_applied_patches as follows, select APPLIED_PATCH_ID, PATCH_NAME, PATCH_TYPE, CREATION_DATE from ad_applied_patches where patch_name=’patch_number; ii. Or…
Read MoreThis user should not have to use schema name.objectname and all SELECT qeries run from APPS user should work from this DB User as well a. Create a user using…
Read Morea.Connect to the Oracle EBS b.Select system Administrator responsibility c. Choose Users->Define d. Create a user and give him the corresponding responsibilities e. then choose Profiles->system In that form uncheck…
Read MoreExecute the following query and give the request id when asked, that would display the location and name of the trace file generated. column traceid format a8 column tracename format…
Read More#To find concurrent programs for which trace is enabled output_log=/tmp/practice/log.txt export output_log sqlplus -S apps/apps << EOF spool $output_log set pages 1000 lines 1000 select a.CONCURRENT_PROGRAM_ID, b.USER_CONCURRENT_PROGRAM_NAME “Program_Name”, a.CONCURRENT_PROGRAM_NAME “Short_Name”,…
Read MorePatches applied information ==================== https://docs.google.com/spreadsheet/ccc?key=0Ajy49fqduBhhdFUtQS00cW1BMkV4YmZUN01TZHdFZ2c Details of the individual patch applied =========================== https://docs.google.com/spreadsheet/ccc?key=0Ajy49fqduBhhdFBoaVlJUTdqenBSSWFBOHo2cWF1elE
Read MoreLoad Balancing configuration for R12: For overview and various options for High Availability (at application tier level) follow Metalink (Oracle My Support) note 380489.1 Using Load-Balancers with Oracle E-Business…
Read MoreConcurrent Related Profile Options Concurrent: Active Request Limit Value: Numeric This profile options will restrict the number of concurrent requests that may be run simultaneously by each user. If we…
Read MoreGenerating a Trace File for Forms Navigate to Menu – Help > Diagnostics Select one of the following options: Regular Trace Trace with Binds Trace with Waits Trace with Binds…
Read MoreFNDLOAD is one and only oracle solution. It can be defined as a concurrent program that can move Oracle Applications data between database and text file representations. Or this can…
Read More