What is INBOUND and OUT BOUND? (Different types of
interfaces)
- 17 Answers
- 123114 Views
- Accenture, Asian Paints, Inbound Solutions, Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sudha
OUT BOUND: IT USED TO EXTRACT THE DATA FROM LEGACY SYSTEM OR EXISTING SYSTEM TO FLAT FILES IS CALLED OUT BOUND
IN BOUND: IT IS USED TO TRANSFER THE DATA FROM FLAT FILE TO ORACLE APPLICATIONS BASE TABLES
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / ramireddy
OUT BOUND INTERFACE:TRANSFER DATA FROM BASE TABLES TO TEXT
FILES BY UTL_FILE API'S.
IN BOUND INTERFACE:TRANSFER DATA FROM FLAT FILE TO BASE TABLES
BY USING FOLLOWING:
FLAT FILE
FOR FF TO ST,DEVELOP SQL * LOADER PROGRAM
STAGE TABLES
FOR ST TO UT,DEVELOP PL/SQL PROGRAM WITH VALIDATIONS
INTERFACE TABLES
FOR UT TO BT,RUN ORACLE APP’S STANDARD PROGRAM
BASE TABLES
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / srikanth
inbound: the process of loadind date from legacy system to oracle apps is called in bound interface
out bound: the process of extracting data from database to flat file is called outbound interface
two approaches:
1) utl_file approach
2) sl approach
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / janakiram
in bound interface:data transforming from file to table is
called in bound interface
out bound interface:data transforming from table to file is
called out bound interface
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / prashanth
Inbound :
The data flows from legacy system -> interface of legacy system->Staging Tables-> Interface tables-> base tables.
outbound :
the data flows from database tables(base tables-> interface tables) -> flat files
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / @sanjay
inbound means the data of the base table to transfer the legency system to oracle base table.
outbound means the data of the oracle base table to base table of the system
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sudershan
In bound:Getting the data from flat file into base table
Out bound:Retrieve the data from base table to flat file
| Is This Answer Correct ? | 0 Yes | 1 No |
HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT
Do you know where we can check the status of po?
how to make a parameter optional in the query?
What is multi org?
What is Pragma Autonomous transaction. It's Real time Example
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
List the various types of value set.
In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?
what is flexfield qualifier?
what are centralized and decentralized level of control of item attributes?
what is the diff between custom.pll and form personalization? Tell me one example?
how many groups we can create for query?
Oracle Apps Technical 
