My Oracle Support Banner

R12: CE: Unable To VOID Payment Of A AP/AR Netting Transaction (Doc ID 3001007.1)

Last updated on SEPTEMBER 22, 2024

Applies to:

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

Symptoms

Unable to Void Payment, this payment was created as part of AP/AR netting.  However, the transaction number is not shown in the netting batch.

AP/AR netting processed and two(2) AP transactions are netting even though they are not selected or shown the netting report.  Then, the netting batch was reversed.  
All the transactions in the batch are VOIDED except the two(2) Payables Payments.

The problem Payments (Checks) Type are "AP/AR Netting" (AP_CHECKS_ALL.payment_type_flag = 'N')

The problem Payments (Checks) Status is set to Cleared (AP_CHECKS_ALL.status_lookup_code = 'CLEARED').

There is No record of these Payments in any Cash Management reconciled bank statement(Lines) (Table CE_STATEMENT_LINES show no rows for the payments). 

 

Steps to reproduce:

  1. Log into Oracle Applications using a Payables Responsibility
  2. Open the "Netting Batch" Home OAF Page
    (N) Payments > Entry > Netting > Netting Batch 
  3. Query the Netting Batch
  4. Reverse the batch successfully.
  5. Review the reversed batch.  All, but two(2) Payments of the batch are Void.

 

The following SQL fetches the problem Netting Batch and the problem checks involved:

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.