Answer Posted / 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

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2334

---

What is count(*) from po_vendors(any table)?

1036

---

What is a value set? List its various types.

1038

---

How can you achieve loose coupling in soa framework?

1178

---

What are do's and dont's of Interface?

2371

---

Do you know where we can check the status of po?

1191

---

Can you explain the difference between architecture followed in 10g & 11g?

1020

---

What is a flexfield? List out its types.

1112

---

do you know is it possible to run the interface without using oracle apps?

1068

---

How can we import the data into a database using sql * loader?

1125

---

can we get profile values in report without using user exists is it possible how?

2828

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3577

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

2164

---

In hierarchical structure of a database? we have write query from where we should start?

2177

---

q)what are the validations in sql*loader

2335

---