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.

10 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

Anonymous 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

Tobin Joseph said...

Hi,

Please let me know if there is any workaround like custom API to bring the paid invoices, Payments to AP.

Email: tobin.consultant@gmail.com

Anonymous said...

Thanks for sharing nice information, Hope you will share many more articles like this so that it will be helpful for many of us Oracle R12 Financials Training

12345 said...

Nice blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
Workday Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad

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.