If user has a project with a larger name and most likely multi-byte characters, in Print Invoices page will have error [CA Clarity][Oracle JDBC Driver][Oracle]ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "NIKU.PAC_BIL_INVPRINTLOOKUP_SP"
Steps to Reproduce:
Expected: No error should appear when filter by project code on Print Invoices page
Actual: User got error: character string buffer too small ORA-06512: at "NIKU.PAC_BIL_INVPRINTLOOKUP_SP"
Component: TIME & DATA MANAGAEMENT"
The workaround is to increase the size of the following column that controls the variable data type like so.
Alter table TEMP_PAC_BIL_INVPRINTLOOKUP modify project_name varchar(256)
Pending resolution in a future Clarity release.
Keywords: CLARITYKB, CLRT-52574, clarity12open, print invoice, filter, project_name, ORA-06502