My Oracle Support Banner

R12: AP/IBY: Payables Payments Created By System With Document Number As -1 (Doc ID 2984199.1)

Last updated on NOVEMBER 03, 2023

Applies to:

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

Symptoms

A Payables payments created by system with document number as -1.

The user processed a full payment of an invoice.  It seems, the system has created 2 payments records; one with document number -1 and other one as given by user.

The invoice has been closed with the payment created by the user.  But the orphan payment (with document number -1) needs to be removed.

Steps to reproduce:

  1. Log into Oracle Applications using a Payables Responsibility.
  2. Open the Invoice Workbench screen
    (N) Invoices > Entry > Invoice
  3. Query the Invoice to pay.  For example Invoice_ID 1799981
  4. Click on [Actions ...] button to open the "Invoice Actions" window.
  5. Select option "Pay In Full" and [OK]
  6. The Payment Workbench opens.
  7. Complete the Payment header information. 
    Make sure to enter a manual Document Number for example 1234567890
  8. And Save (Submit).  Got the Check_ID of the Payment Created; for example 1799937
      
  9. Via SQL*Plus, query table AP_CHECKS_ALL for records with Check_ID close to check_ID 1799937 
  10. Among the records returned, two have the exact same data, except for the Check_ID and Chec_Number.
    CHECK_ID CHECK_NUMBER AMOUNT CHECK_DATE CREATION_DATE CREATE_BY LAST_UPDATE_DATE LASTY_UPDATED_BY STATUS_LOOKUP_CODE VENDOR_NAME ...
    1799937 1234567890 120.45 20-OCT-2023 21-OCT-2023 12:10:23 1199911  21-OCT-2023 12:10:23 1199911 NEGOTIABLE MY VENDOR  ...
    1799942 -1 120.45 20-OCT-2023 21-OCT-2023 12:10:23 1199911  21-OCT-2023 12:10:23 1199911 NEGOTIABLE MY VENDPOR ...
      

 

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.