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 |
How to find which company will be conducted Oracle appa interview? Plz help me
Difference between triggers and procedures?
How many typres of Purchase order and what are those.
what is the difference between oracle 8i and 9i?
What is request group
what is the difference between multiorg views and multiorg tables
2 Answers Immense Source, Intelligroup, TCS,
what is the difference between request group and request security group in oracle apps?
Give a brief overview on OrderManagement.
what are the default arguments for pl/sql program?
How to register a form and stored procedure in oracle apps
what is mutating table and mutating error and how to solve that?
What is sca and how is it useful?