EPC 9.2: 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 JUNE 19, 2024
Applies to:
PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When the user tries to insert data into PS_PROJ_RES_DEL after building it, it fails with the below error. The insert works if the user does not create the table, it will not work if the table is dropped and recreated and this happens in some environments.
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).
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).
Replication Steps:
- In the debugging process, the PROJ_RES_TMP_DEL table was dropped.
- Using app designer, the build SQL was generated.
- Using SQL developer the, SQL script was executed.
- Now when trying to insert data into the table that has the description field value with special characters whose length = length of PROJ_RES_TMP_DEL.DESCR.
- The above error is received.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |