Saturday, December 22, 2012

Know that there are different Charismatic Leadership styles


You can choose different styles based on your own personality and situation. Whatever you do, don't force it or you'll end up seeming unauthentic. 
Here are the different styles:
1. Focus. This style is based on the perception of presence. Adopt this when you want people to feel like they're the only ones in the room with you.
2. Visionary. This kind of style makes other people feel inspired and appearance matters far less than with any other style.
3. Kindness. This kind of charisma comes from body language and is based mostly on warmth.  This style emphasizes the importance of team work, and creates harmony in a group by connecting people to each other. This approach is particularly valuable “when trying to heighten team harmony, increase morale, improve communication or repair broken trust in an organization.” But using it alone, can allow poor performance to go uncorrected. Employees may perceive, “that mediocrity is tolerated.” If you don't combine this with some authoritative skills, you'll come off as too overeager to please.
4. Authority. This is the most powerful charisma style of them all and those who acquire it are not like-able all the time. We evaluate this power through four indicators: body language, appearance, title and reactions of others. This is classic model of “military” style leadership – probably the most often used, but the least often effective. Because it rarely involves praise and frequently employs criticism, it undercuts morale and job satisfaction. It is only effective in a crisis, when an urgent turnaround is needed.

Tuesday, December 04, 2012

Oracle Apps Interfaces and Conversions.



Found interesting article on Oracle Apps Interfaces and Conversions.

http://erpschools.com/articles/interfaces-and-conversions

Thanks to Prudhvi Avuthu.



Tuesday, November 27, 2012

How To Load Long Description?

When we want to load long descriptions it is always challenging to handle new line character.
Found following good solution in one of the Oracle forum.

LOAD
INFILE 'create_prober_items.csv'
CONTINUEIF LAST '"'
INTO TABLE MTL_SYSTEM_ITEMS_INTERFACE
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(PROCESS_FLAG "TRIM(:PROCESS_FLAG)",
SET_PROCESS_ID "TRIM(:SET_PROCESS_ID)",
TRANSACTION_TYPE "TRIM(:TRANSACTION_TYPE)",
ORGANIZATION_ID "TRIM(:ORGANIZATION_ID)",
TEMPLATE_ID "TRIM(:TEMPLATE_ID)",
SEGMENT1 "TRIM(:SEGMENT1)",
SEGMENT2 "TRIM(:SEGMENT2)",
DESCRIPTION "TRIM(:DESCRIPTION)",
LONG_DESCRIPTION "REPLACE (TRIM(:LONG_DESCRIPTION), '-', CHR(10) || '-')")


The CONTINUEIF LAST '"' tells it to continue with the next row as part of the same logical record if the last character of the current row is not ". When it gets to a row then ends with ", then it knows that is the end of the record.

The "REPLACE (TRIM(:LONG_DESCRIPTION), '-', CHR(10) || '-')" tells it to add a carriage return or line feed in front of each hyphen, so that it is displayed with each hyphen starting on a newline, as you requested.




Monday, November 26, 2012


ODI for eBusiness Suite Integration - in 4 Steps

Original Article is available at 
http://redshift-au.blogspot.com/2009/05/oracle-odi-for-ebusiness-suite.html

1.Connect
Create an Oracle Database Server to connect to Oracle eBusiness Suite schema, ‘apps’ in the Topology Manager:






2.Reverse Engineer
The next step is to reverse engineer the Oracle eBusiness schema, using the Oracle Data Integrator’s Reverse Engineering Knowledge Module for eBusiness Suite.

Create a new Model as follow, using Oracle as technology:



In the ‘Reverse’ tab, select ‘Customized’ and select the ‘RKM E-Business Suite XML to eBusiness’ knowledge module.




Before clicking ‘Apply’ select the ‘Application List’ and define the value of the list of application modules you want to reverse engineer. Remember also to select the ‘Types of objects to reverse-engineer’. If you forget to select the ‘View’ object, you would not be able to get a list open interface tables, as most of them are based on view objects. The value specified takes the form of ‘xxx’,’yyy’ if you want to specify multiple application modules to reverse engineer.

In our example we will use ‘SQLAP’.

A list of the available modules can be extracted by running a select query against the table ‘APPLSYS.FND_APPLICATION’.

select application_short_name from APPLSYS.FND_APPLICATION;

APPLICATION_SHORT_NAME
--------------------------------------------------
ABM
AD
ADS
ADS_DEV
AHL
AHM
ASG
....


Click on ‘Reverse’. Select the agent where the reverse engineering process would be executed.

Open the Operator utility and monitor the progress on the reverse engineering process, if required. This process can run a couple of minutes, depending on the implementation of the Oracle eBusiness Suite.


After the above process finishes, the Model will contain all the available interfaces and public tables for the selected module(s).


3.Integrate
Design your interface, for example reading an XML-file into the invoice open interface table.

On the flow tab of the designed interface, select the target. Change the IKM (Integration Knowledge Module) to ‘IKM E-Business Suite (Open Interface):


You will notice the configuration parameters at the bottom of the screen, starting with the OA_, and the ‘SUBMIT_PROGRAM’. These parameters are the information required by ODI to fire off a concurrent program in eBusiness Suite, after completion of the load of the data into the open interface table.

4.Execution
After execution of this interface, you would notice the new steps, which does the integration using the Oracle eBusiness Suite Concurrent Manager to suck in the information from the Open Interface Tables.



Thanks to PIETER MALAN. 

Tuesday, November 06, 2012

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.

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.

Solution:If you are using IIS as your web server so you need to install the help files locally.

See page 120 "Installing and Configuring Online Help" at this link: http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_1112200.pdf