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.

In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?

1 Answers   Accenture,

What is the difference between buyer&employee in PO module?

7 Answers   TCS,

Which oracle apps version you are very confident in?

0 Answers  

in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?

1 Answers   KPMG,

What is secuirity's in R12 features.

1 Answers   KPIT,

How to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?

3 Answers   IBM,

while registering executable and concurent program we register both with application name|<oracle purchasing>? so my question is why we are defining in both concurent program and executable?

9 Answers  

how to use .prt file in bitmap reports?

2 Answers   Accenture,

what is MRC? Why it is needed?

4 Answers   Convergys,

Except the SRS window in which we can submit the concurrent program.

5 Answers   IBM, TCS,

we have select statement in that two exceptions that returns no value. In that which exception will raise?

2 Answers  

What are the validations you don in .CTL file in inbound interface process?

1 Answers