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