Oracle EBS, AI and Hyperion

Wednesday, October 10, 2012

2 Dimensional QR (Quick Response) Code Generator

You can use following Google's website to generate code for your personal use.

http://zxing.appspot.com/generator/

You can also visit following blog to know how to add it on your site.
http://www.labnol.org/internet/qr-code-for-print-stylesheet/26064/

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

Tuesday, September 18, 2012

How to verify data loaded by ERP Integrator into table

You can execute Data Load Rule by clicking on Execute button.
It will display the process ID.

Go to Process Details.

If you click on Show you can see the record count in the log.
Go to SQL Plus and run following query.

SELECT * FROM ERPI.TDATASEG

ERPI is my ERPI Schema name. If you have different name use that.
You can see the data into the table.

TDATASEG.LOADID is your process ID.
VALID_FLAG = Y indicates data is valid.

Check EPM 11.1.2.2 AIF Web Services

If you want to see what all web services are running on your Application Server type following URL.
http://<server>:<port>/aif/services

It will display web services.

And now... Some Services

RuleService (wsdl)
- executeMetadataRule
- executeDataRule
- getDataRuleNames
- getLocationNames
- getPeriodNames
EPMAService (wsdl)
- exportMetadataToEPMA
- exportDataToEPMA
FDMRuleService (wsdl)
- executeRule
EssbaseService (wsdl)
- loadMetadata
- loadData
AdminService (wsdl)
- AdminService
HPLService (wsdl)
- importWritebackData
- executeDataLoad
FusionGLService (wsdl)
- loadWritebackData
DrillService (wsdl)
- getDrillURL
Version (wsdl)
- getVersion
HFMService (wsdl)

createDrillRegions

If you click on any wsdl URL and if you see following than that is normal.

AXIS error

Sorry, something seems to have gone wrong... here are the details:

Fault - java.lang.NoClassDefFoundError: com/ibm/wsdl/extensions/soap/SOAPBindingImpl; nested exception is:

java.lang.NoClassDefFoundError: com/ibm/wsdl/extensions/soap/SOAPBindingImpl

AxisFault

faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException

faultSubcode:

faultString: java.lang.NoClassDefFoundError: com/ibm/wsdl/extensions/soap/SOAPBindingImpl; nested exception is:

java.lang.NoClassDefFoundError: com/ibm/wsdl/extensions/soap/SOAPBindingImpl

faultActor:

faultNode:

faultDetail:

{http://xml.apache.org/axis/}hostname:<your_host_server_name>

Monday, September 17, 2012

Set Field Foreground Color Using Visual Attribute

We had a requirement that based on some conditions we wanted to display Item number in red color as shown below.

We could use oracle provided custom visual attribute and set item instance property to change foreground color as given below.

SET_VA_PROPERTY('CUSTOM5',FOREGROUND_COLOR,'r255g0b0'); SET_ITEM_INSTANCE_PROPERTY('QUANTITY_FOLDER.ITEM',CURRENT_RECORD,VISUAL_ATTRIBUTE,'CUSTOM5');

Problem we noticed that it takes more time to set the color than to fetch data from database.

To improve the performance instead of using seeded Custom 5 visual attribute we added new custom visual attribute X_RED_FG. In properties set foreground color to Red.

Used new custom visual attribute X_RED_FG in set item instance property. This improved performance significantly. We did not used SET_VA_PROPERTY command.

SET_ITEM_INSTANCE_PROPERTY ('QUANTITY_FOLDER.ITEM',CURRENT_RECORD,VISUAL_ATTRIBUTE,'X_RED_FG');

EPM 11.1.2.2 Help is not working

We installed EPM 11.1.2.2.When we click on help we got following error.
Server Error in Application "DEFAULT WEB SITE/EPMSTATIC"Error SummaryHTTP Error 404.0 - Not FoundThe resource you are looking for has been removed, had its name changed, or is temporarily unavailable.