FT_EXTRACT Error: " The temp table must have columns for PROCESS_INSTANCE, UniqueGUID, and the specified domain elements (18028,2164" (Doc ID 2079271.1)

Last updated on NOVEMBER 19, 2015

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When running the FT_EXTRACT process after the application of Bug 22064793, the following error occurs.

ERROR

The temp table must have columns for PROCESS_INSTANCE, UniqueGUID, and the specified domain elements (18028,2164) EOTF_CORE.Xref.MapData.OnExecute Name:ExtractData PCPC:39132 Statement:616Called from:EOTF_CORE.Xref.MapData.OnExecute Name:PopulateData Statement:756Called from:EOTF_CORE.Xref.Functions.OnExecute Name:PopulateData Statement:372Called from:FT_INTEGRATION.ProcessControl.OnExecute Name:PopulateGuid Statement:97Called from:FT_COMMN_LIB.Guid.GBL.default.1900-01-01.PopGuid.OnExecute
2015-11-06-22.59.57.999711 DoStepActions [1856] Exception logged: RC=100.

Process 695990 ABENDED at Step FT_COMMN_LIB.Guid.PopGuid (PeopleCode) -- RC = 24 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

STEPS

The issue can be reproduced at will with the following steps:
1. Begin Fusion Extract (FT_EXTRACT) Process
2. Confirm Issue End in Error

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