Error on Sun 6.1 'Payment Profile In Use - Please try again'
Description:
A warning message appeared "Payment Profile in use-please try again " when processing the payment in PYR Payment Run.
How to solve this issue?
Resolution:
1. Log everyone out of the system and then run both ZZC and ZZL clear users and financial locks. Also, check the _work folders to ensure that there are no work files present when everyone is logged out. If there are, delete or move the files.
2. If the above doesn't work, try to remove the contents of the ZZZ_SAPYPAY table of your SQL database. ZZZ stands for the business unit in question.
The SAPYPAY table is used to create temporary entries during the payment run, and these will usually be cleared when this is finished.
1) Please ensure you have your SUN database backed up .
2) Login to SQL Server Enterprise Manager or Management Studio.
3) Select New Query on the tool bar and execute the script below:
use SUNDB (where SUNDB = name of SUN database)
go
delete from ZZZ_SAPYPAY (where ZZZ = Business Unit code)
go
If you don't wish to clear the entire table, you could also look up the Payment File Identifier in Payment Profiles and just delete that entry line with the same identifier in PROFILE_IND field from the table; this also should solve the issue. If you don't have different profiles or different profile identifiers, try to remove the first line only.
---------------------------------------------------------------------------------------------------------------------------