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 can u call a standard interface program from sql or pl/sql code?
Is there any limitations on responsibility assigned to a apps user?
What is a value set? List its various types.
HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT
What is OM Cycle and What do u mean by Alternate Item
What are the benefits of using soa architecture?
WHAT IS REFCURSOR IN ORACLE ?
what is the purpose of standard cost update?
can we get profile values in report without using user exists is it possible how?
what are the receipt types in Po?
What is the most critical part which you had faced in your project ?
1 Answers LG, Satyam, Tech Mahindra,
what type of testing u r doing?