Home » Applications » Oracle Fusion Apps & E-Business Suite » what is difference between custom program and standard import program in oracle apps (Oracle Applications 11i)
what is difference between custom program and standard import program in oracle apps [message #317670] Fri, 02 May 2008 07:44 Go to next message
nagoorbabu
Messages: 4
Registered: May 2008
Location: Bangalore
Junior Member
Hi,

I have faced one quesition in interview regarding interface program,can any body please give proper answer

The quesition is

While transferring the data from Interface tables to Oracle base tables we will run the standard program in the interface. right. They r asking the question like why we have to run the standard prg. Why dont we develop the custom interface and run the interface.

Re: what is difference between custom program and standard import program in oracle apps [message #318048 is a reply to message #317670] Mon, 05 May 2008 07:45 Go to previous message
akil0576
Messages: 4
Registered: February 2008
Location: Jeddah
Junior Member
Oracle integrates its no. of processes with its interface tables where you feed data into these interface tables or even oracle standard processes use these tables to feed data before importing into base tables. So your task is just to feed data into these interface tables which can be exported from your custom applications or from other legacy systems. Then Oracle Standard program is used to import this data from interface tables to base tables. Why we dont write custom program to import data into base tables because we can lose data integrity and you might not get desired results from the system because Oracle Standard Program can call so many internal programmes which might run DML operations on other tables which you might not take care while writing your program. Hope answer the question well.


Akil Ayub
National Commercial Bank
Jeddah.
Previous Topic: clonning or duplicate
Next Topic: open interface, material transaction
Goto Forum:
  


Current Time: Wed Dec 07 22:21:13 CST 2016

Total time taken to generate the page: 0.09058 seconds