Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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;

 

 

 

  • No labels