Oracle APPS Account Payables Create Payment API
Hello,
In this tutorial, I am going to share an unknown method for creating paymanets on Oracle EBS Account Payables. Since there isn’t any public API provided by Oracle, as developers we are investing into new methods. There is a buggy API which is provided by Oracle. It’s name is AP_PAY_SINGLE_INVOICE_PKG and it has a single procedure with the name of AP_Pay_Invoice_In_Full. So far, everything looks perfect. However this API has a minor bug which prevents creating payments. We need to set check number variable to -1 instead of null.
So we need to copy all of the package into a new XX named package and add the following code into it.
|
1 2 3 4 5 |
if l_next_check_number is null and l_seq_num_profile in ('P') and p_doc_category_code is null then l_next_check_number := -1; end if; |
You can download whole packge by clicking to the following link:
In order to call this procedure, you can use following code. Another important point is you have to pass p_payment_type_flag parameter with the value of “A”. Otherwise it is not going to work.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
xx_ap_pay_single_invoice_pkg.ap_pay_invoice_in_full ( p_api_version => 1.0, p_init_msg_list => fnd_api.g_true, p_invoice_id => l_invoice_id, p_payment_type_flag => 'A', p_internal_bank_acct_id => l_bank_account_id, p_payment_method_code => l_payment_method_code, p_payment_profile_id => l_payment_profile_id, p_payment_document_id => null, p_take_discount => 'N', p_check_date => trunc(sysdate), p_doc_category_code => null, p_exchange_rate_type => null, p_exchange_rate => null, p_exchange_date => null, x_return_status => l_return_status, x_msg_count => l_msg_count, x_msg_data => l_msg_data, x_errorids => l_error_ids ); |
Best Regards.
hi ,
i used the below
AP_PAY_SINGLE_INVOICE_PKG.AP_Pay_Invoice_In_Full
payment has been created , but once i run create accounting for payment created , status is incomplete , and after trucking
Ap_Invoice_Payments_All .ACCOUNTING_EVENT_ID is created null .
any technical hepl please.
the below parameter
Hi Edmond,
We got the same problem. We are trying to solve it. If I find out any solution, I will let you know.
you need to call the xla event api to create an event id for payment and update that event id in Ap_Invoice_Payments_All .ACCOUNTING_EVENT_ID
Thank you!
please review patch 21531246
Hi There,
Can you provide more information on what Iparameters I need to pass if I have to create payment using payment details.
e.g. payment amount, gl date. Payment date, exchange rate etc.
Regards,
Mathew
Can you send me your mobile ? I need to get some help on this API.
Please provide e-mail
Is there any solution for the payment that already created but cant create accounting?
please help
Did you try Luqman’s solution? you need to call the xla event api to create an event id for payment and update that event id in Ap_Invoice_Payments_All .ACCOUNTING_EVENT_ID
If possible can you please share the script to create invoice payment..
Matt or altunkan
Can you please help me regarding the same API.
please reach me once at skc.amar@gmail.com
Regards
Amar
Hi iwont validation code plz share
Create procedure and run the conc program
Error accord can’t insert the check table
Hi can you share xla event api script
any other way
Hi , thanks your share , but I use the your procedure that only return status “U” , no any msg_count and no any msg_data , can you share your more code thanks. angotsai@gmail.com.
Hi , thanks your share , but I use the your procedure that only return status “U” , no any msg_count and no any msg_data , can you share your more code thanks. angotsai@gmail.com.
Could you please share your complete code
I try to share my api,but i found the website cannot post it in chinese….