Clarity: Issue Credit Memo: character string buffer too small ORA-06512: at "NIKU.PAC_BIL_CM_INVLOOKUP_SP".

Document ID : KB000052487
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

If user has a project with a larger name and most likely multi byte characters, in Issue Credit Memo page, user will get error when filtering:

Internal Server Error. Contact your site administrator. ([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_CM_INVLOOKUP_SP", line 596 ORA-06512: at line 1)

Steps to Reproduce:

  1. Create a project with very large name and multi byte characters.

  2. Select a project, add financially enabled resource to team, create a task and add the resource to the task.

  3. Create a transaction with the project, task and the resource.

  4. Post to WIP.

  5. Select the transaction to generate an invoice.

  6. Go to Issue Credit Memos page.

  7. Select a record and click Filter.

Expected: No error should appear when filter by any parameter on Issue Credit Memo page.

Actual: User got error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "NIKU.PAC_BIL_CM_INVLOOKUP_SP".

Solution:

Workaround:

The workaround is to increase the size of the following column that controls the variable data type like so.

Alter table temp_tempPAC_BIL_CM_INVLOOKUP_ modify project_name varchar(256)

Status/Resolution:

Pending resolution in a future Clarity release.

Keywords: CLARITYKB, CLRT-52572, clarity12open, issue credit memo, filter, PAC_BIL_CM_INVLOOKUP_SP.