Saturday, April 12, 2008

INTRO TO INTERFACES(For Freshers to oracle Apps)-1

Hi All,
Here i a trying to get the basics of Interfaces.I will try to post as many interfaces code available.
Even though they might not very much helpful ..but gives the direction to look into and some head start...

First before i post the interfaces codes i would like to introduce some general concepts of interfaces for freshers..

What is a interface?
In terms of oracle applications interface is a communication channel that allows the data to move in and out of the system.

How many types of interfaces are there?
1.INBOUND INTERFACES
2.OUTBOUND INTEFACES

Inbound InterFace:The one which allows data to get into oracle application from outside is called inbound interface.

OutBound Interface:The one which allows data to get data from oracle applications to other systems is called outbound interface.

What are different types of inbound interfaces available?
1.Open interfaces
2.API's(Application Program Interface)
3.EDI(Electronic Data interchange)--Mainly used for automation transactions with third party systems
4.XML GATEWAY --Mainly used for automation transactions with third party systems
5.WEBADI--Used for uploading data from excel with the scope to have some validations--mainly used for one time loading..Just like sqlloader+validation program..
5.PLSQL Packages for Reading XML Data--Use this in case of importing non stadard transactions

What are different types of outbound interfaces available?
1.Custom programs where we pull data to a csv file using UTL_FILE in the required format
2.EDI
3.XMLGATEWAY
4.PLSQL Packages for generating XML

what is the difference between OPEN INTERFACE & API's?
OPEN INTERFACE:
I dont see much difference between the open other than the way we load data.
In case of open interface the data is loaded in to open interfce table like GL_INTERFACE or Sales Order Interface(OE_ORDER_HEADERS_IFACE_ALL).
Run the interface import program.
This will validate the data and put it into oracle applications.All the invalid records are marked as Error.
One thing is there are GUI Screens available for most of these interface where you check the errror message correct it there only and resubmit the interface.
From the technical perspective there are Error tables available for each interface

API:
API's are the oracle built packages where the validation logic is wrapped inside a package and the data is passed as parameters to the API.
Most of these api's use the PLSQL tables as paremeters to take the advantage of bulk binding concepts for faster loading data.
THey will have the two OUT parameterst to throw back the error code and message in case of data validation failure
Apis' are compartively faster than open interfaces.
If a API's and open interface are available it is better to load through API's.If the records are more...



This is what i understand till date...Plz put your comment in case of i am wrong any thing more that would be helpful to make this better...

25 comments:

Jithendra said...

Hi Murthy,

Nice to see you contribute the technical details of Oracle Apps. Myself a Technical Consultant in Oracle Apps have found your blog to be useful and I am adding to the List of Useful Blogs list of my own blog: http://jithendra-g.blogspot.com

Keep posting useful information! Thanks a lot for knowledge sharing! Keep rocking yar!

Jithendra

Saritha said...

Hi Murthy,
Nice way of sharing the information. Keep updating ur blog
Keep Going .. Good luck...

-- Saritha

Mr.V said...

hey boss...
u rule..this kinda work is totally new as far as oracle apps forums r concerned.

god bless u and the good work ..

vishal
Technical consultant

Gireesh - EDI said...

Hi murthy,

U r contribution is very helpful. update ur blog frequently. u r doing good job.

Giri
giri.apps06@gmail.com

Unknown said...

HI MURTHY,
THQU VERY MUCH FOR SHARIN THE USEFUL INFORMATION WITH US

Anonymous said...

for interfaces in oracle apps, i recommend use Conviface Software (www.conviface.com) excellent tool for interfaces and conversion,

Subash said...

Dear All,

Can anyone explain me on introduction of interfaces.(From Excel to Interface tables)

Unknown said...

jsr solutions a software development company is organising a test in quest univercity Mohali(landra) on the basis of

apttitude and gernal knowledge.The top 50 students who pass this test have to be taken for you can register your roll no

here free BTECH Training on free

Unknown said...

jsr solutions a software development company is organising a test in quest univercity Mohali(landra) on the basis of

apttitude and gernal knowledge.The top 50 students who pass this test have to be taken for you can register your roll no

here free BSC(IT) Training on free

Anonymous said...

Guys,
Good lord..now u r giving ad in a tech forum.
god knows what a fucking company u have to register.
Go to hell...u ashole

Anonymous said...

Hi Murthy...

I m learning Oracle Apps and i missed todays lecture on Interfaces.. This helps me to understand what Interfaces is.
thanks for ur efforts.
Keep it up...

author said...

hi
murthy thanxs alot u gave us a very
awesom material
dhamu(oracle apps learner)

Mano Rath said...

Thanks a lot Dear

venkiab said...

Hi Murthy

The information u have posted is very helpful...Thank u so much and please keep updating the blog

gautham menon said...
This comment has been removed by the author.
gautham menon said...

hi
murthy thanxs alot u gave us a very
awesom material

ranjeeth yadav said...

thanks for the info...:)

Anonymous said...

Hi murthy ,
iam new to this apps technology, ur blog is very useful to me. thanks a lot.

mithravinda said...

hi murthy,
can u plz provide me few work flow customizations.. with sample codes to my mail id. thanks in advance.
mithra.vinda25@yahoo.in

Unknown said...

Hi Murthy,
I hve done ORACLE D2k course, but I want 2 build my career in ORACLE APPs,so plz give me information about this or plz forward me.....
My email id:-
kumarashutosh3182@gmail.com

I also want 2 say, anybody who has knowledge about this then plz forward 2 my mail......

Thnx 2 All

Kumar Ashutosh

Anonymous said...

hi pls forword inportant interfaces
informations........from krishh

Unknown said...
This comment has been removed by the author.
Rosemary said...

thanks ..

Unknown said...

HI Murthy sir,

i am learning oracle apps techincal and please suggest me how to prepare the important concepts and especially interface and conversions.
if you hav notes on this topic please share it on my email-id :kumarmanoj356@gmail,com


thanks in advance

Unknown said...
This comment has been removed by the author.