Home » Applications » Oracle Fusion Apps & E-Business Suite » Interface
Interface [message #211241] Wed, 27 December 2006 09:22 Go to next message
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 #211277 is a reply to message #211241] Wed, 27 December 2006 13:48 Go to previous messageGo to next message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
Hi,

Which interface program are you reffering?


Regards
Prashant Pathak
Re: Interface [message #211432 is a reply to message #211277] Thu, 28 December 2006 11:08 Go to previous messageGo to next message
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 #211436 is a reply to message #211241] Thu, 28 December 2006 11:56 Go to previous messageGo to next message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
Hi,

Just to get idea about the interface you may read User Guide for that particular module.

For Order Management API and interface
http://download-east.oracle.com/docs/cd/B25516_11/current/acrobat/115omapi.zip
Oracle Project
http://download-east.oracle.com/docs/cd/B25516_11/current/acrobat/115pjapi.zip

for 11.5.10.2 General documentation section

http://download-east.oracle.com/docs/cd/B25516_11/current/html/homeset.html


Regards
Prashant
Re: Interface [message #211767 is a reply to message #211436] Tue, 02 January 2007 04:04 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Autoinvoice Setups
Next Topic: Custom pll problem
Goto Forum:
  


Current Time: Fri Dec 09 01:58:26 CST 2016

Total time taken to generate the page: 0.15245 seconds