fnd_nodes Clean up: AFCPClean.sh

Hi Guys,

Now no need to run exec fnd_conc_clone.setup_clean procedure. Oracle has introduced a new feature AFCPClean.sh script in R12 which do the same.

fnd_nodes Clean up: AFCPClean.sh :

Stop All Services

–

Execute $INST_TOP/admin/install/afcpclean.sh APPS APPS-Password

–

Perform Auto Config.


Example:

–

$ADMIN_SCRIPTS_HOME/adstpall.sh APPS/APPS-Password

–

Check the FND Nodes

SELECT node_name "Node Name", node_mode "Mode", support_cp "C",
support_web "W", support_admin "A", support_forms "F"
FROM FND_NODES;

–

$INST_TOP/admin/install/afcpclean.sh APPS APPS-Password

++++++++++++++++++++++++++++++++++++++++++++++++++++++

AFCPClean Performs the Following Tasks

======================================

#delete from fnd_profile_option_values

where (application_id,profile_option_id) in

(select application_id,profile_option_id

from fnd_profile_options

where profile_option_name='NODE_TRUST_LEVEL')

and level_id=10005;



#FND_CONC_CLONE.setup_clean();

Cleaning up the Database..

PL/SQL procedure successfully completed.

Commit complete.

–

Check the FND Nodes

–

DBTier AutoConfig: $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adautocfg.sh

–

Apps Tier Auto Confiog: $ADMIN_SCRIPTS_HOME/adautocfg.sh