DisbursementVoucherPreDisbursementProcessorExtractJob

Owned by Kathleen Avery (Deactivated)
Nov 12, 2014

Description:

This job extracts approved disbursement vouchers having a payment of Check/ACH into PDP. The disbursement vouchers appear as open payments in PDP.

The DV’s that are ready to be processed by this job will have a status of “A” . The job will set this status to “X” upon sucessful completion of the job.

Error Found:

This job has been known to fail when the Special handling name generated programmatically results in a string that exceeds 90 characters.  This data results from the concatenation of the literal 'Send Check To:' and the contents of KFS_PRD.FP_DV_PAYEE_DTL_T.DV_RMT_PRSN_NM.

The exact error thrown by the job is shown below.

Caused by: java.sql.SQLException: ORA-12899: value too large for column "KFS_PRD"."PDP_PMT_NTE_TXT_T"."CUST_NTE_TXT" (actual: 91, maximum: 90)

Method to verify that this is in fact the issue:

  • In SQL Developer, execute the following query:

    SELECT * FROM KFS_PRD.FP_DV_PAYEE_DTL_T Where Length ('Send Check To: ' || DV_RMT_PRSN_NM) > 90;

  • Verify that the contents of the DV_RMT_PRSN_NM field is greater than 76 characters.

Resolution:

 Notify Finance Systems Office of the error.