Extract Pump generates incorrect trail record with 'OUTPUTFORMAT TEXT' parameter for negative numbers (Doc ID 2800519.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Extract Pump generates incorrect trail record with 'OUTPUTFORMAT TEXT' parameter for negative numbers.

Sample Extract Pump parameter file:
extract <Pump name>
OUTPUTFORMAT TEXT NAMES, OP, IND, DELIMITER '|', TS, _NOTRANSTMTS, _FILE, NOQUOTE
RMTHOST <IP Address>, mgrport < port no>
RMTRAIL <path>/pc
TABLE <schema>.<Tablename>;

When extract is running with OUTPUTFORMAT, column of type NUMBER(precision), having data with negative values of type is showing wrong values.
So insert statement like:
INSERT INTO <schema>.<Tablename>(ColA,ColB) VALUES ('TEST','-5');

Here ColB column is of NUMBER(6)
The incorrect output shown in text trail file was:
I|A|<Tablename>|2021-06-24:02:10:44.000000|<ColA>|TEST|<ColB>|18446744073709551611

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.