This article details the steps used to clone R12 RAC database to Single instance database using RMAN duplicate command, Notice that we used the control file as a catalog database and the Production will keep up and running. The databases used here are: Production: PROD Cloned: CPCLONE 1- On the source system; Run the preclone […]
1. Deregister the current Applications server (Required)De-register the current Applications server node, run the following command as the owner of the Oracle Applications file system and current database instance as follow:perl $AD_TOP/bin/adgentns.pl appspass= contextfile= -removeserver2. Shutdown the Applications Tier Services (Required):$COMMON_TOP/admin/scripts//adstpall.sh apps 3. Change the hostname as required: Change the hostname in /etc/hosts file4. Change […]
Oracle Approvals Management or AME, as it is called in general, is a module of Oracle Applications that contains the hierarchy list for all seeded/standard workflows. We can configure individual approval lists for each workflow in this module. To enable the workflows to use AME hierarchy list a profile option, AME: Installed, has to be set. […]
The session when kept inactive for certain period gets inactive and hence we need to relogin again. It sometimes become frustating when working on a test instance and makes us login again and again. This can be avoided by setting a profile option. Profile “ICX_SESSION_TIMEOUT” can be used to increase the session timeout time.
Below query can be used to get concurrent program name and its parameter. SELECT fcpl.user_concurrent_program_name , fcp.concurrent_program_name , par.end_user_column_name , par.form_left_prompt prompt , par.enabled_flag , par.required_flag , par.display_flagFROM fnd_concurrent_programs fcp , fnd_concurrent_programs_tl fcpl , fnd_descr_flex_col_usage_vl parWHERE fcp.concurrent_program_id = fcpl.concurrent_program_idAND fcpl.user_concurrent_program_name = &conc_prg_nameAND fcpl.LANGUAGE = ‘US’AND par.descriptive_flexfield_name = ‘$SRS$.’ || fcp.concurrent_program_name
Recent Comments