What is INBOUND and OUT BOUND? (Different types of
interfaces)
Answer Posted / 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 |
Post New Answer View All Answers
What is a flexfield? List out its types.
What does appl_top directory contain?
Can u give the Documentation of Custom.pll in oracle apps
What is oracle soa suite and what are its different components?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
How can we import the data into a database using sql * loader?
Do you know where we can check the status of po?
How to create a purchase order without a requisition?
q)what are the validations in sql*loader
what are the balancing segments in AR?
how can i print random rows in plsql table
What do you understand by a set of books?
What is sca and how is it useful?
Can we create tables in apps schema?
What are do's and dont's of Interface?