Payables and Cash Management - EBS (MOSC)
MOSC Banner

How to create ap payment by using plsql procedure?

edited Oct 27, 2018 5:00AM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center