Solution : https://service.sap.com/sap/support/notes/591600 (SAP Service marketplace login required)
Summary :
This SAP Note addresses various Oracle errors related to data type mismatches and overflow issues in SAP systems, such as ORA-01401, ORA-01438, and ORA-12899. These errors typically occur when data inserted into a table exceeds the column's capacity or mismatches the expected data type. The document provides guidance on tracing the source of the errors using tools like ST05 for SQL trace and transactions SE11 or SE14 to check database consistency. It highlights application-level misconfigurations as common culprits and suggests checking SAP Notes for specific error codes, confirming the necessity of aligning SAP's Data Dictionary with Oracle's table definitions. Further, it recommends using "ANALYZE TABLE" for detecting inconsistencies in Oracle, and advises on software patches in case of bugs.
Key words :
converting column overflows integer datatypeora-01722, internal call source code, sql> create table test, exact sql statement, relevant developer trace, relevant log files, terms dbif_rsql_sql_error reason, find sap notes, oracle client software, required table contents
Related Notes :
| 1102641 | Consult: Dump during insert in PSA table due to incorr vals |
| 821529 | Update termination with option rate determination |
| 554266 | ORA-1438, for example, when loading an InfoCube |
| 365481 | Block corruptions |
| 23345 | Consistency check of ORACLE database |