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

Hello Guys,

I have implemented OBIEE with Informatica,DAC and BIAPPS and integrated with R2.

I will publish installation steps soon. Please mail me if you need any help on this.

AFPASSWD 12.1.2 utility

Hi Folks,
I found one new feature of R12 AFPASSWD. This utility introduced in 12.1.2.

AFPASSWD is an enhanced version of FNDCPASS, and includes the following features:

• AFPASSWD only prompts for passwords required for the current operation,
allowing separation of duties between applications administrators and database
administrators. This also improves interoperability with Oracle Database Vault. In
contrast, the FNDCPASS utility currently requires specification of the APPS and the
SYSTEM usernames and corresponding passwords, preventing separation of duties
between applications administrators and database administrators.

• When changing a password with AFPASSWD, the user is prompted to enter the
new password twice to confirm.

• AFPASSWD can be run from the database tier as well as the application tier. In
contrast, FNDCPASS can only be run from the application tier.---  (MOST IMPORTANT FEATURE)

FNDCPASS will continue to be shipped with Oracle E-Business Suite, and customers
can migrate to the AFPASSWD utility at their discretio


AFPASSWD Usage

The AFPASSWD command is used with the relevant command line options to perform
the desired action.

AFPASSWD [-c [@]] [-f ]

AFPASSWD [-c [@]] [-o ]

AFPASSWD [-c [@]] [-a]

AFPASSWD [-c [@]] [-l [] |
[]]

AFPASSWD [-c [@]] [-L [] | []]

AFPASSWD [-c [@]] [-s]

These options have the following functions:

• -c {APPSUSER}[@{TWO_TASK}] - Specifies the connection string to use, the
Applications user, and/or the value of TWO_TASK. This option can be use in
combination with others. If it is not specified, default values from the environment
will be used.
Note: The password will be prompted for, and is not to be
provided in the connection string.

• -f {FNDUSER} - Changes the password for an Applications user. A username that
contains spaces must be enclosed in double quotation marks; for example, "JOHN
SMITH".

• -o {DBUSER} - Changes the password for an Oracle E-Business Suite database user.
Note:  This only applies to users listed in the
FND_ORACLE_USERID table, not database users in general.

• -a - Changes all Oracle (ALLORACLE) passwords (except the passwords of APPS,
APPLSYS, APPLSYSPUB) to the same password, in the same way as the
ALLORACLE mode does in FNDCPASS.

• -l - Locks individual {ORACLE_USER} users (except required schemas). {TRUE} =
LOCK, {FALSE} = UNLOCK.

• -L - Locks all Oracle (ALLORACLE) users (except required schemas). {TRUE} =
LOCK, {FALSE} = UNLOCK.

• -s {APPLSYS} - Changes the password for the APPLSYS user and the APPS user.
This requires the execution of AutoConfig on all tiers.

• -h - Displays help.