OIM: ORA-12899: value too large for column "WFMESSAGEATTRIBUTE"."STRINGVALUE" (actual: 2003, maximum: 2000)

The request fails with an error message: ORA-12899: value too large for column "WFMESSAGEATTRIBUTE"."STRINGVALUE" (actual: 2003, maximum: 2000)

The root cause is simple, OIM allows justification of 4000 characters but SOA supports justification of maximum of 2000 characters

We need to restrict justification to 2000 characters in OIM. 

Justification is a inputText field in ADF’s terms and one of the fields property is ‘Maximum Length’. 

Solution: Create a SB,  update the maximum length property to 2000 and test.