How to create ap payment by using plsql procedure?
Hi everyone,
Our system needs to connect to the third party's system.However, it seems that EBS have no open api to import payments.
I try to use internal api to create payment:
first,call ap_pay_invoice_pkg.ap_pay_invoice() insert data to ap_invoice_payments_all, and update invoice amount 、invoice remain amount in both ap_invoices_all and ap_ap_payment_schedules_all;
second,call ap_checks_pkg.insert_row() then create data in ap_checks_all;
at last,call ap_reconciliation_pkg.insert_payment_history to create payment history record.
But I fail in step 1,which raise exception ORA-20001: APP-SQLAP-10000: ORA-28115: policy with check option violation.