DisbursementVoucherPreDisbursementProcessorExtractJob
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.