Sunday, August 31, 2008

Importing Payments and Paid Invoices into Oracle - Oracle needs to provide an API

How many of us had a requirement of importing paid invoices and their corressponding payment details to Oracle? I would say many. But strangely till date there in no straight forward method to import payments into Oracle. I feel its time that Oracle comes up with a standard process like an API to handle this business need.
There are a few workarounds to this scenario. A direct update of Oracle base table is one but this comes with the risk of losing support from Oracle.
The other, more robust way would be to use the manual payment feature of Oracle to record such payments that have been already done in the earlier system. However, automating this process using a batch program is a challenge.
Do put in your comments in case you have a soultion to this problem which would help a lot of people out there.

8 comments:

Gareth said...

Hi,
Try private API AP_PAY_SINGLE_INVOICE_PKG.AP_PAY_INVOICE_IN_FULL, some info here:
http://forums.oracle.com/forums/message.jspa?messageID=2358519

Regards,
Gareth
http://garethroberts.blogspot.com

Krishanu Bose said...

Thanks Gareth. I had seen your posting in the forum. But this is a standard procedure, and my feeling is Oracle should try and put in a place a public API to address this generic needs faced by most of us when we go in for payments conversion.

Krishanu

Anonymous said...

Can XML gateway interface used for this scenario? I am not an expert but was under the impression that XML Gateway provides rich interface to integrate with other systems (including custom programs) using xml messaging.

Krishanu Bose said...

XML invoices that are sent electronically from supplier can be processed through the Oracle XML Gateway. However, by using this gateway you do not get any additional API's for invoice import.

Krishanu

Murali said...

Hi:
Any luck on how to import Payments without impacting Support.
Thanks
Murali

Anonymous said...

Hi Krishanu Bose,

We have the same requirement to load paid invoices to AP. Can you give us some ideas on how to solve this?

Thanks

Anonymous said...

Hi,

Any workaround to bring the paid invoices, Payments to AP.

Thanks

Sridevi Koduru said...

I am Sridevi Koduru, Senior Oracle Apps Trainer at Oracleappstechnical.com With 8 Yrs Exp on Oracle Apps and 13 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K. I have Provided Training for 500+ Professionals Most of them are Working in Real Time now.

Contact for (One to One Personal Online Training) on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K at training@oracleappstechnical.com | sridevikoduru@oracleappstechnical.com | +91-9581017828 | http://www.oracleappstechnical.com

Linkedin profile - http://in.linkedin.com/pub/sridevi-koduru/8b/76a/9b8/

About Me

My Photo
India
Krishanu's Oracle Applications Blog - Oracle Apps consulting services scenario in India. Also, an inside view of Oracle Apps outsource services in India. Also the blog features new developments in Oracle Apps and my learning's in this field. The views expressed are my own only and not of my employer Wipro Technologies. The views and opinions expressed by visitors to this blog are theirs and do not necessarily reflect mine.