Answer / shashi

In practical scenario, we usually get the interface data in
flat file during the QA testing phase of the project.
During the Initial Development the Developer will create a
sample data flat file based on the technical design
document data mapping layout for unit testing of the code.
This code will be fine tuned based on the actual flat file
received from the client for testing.

There will be less code changes if the client communicates
the exact columns/lengths and their positions in the flat
file to the functional/technical designer.

Lot of interface data/code errors are due to
miscommunication between the
client/Business representative
==> Functional Design Document
==> Technical Design Document
==> Final Interface Code

Thanks,
Shashi

Answer / raam

we will develop the program as per the technical document
we have and we will ask the client to provide the flat file.

Answer / mihir

as per my knowledge it is not possible to create an
interface without any flat table.
so a flat file is surely required to develope an interface.

Answer / uday

I will take the mandatory columns

Answer / swathi

Sorry the question is not clear

The flat file or a csv file contains the data of the client.

May be your question is he is not giving in a flat file
format. By taking the data available from him u have to
create a flat file to load into interfaces.

Answer / tangerala swati

then wat will u convert dear?

Answer / zaheer

with out flat file how can u develop the interface or
conversion. To develop this we required cv040 document,
excel file or flat file.

Answer / oracle apps techno-functional

This seems to be a trick question for the inexperienced.
If there is anyway, the Interviewer should reveal the answer after having heard from the candidate. That would be like a gentleman.

There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.

3 Answers   Satyam,

why do we validate the records while developing interface?

3 Answers   TCS,

Attribute data types?

2 Answers  

Stored procedure?

4 Answers  

which API to return the parameters & valuesets etc

1 Answers   GE, TCS,

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

0 Answers  

Tell me some interface tables on ordermangement.

1 Answers   Zensar,

Explain the multi-organization structure.

1 Answers   Accenture,

what is instead of trigger. what is the use of that?

3 Answers  

in which tables the transaction details stored? at least two.

5 Answers   Scan Steel,

in which table sub inventory related information for item is stored?

3 Answers   chain sys, Scan Steel,

How to know the number of invoices generated for one PO from front end (navigation)?

1 Answers   Oracle,