Payment Request - unable to decrypt db error

When running PurchasingPreDisbursementExtractJob in a non-production environment, you get a "unable to decrypt db" error message.  To correct the error, you have to mark all unpaid payment requests as paid.  This is done through db  SQL updates.  Run the following three SQL statements against the environment you want to test payment requests and commit the changes.

 

UPDATE AP_PMT_RQST_T SET PMT_EXTRT_DT='01-JAN-14' WHERE PMT_EXTRT_DT IS NULL;

UPDATE AP_CRDT_MEMO_T SET CRDT_MEMO_EXTRT_DT='01-JAN-14' WHERE CRDT_MEMO_EXTRT_DT IS NULL;

UPDATE FP_DV_DOC_T SET DV_EXTRT_DT='01-JAN-14' WHERE DV_EXTRT_DT IS NULL;

 

 

 

Related content

AutoApprovePaymentRequestsJob
AutoApprovePaymentRequestsJob
More like this
LoadDisbursementVouchersJob
LoadDisbursementVouchersJob
More like this
KFDM Production Support
KFDM Production Support
More like this
Post refresh re-encryption
Post refresh re-encryption
More like this
Kuali Cloud Internal test 2-Nightly Schedule Batch jobs
Kuali Cloud Internal test 2-Nightly Schedule Batch jobs
More like this
Non-Prod Data Refreshes
Non-Prod Data Refreshes
More like this