EPM Planning shared services integration with OID/OVD

How to Integrate OID in EPM Planning 11.1.2.4:

You need:
OID/OVD Host name & Port
Base DN(distinguished name)
User DN
Password for User (OID Connection)

Step-1:

Login to your workspace:
Go go Navigate --> Administer --> Shared Services Console

Click on Administration on Top:

 From Top down "Select Configure User Directories" & New

 Select LDAP " For Open LDAP/OID/OVD"

Select the directory type as OID:


Key in the details related to OID as shown below:

Click Save and Okay:

If you still want to keep the Primary directory   as Native then move down the newly created directory.
Remember your "Admin" login belongs to only Native then have the Native directory on the top of the list.

Search for the users from the OID

Note:-  If you are using OVD Then select the directory type to "Other"  and leave the "ID Attribute" to blank.

Provision the user and try to login as that user:

EPMINS-01047: The dbclient64 assembly is missing. The assembly is required in order to install a selected component.

During EPM 11.1.2.4 install on a UNIX platform, you may get the below error when you select Oracle client option.

Oracle Database Client 64-bit

Errors:

   Blocker:

      EPMINS-01048: Cannot install a selected component. See the Troubleshooting Guide for more information.

   EPMINS-01045: One or more required assemblies are missing; cannot install one or more selected components. See the Troubleshooting Guide for more information.:

      EPMINS-01047: The dbclient64 assembly is missing. The assembly is required in order to install a selected component.

   EPMINS-01076: One or more required native installers are missing; cannot install one or more selected components. See the Troubleshooting Guide for more information.:

      EPMINS-01075: The db64 native installer is missing. The installer is required in order to install a selected component.

   EPMINS-01046: The installation checks required to run EPM System Installer did not succeed. See the Troubleshooting Guide for more information.:

      EPMINS-01051: The selected product is not available for this operating system.

Status: EPMINS-01016: Cannot install the selected component. Click Help to see possible reasons.

In fact this is not an error message and you can safely ignore this message:

There are no assemblies for the Oracle database clients on LINUX/UNIX installations.  Per the EPM Installation and Configuration Guide, the EPM System Installer installs the Oracle Database client automatically if it is required on a machine (Windows only, Performance Management Architect only). 

Deselect the options "Oracle Database Client 64-bit" & "Oracle Database Client 32-bit" from the EPM installer menu and proceed with the Installation.  

If needed, install the Database Clients separately not 

through the EPM Installer.

appsutil/bin/adcvm.sh[211]: AIX: 0403-012 A test command parameter is not valid.

Autoconfig fails with the below error on the dbtier

appsutil/bin/adcvm.sh[211]: AIX: 0403-012 A test command parameter is not valid.


Fix:

Backup your adcvm.sh. { appsutil/bin
Modify the file adcvm.sh as follows:

from:

if ((test "$pltform" = "Solaris") || (test "$pltform" = "Intel_Solaris"));

to:

if (test "$pltform" = "Solaris") || (test "$pltform" = "Intel_Solaris");

Save, and rerun the script.

view hosts via epmsys_registry in a EPM installation

user_projects/epmsystem1/bin> ./epmsys_registry.sh viewhosts




Hosts in EPM Registry



        HOST NAME IN EPM REGISTRY     HOST NAME AS RESOLVED ON THIS MACHINE
        *************************     *************************************
1       hypap01                                             hypap01
2       hypdevdb01.shaik.com                      hypdevdb01.shaik.com
3       hypap02                                             hypap02

Autoconfig fails with ORA-12899: value too large for column during "afdbprf.sh INSTE8_PRF 1"

 AutoConfig could not successfully execute the following scripts:
    Directory: [RDBMS_ORACLE_HOME]/appsutil/install/[context_name] 
      afdbprf.sh              INSTE8_PRF         1

AutoConfig is exiting with status 1 

Updated profile option value - 1 row(s) updated

Application Id : 0

Profile Name : FND_DB_WALLET_DIR

Level Id : 10001

Application Id : 174

Profile Name : ECX_UTL_XSLT_DIR

Level Id : 10001

New Value : /usr/tmp

Old Value : /usr/tmp

Updated profile option value - 1 row(s) updated

Application Id : 174

Profile Name : ECX_UTL_LOG_DIR

Level Id : 10001

New Value : /usr/tmp

Old Value : /usr/tmp

Updated profile option value - 1 row(s) updated

Application Id : 0

Profile Name : BIS_DEBUG_LOG_DIRECTORY

Level Id : 10001

New Value : /usr/tmp

Old Value : /usr/tmp

declare

*

ERROR at line 1:

ORA-12899: value too large for column

"APPLSYS"."FND_PROFILE_OPTION_VALUES"."PROFILE_OPTION_VALUE" (actual: 248,

maximum: 240)

ORA-06512: at line 44

ORA-06512: at line 139

fix:-

To implement the solution, please execute the following steps:

1. Change the value dbutilfiledir in the database context file ($ORACLE_HOME/appsutil/$CONTEXT_NAME.xml) to a value less the 240 characters.

2. Run autoconfig again.