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.

ODI for eBusiness Suite Integration - in 4 Steps

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. 

The Finnish Hyperion Guy: EPM 11.1.2.2 Installation and Configuration - Firs...

The Finnish Hyperion Guy: EPM 11.1.2.2 Installation and Configuration - Firs...: I know many of you have been waiting to see more details about the EPM 11.1.2.2 release. I have been really busy at work as my calendar is p...

The Finnish Hyperion Guy: EPM 11.1.2.2 Installation and Configuration - Firs...

The Finnish Hyperion Guy: EPM 11.1.2.2 Installation and Configuration - Firs...: Yesterday I did an installation of some basic Oracle EPM 11.1.2.2 modules (HFM, Planning, Essbase) on a virtual machine running Server 2008 ...