(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?
- 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.
This error occurs when a user exits the application while processing a quickcheck.
APP-10027: Payables is reserving the document payment
Cannot process another check with this payment document
Unable to requery check
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