Payment Request - unable to decrypt db error

Owned by Kathleen Avery (Deactivated)
Last updated: Nov 22, 2017 by Richard Ritchie
1 min read

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;

 

 

Â