This voucher cannot be changed because it is currently in use by Budget Checking process. (7030,986)

Error :

This voucher cannot be changed because it is currently in use by Budget Checking process. (7030,986)
Resolution :

Update the fields IN_PROCESS_FLG = 'N' and  PROCESS_INSTANCE = 0 in PS_VOUCHER table.
UPDATE PS_VOUCHER SET PROCESS_INSTANCE=0 , IN_PROCESS_FLG = 'N' WHERE BUSINESS_UNIT ='ABCD' AND VOUCHER_ID='V001'

Update the field KK_PROCESS_STATUS ='V' in PS_KK_SHDR_APVCHR

UPDATE PS_KK_SHDR_APVCHR SET KK_PROCESS_STATUS='V' WHERE BUSINESS_UNIT ='ABCD' AND VOUCHER_ID='V001'

Run the budget check process again.

DATETIMESTAMP Issue After Upgrade 8.4 to 9.1 application and FS_BP Issue in 9.1

Issue : All the DATETIMESTAMP fields show only Date in MM-DD-YYYY format.




Solution : DATABASE_OPTIONS field set to 34



SELECT DATABASE_OPTIONS  FROM PSSTATUS


Question: How to get numeric value from Alpha Number data


Eg :  VOUCHER ID = 1234ABCD


Out put : 1234


Solution : SELECT REGEXP_REPLACE(VOUCHER_ID,'[[:alpha:]]') FROM PS_VOUCHER WHERE WHERE VOUCHER_ID='1234ABCD'


Output : VOUCHER_ID=1234


Question : Voucher Budget Check Error : FS_BP process Request 1 attempted to process documents that are locked by another request.


"Warning: Request 1 attempted to process documents that are locked by another request. (18021,96)" While Budget Checking AP Vouchers"


Solution :


For version 9.1 and later update PS_KK_SHDR_APVCHR.KK_PROCESS_STATUS ='V'


UPDATE sysadm.PS_KK_SHDR_APVCHR SET KK_PROCESS_STATUS= 'V' WHERE KK_PROC_INSTANCE = AND KK_PROCESS_STATUS = 'I';

For versions prior to 9.1 update PS_KK_SOURCE_HDR.KK_PROCESS_STATUS = 'N'


UPDATE sysadm.PS_KK_SOURCE_HDR SET KK_PROCESS_STATUS= 'N' WHERE KK_PROC_INSTANCE = AND KK_PROCESS_STATUS = 'I';


PS_KK_SOURCE_LN
PS_KK_ACTIVITY_LOG
PS_KK_LIQUIDATION - Check for PO Voucher
PS_KK_REFERENCE - Check for PO Voucher

Crystal & Nvision Reports are in queued status in Process Scheduler 9.1

Error : Signon Process Timed Out. Please Retry (0,0)


Resolved : Check to see if there is any crystal running at the o/s level (Task Manager).
Check for the process pscrrun.exe and Kill the process
Bring down the process scheduler and clean the IPC resource and the process scheduler cache.


Error : nVision Reports are running for a long hours


Resolved  :  Logon to Process Scheduler NT Server Machine
Check to see if there is any nvision running at the o/s level (Task Manager) for long hours
Check for the process psnvs.exe and Kill the process
Bring down the process scheduler and clean the IPC resource and the process scheduler cache.