Unable To Insert Data Into PS_PROJ_RES_DEL Delivered Table. Receiving - SQL Error: ORA-12899: value too large for column "SYSADM"."PS_PROJ_RES_DEL_TMP"."DESCR" (actual: 32, maximum: 30) (Doc ID 2137905.1)

Last updated on MAY 18, 2016

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Conversion

We are trying to insert data into PS_PROJ_RES_DEL after building it, it fails because of this error :

SQL Error: ORA-12899: value too large for column "SYSADM"."PS_PROJ_RES_DEL_TMP"."DESCR" (actual: 32, maximum: 30)
12899. 00000 - "value too large for column %s (actual: %s, maximum: %s)"
*Cause: An attempt was made to insert or update a column with a value
  which is too wide for the width of the destination column.
  The name of the column is given, along with the actual width
  of the value, and the maximum allowed width of the column.
  Note that widths are reported in characters if character length
  semantics are in effect for the column, otherwise widths are
  reported in bytes.
*Action: Examine the SQL statement for correctness. Check source
  and destination column data types.
  Either make the destination column wider, or use a subset
  of the source column (i.e. use substring).

Attachment has the SQL attached for INSERT a row in DEMO ( PS Fin 9.2) , it works if you do not create the table, it will not work if the table is dropped and recreated and thats happening in our UAT environment and Development now.

When attempting to ,
the following error occurs.

ERROR
-----------------------

SQL Error: ORA-12899: value too large for column "SYSADM"."PS_PROJ_RES_DEL_TMP"."DESCR" (actual: 32, maximum: 30)
12899. 00000 - "value too large for column %s (actual: %s, maximum: %s)"
*Cause: An attempt was made to insert or update a column with a value
  which is too wide for the width of the destination column.
  The name of the column is given, along with the actual width
  of the value, and the maximum allowed width of the column.
  Note that widths are reported in characters if character length
  semantics are in effect for the column, otherwise widths are
  reported in bytes.
*Action: Examine the SQL statement for correctness. Check source
  and destination column data types.
  Either make the destination column wider, or use a subset
  of the source column (i.e. use substring).


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In the debugging process, the PROJ_RES_TMP_DEL table was dropped
2. Using app designer, the build SQL was generated
3. Using SQL developer the, SQL script was executed
4. Now when trying to insert data into table that has description field value with special characters whose length = length of PROJ_RES_TMP_DEL.DESCR
5. Above error is received

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