APP-SQLAP-10380

APP-SQLAP-10380 You Cannot Select this Payment Document

Step 1. Check that there are no locks on the payment batch

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 = ;

Step 3. Once you have the 2 pieces of information from above, run the following:

ALTER system kill session 'sid, serial#'

No comments:

java.sql.SQLSyntaxErrorException: Access was denied to the user in MySQL 8.4.

 java.sql.SQLSyntaxErrorException: Access denied for user 'SIT'@'%' to database 'SIT' means the MySQL user SIT does ...