You are working with interfaces if client doesnot give any
flat then what will u do?
- 8 Answers
- 10686 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 8 Yes | 0 No |
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.
| Is This Answer Correct ? | 3 Yes | 1 No |
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Do you know what are user profiles in apps. Any examples you can give?
what is the difference between procedure and function
1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?
what is user exit and wat program do we write in user exit?
what is latest version in reports
what is pay run id ?
what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference
mention the interface tables for item open interface and open transaction interface and also their respective production tables.
what is the back ground program run while transferring data from OM to AR?
How do u identity its name of report?
How can u populate data into po_headers_all segment2 column?
How to know the number of invoices generated for one PO from front end (navigation)?
Oracle Apps Technical 
