Home » Applications » Oracle Fusion Apps & E-Business Suite » R12 AP Invoice Payment Interface / API alternative (EBS 12.1.1 / Oracle Enterprise Linux)
R12 AP Invoice Payment Interface / API alternative [message #538853] Mon, 09 January 2012 20:39 Go to next message
xhyrruz
Messages: 14
Registered: June 2010
Location: Philippines
Junior Member

Hi All,

Currently I handle a project that would require loading of payment records from a staging table to OFIN R12. The issue is, Oracle itself doesn't provide an interface or API for AP Invoice Payments that load records from staging table or flat file to OFIN R12 payment tables. Is there any alternative or available API on R12 that can be utilize to performed similar functions?

Our working environment:
- EBS 12.1.1

Any help much appreciated.

Regards,
Cyrus
Re: R12 AP Invoice Payment Interface / API alternative [message #539280 is a reply to message #538853] Thu, 12 January 2012 21:44 Go to previous messageGo to next message
xhyrruz
Messages: 14
Registered: June 2010
Location: Philippines
Junior Member

Any help from you guys.

Regards,
Cyrus
Re: R12 AP Invoice Payment Interface / API alternative [message #539297 is a reply to message #539280] Fri, 13 January 2012 02:38 Go to previous messageGo to next message
John Watson
Messages: 4858
Registered: January 2010
Location: Global Village
Senior Member
Doesn't the Lockbox do what you need? Populate the AR_PAYMENTS_INTERFACE_ALL table with your payment records, and away you go.
Re: R12 AP Invoice Payment Interface / API alternative [message #539302 is a reply to message #539297] Fri, 13 January 2012 03:50 Go to previous messageGo to next message
xhyrruz
Messages: 14
Registered: June 2010
Location: Philippines
Junior Member

Hi John,

I am referring here a payments for AP Invoices. I want to load flat-file which contains payment records generated from "payment custom application".

Regards,
Cyrus
Re: R12 AP Invoice Payment Interface / API alternative [message #539304 is a reply to message #539302] Fri, 13 January 2012 03:59 Go to previous messageGo to next message
John Watson
Messages: 4858
Registered: January 2010
Location: Global Village
Senior Member
So what's the problem? That is what the Lockbox is for!
Load the data from your file into the interface table, as I said. You'll have to do some validations and coversions, of course: that can be a bit tricky. Then run the concurrent program to import into AP. It is all in the docs, you can automate the entire process.

[update: oh, hold on! I mis-read your question]

[Updated on: Fri, 13 January 2012 04:00]

Report message to a moderator

Re: R12 AP Invoice Payment Interface / API alternative [message #539316 is a reply to message #539304] Fri, 13 January 2012 04:25 Go to previous message
John Watson
Messages: 4858
Registered: January 2010
Location: Global Village
Senior Member
Sorry, I was talking about AR not AP. Problem with my eyes!

So you are using AP. What is this "payment custom application", does it make payments against purchase invoices that AP knows nothing about? If so, can't you set everything up through the payables open interface tables?
Previous Topic: Shared Status in Oracle License Manager
Next Topic: forms personalisation
Goto Forum:
  


Current Time: Fri Dec 19 01:17:46 CST 2014

Total time taken to generate the page: 0.14087 seconds