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

Last updated on AUGUST 18, 2024

Applies to:

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

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