Wednesday, October 10, 2012

Sunday, October 07, 2012

Setting or Clearing an Environment Variable in Windows Command Prompt


The following procedures show how to set or clear an environment variable from a command prompt build window or a batch file.
To set an environment variable
  • In a command prompt build window or a batch file, type the following command:
    set <environment variable>=<value>
To clear an environment variable
  • In a command prompt build window or a batch file, type the following command:
    Note   Ensure that you do not enter a character or space after the equal sign.
    set <environment variable>=
To determine the value of an existing environment variable
  • At the command prompt, enter the following command.
    set <environment variable>
    The value for the environment variable is displayed.
    However, if you use only the first few characters in a variable name when entering the set command, this results in the display of values for all environment variables using that prefix.
To append the value of an existing environment variable
  • At the command prompt, enter the following command.
    set PATH=%PATH%;<insert your path>

Wednesday, October 03, 2012

How to get inventory of EPM / Hyperion patches

Enter the following command on one line and get the inventory from all of your server. 
This inventory should show the patches.

opatch.bat lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29

ERPI and ODI Initilization Failed for EBS

If you get error ODI-1217 after you initialize ERP Integrator cause may be user has not granted proper privileges to your schema which you have configured in EBS_DATA_SERVER in ODI. 

ODI_11.1.1.6.0_GENERIC_111219.1055
Standalone Edition Version 11.1.1



Session Failed :3501 : ODI-1217: Session EBS_GL_SETUP_SOURCE_SYSTEM (3501) fails with return code 942.
ODI-1226: Step EBS Extract COA Ledgers fails after 1 attempt(s).
ODI-1240: Flow EBS Extract COA Ledgers fails while performing a Loading operation. This flow loads target table AIF_COA_LEDGERS.
ODI-1227: Task SS_0 (Loading) fails on the source ORACLE connection EBS_DATA_SERVER.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Solution:
Grant all  privileges to your user similar to APPS user.
Restart ODI Agent
Login into Workspace--> ERP Integrator and Initialize it again.