Skip to main content

Using SQL*Loader Utility through E-Business Suite Front End

This brief article explains how to create concurrent programs, in E-Business Suite 11i of Oracle Applications, to use SQL*Loader utility for loading data in backend database tables. I assume that you already have knowledge of using SQL*Loader through command prompt.

As you would be aware of the fact, that the concurrent programs or requests are specific for an application (or responsibility) so you will have to decide the application in which you want to keep your request in, like GL (General Ledger) or AP (Account Payables) or any other application. This is important because you will be able to see your request only when you are logged in this particular application (or responsibility).

Place your Control File in the $APPL_TOP/11.5.0/bin of your application. (e.g. I am keeping my control file in AP and hence the corresponding directory is /u02/apps/visappl/ap/11.5.0/bin. It may be different for your system). This is all you have to do at the backend.

Log in the E-Business Suite in ‘System Administrator’ responsibility.

First we need to define the Executable for the Concurrent Program. Basically this step specifies the Execution Method and Execution File Name our Concurrent Program will be using.

Go Concurrent:Program:Executable

Enter Executable (any name you want to give), Short Name, Application (Select the same application, where you have kept your Control File), Execution Method (Select SQL*Loader), Execution File Name (name of your Control File, without extension. The system locates this file in the path where you kept it, the /bin of the application you specified above). Save the record.

Go Concurrent:Program:Define

OK, time to define the program. Enter Program Name, Short Name, Application (Select the same application, where
you have kept your Control File and which you selected while creating Executable). Enter the Executable (Select the executable you created above). Save the record.

Go Concurrent:Set

Now we have to add our Concurrent Program to a request set. A Request Set clubs many Concurrent Programs together and they are executed according to 'stages'. Each stage is given a 'Display Sequence' which, as the name suggests, controls the execution order. Your set may have only one stage, which means that it has only one Concurrent Program associated with it.

Enter Set name, Set Code, Application (same as selected earlier). Press 'Define Stages' button. Enter Display Sequence (give 1), Stage name and Stage Code. Press 'Requests' button. Now we have to associate the Program name with this stage. Enter Sequence, Program name (same as given to the Concurrent Program defined earlier). Save everything.

And you are done! Switch to the responsibility you defined the request for and submit the request for running your Concurrent Program.

Comments

Popular posts from this blog

File upload problem: UTF-8 encoding not honored when form has multipart/form-data

The problem that I was facing was something like this. I was using Apache Commons File Upload library to upload and download some file.

I had a form in which user can upload a file and another field 'name' in which she can give any name to the file being loaded.


When I submitted the form, the file was uploaded fine but the value in name field was garbled. I followed all the possible suggestions I found:

<%@page pageEncoding="UTF-8"%> set. <%@page contentType="text/html;charset=UTF-8"%gt; set after the first directive. <meta equiv="Content-Type" content="text/html;charset=UTF-8"> in the head. enctype="multipart/form-data" attribute in the form. accept-charset="UTF-8" attribute in the form.
in the Servlet:
before doing any operations on request object: request.setCharacterEncoding("UTF-8"); For accessing the value

FileItem item = (FileItem) iter.next();

if (item.isFormField()) {

//For regular…

java.lang.IllegalArgumentException: Malformed \uxxxx encoding

I was getting this exception during build while running ant. Googling didn't help much and I was flummoxed because the same code was running fine till now.

My code reads a text file and does some operations on the basis of values read. It was only when I saw the text files I understood the error. I had copied the text in wordpad and saved it as .txt file. Wordpad had put lot of formatting information before and after the content. Also there was "\par" after every line, which was giving this error.

So moral of the story: if you get this exception check your properties file (or any other file that your code might be reading.)

Easiest way to print Timestamp in Java

Rather than using Calendar.getTime() we can use java.sql.Timestamp class to get the time stamp which gives date and time till millisecond precision.

System.out.println(new Timestamp(System.currentTimeMillis()));

Above will give you current timestamp in this format: 2010-07-27 16:37:45.39