APP-SQLAP-10380: You cannot select this payment document

(1)APP-SQLAP-10380: You cannot select this payment document because it is in use by another payment batch. Please select another payment document.

 

The solution from Metalink:

How to resolve the error, APP-10380 APP-10027, when attempting to process a check through the Payment Workbench?
 

1. Sol: The following Errors have been reported when attempting to process a check through the Payment Workbench (APXPAWKB):

   APP-10380 This payment document is an invalid selection because it is in use by another payment batch.
   APP-10027: Payables is reserving the document payment
   Cannot process another check with this payment document
   Unable to requery check

   This error occurs when a user exits the application while processing a quickcheck.
   To Fix:

   Kill the session at the database level of the user who's pc crashed.
   Have the DBA do the following:

   Step 1. Logon to SQL*Plus.
   Run the following:
   select a.object_id, a.session_id, b.object_name
   from v$locked_object a, dba_objects b
   where a.object_id = b.object_id
   This select should return one row displaying AP_CHECK_STOCKS_ALL.

   Step 2. Get the user's session ID and serial number.
   select sid, serial# from v$session
   where sid = <session_id from previous select>;

   Step 3. Once you have the 2 pieces of information from above, run the following:
   alter system kill session 'sid, serial#'

(2)APP-SQLAP-10380 You cannot select this payment document.
The payment document is used by another Payment Batch , which status is FORMATTED

Cause

Cannot use the payment document because the payment patch is not confirmed or cancelled


Solution

To implement the solution, please execute the following steps:

1. Login with a Payables Responsibility
2. Navigate Payments -> Payment Batch
3. Query the payment batch which use the payment document
4. Click on the 'Actions' button
5. Confirm or Cancel the payment batch
6. Payment document can be selected in the new payment

References

Note 221068.1 - Payment Workbench Form Generates Error APP-SQLAP-10380 Creating A New Payment