EeS: SQL Error, "CLI0109E String Data Right truncation" when Supplier user accepts an eSettlement Agreement (Doc ID 1569792.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN eSettlements - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

SQL Error when Supplier user accepts an eSettlement Agreement

ERROR:
Return 8601 CLI0109E String Data Right truncation SQL STATE 22001
Failed SQL Stmt: INSERT INTO PS_PT_WF_NOTFY_TBL
Fatal SQL Error Occurred (2,125) PT_WF_NOTIFICATION.Notification.OnExecute

STEPS:
1) Login as a eSettlements Supplier User
2) Go to Review Agreements page
3) Open an Agreement that is Ready for Review by Supplier and click 'Accept Agreement'

Above error occurs

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms