What is INBOUND and OUT BOUND? (Different types of
interfaces)
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 |
After deploying like forms,reports into server how we connect this forms,reports to web?
wht is the use of Xml reports over reports6i?
what are the default arguments for pl/sql program?
what are the important table names in purchasing?
can we write sql statement in Format trigger?
What is INBOUND and OUT BOUND? (Different types of interfaces)
17 Answers Accenture, Asian Paints, Inbound Solutions, Tech Mahindra,
how many groups we can create for query?
Tell me some thing about SQL-LOADER.
P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?
9 Answers CSC, IBM, KPIT, Oracle,
can we pass bind variablein lexical parameter?
what is MRC? Why it is needed?
How will you get the concurrent program output as email?