AP:R12: Payment Amount is Different than the Accounted Amount When Check is Reissued (Doc ID 1059577.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Payables - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms

When  check is voided and the new check is issued in its place , the accounted amount of the newly issued check goes wrong .

You can identify  check id's  for this bug by the following query :

SELECT ac.check_id,
 xe.event_id,
 xe.event_type_code,
 ac.org_id,
 SUM(nvl(entered_dr, 0)) -SUM(nvl(entered_cr, 0)) acctd_amt,
 ac.amount
 FROM ap_checks_all ac,
 xla.xla_transaction_entities xt,
 xla_events xe,
 xla_ae_headers xh,
 xla_ae_lines xl,
 ap_system_parameters_all asp
 WHERE xt.entity_code = 'AP_PAYMENTS'
 AND xt.application_id = 200
 AND xl.application_id = 200
 AND nvl(source_id_int_1, -99) = ac.check_id
 AND xt.entity_id = xe.entity_id
 AND xe.event_id = xh.event_id
 AND xe.upg_batch_id IS NULL
 AND xe.event_type_code = 'PAYMENT CREATED'
 AND xe.event_status_code = 'P'
 AND xe.application_id = 200
 AND ac.amount <> 0
 AND ac.void_date IS NULL
 AND xh.application_id = 200
 AND xh.ledger_id = asp.set_of_books_id
 AND xh.ae_header_id = xl.ae_header_id
 AND asp.org_id = ac.org_id
 AND xl.accounting_class_code = 'LIABILITY'
 AND EXISTS
 (SELECT 1
 FROM ap_payment_history_all aph2,
 ap_invoice_payments_all aip2,
 ap_invoice_payments_all aip
 WHERE aph2.transaction_type = 'PAYMENT CANCELLED'
 AND aph2.check_id = aip2.check_id
 AND aip2.invoice_id = aip.invoice_id
 AND aip.check_id = ac.check_id)
 GROUP BY ac.org_id,
 ac.check_id,
 ac.amount,
 xe.event_id,
 xe.event_type_code HAVING(SUM(nvl(entered_dr, 0)) -SUM(nvl(entered_cr,
 0))) <ac.amount;

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms