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 |
What is Place holder Columns?
How will you get the concurrent program output as email?
API?s FOR CUSTOMER INTERFACE? Tell me some API's?
What is P2P cycle.
27 Answers Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,
where do u specify in org_id?
what is the difference between request group and request security group in oracle apps?
I want to develop a oracle applications report using report builder 6i. I have two user parameters. How to provide list of values to parameters, which should show me at the time of submitting concurrent program.
1 Answers Genpact, Y3K Imaginations,
How many standard interface programs in oracle purchasing module and oracle inventory? What are they?
Sys Admin Module?
what is the prerequisite for defining unit of measure?
HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION
what are the different types of parameters avialable in reports?