| Interface [message #211241] |
Wed, 27 December 2006 09:22  |
r_ash3
Messages: 9
Registered: December 2006
|
Junior Member |
|
|
Hi,
The Interface Import Programs do most of the validations.Can any
one guide me how in real time they determine the columns to be validated ?
|
|
|
|
|
|
| Re: Interface [message #211432 is a reply to message #211277] |
Thu, 28 December 2006 11:08  |
r_ash3
Messages: 9
Registered: December 2006
|
Junior Member |
|
|
Hi Navik,
All the standard open interface import programs do certain validations that meet almost all the requirements,
say,for instance,payables open interface import validates invoice number,invoice type,invoice amount,distribution line number and so on.
So in real time if i am assigned to prepare an interface program that would import invoice data from legacy system to Oracle APPS base tables: ap_invoices_all,ap_invoice_distributions_all,ap_payment_schedules_all,what are the things that i would be asked to validate?
How to gain knowledge regarding the above with reference to other modules interfaces also?
|
|
|
|
|
|
| Re: Interface [message #211767 is a reply to message #211436] |
Tue, 02 January 2007 04:04 |
r_ash3
Messages: 9
Registered: December 2006
|
Junior Member |
|
|
Hi Prashant,
Thanks for the info.What I wanted exactly was
1. "If you write an interface for loading invoices into Oracle Payables tables,what are the columns will you validate ?"
2. "What dictates the selection of columns for validation? Is it
the flat file (containing the data from legacy system)or
something else?"
Regards,
Rafeek.
|
|
|
|
| Re: Interface [message #211793 is a reply to message #211767] |
Tue, 02 January 2007 05:56 |
sudhaputtagunta
Messages: 7
Registered: January 2007
|
Junior Member |
|
|
Hi Rafeek,
In real time if ur given an inbound interface validations required to do will be given in ur MD20 (Functional doc).
It will depend on business requirement.
Sudha
|
|
|
|
| Re: Interface [message #211816 is a reply to message #211767] |
Tue, 02 January 2007 07:50 |
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
|
Senior Member |
|
|
Hi,
It all depends on your business community.
What actually their requirements are?
But interestingly they want better exception handling reporting mechanism to inform production support guys.
Regards
Prashant
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
