SAP® Documentation

Single view

ORACLE DB error -1438 for transport with R3trans
Tip-No.: 3043 ( INFO3043 )

BAL_S_LOG - Application Log: Log header data   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.
SAP E-Book

Short text

ORACLE DB error -1438 for transport with R3trans
Tip-No.: 3043

Symptom

When copying clients or transporting with the R3trans utility, Release
1.1H encounters a data base error (-1438).

Cause

Error in the SAP data base interface when handling new fields that were
added to existing data base tables withthe ADD-field facility and were
implemented as NULL value fields in Oracle for this purpose. The problem
is restricted to transparent tables, and only those in which packed
fields were added to with ADD-field. This is the case for:
- KNA1, Field UMSAT and
- BSIK, Field QSFBT

This kind of error is not possible for pool tables.

Solution

The error can be prevented in two ways:

1) Client copying only for control tables instead of all tables
(inclusive application tables with master and movement data).
In most cases, client copying should also be restricted to purely
control tables - use the procedure described in the installations
guidelines that is based on the utility report RSCLIC01 or RSCLIC02.

2) Eliminate the NULL-Values in the Oracle data base using the following
SQLPLUS or EXEC SQL command:
UPDATE KNA1 SET UMSAT = 0 WHERE UMSAT IS NULL;
and
UPDATE BSIK SET QSFBT = 0 WHERE QSFBT IS NULL;






BAL_S_LOG - Application Log: Log header data   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 1486 Date: 20191022 Time: 024403     sap01-206 ( 6 ms )

Our Service

Looking for Support? Questions?

The

Consolut

Callback-Service

Leave us your contact details and we will call you back. Panels marked with * are mandatory.