Data Archive Manager HRS_APP_PROFILE and HRS_PROFILE_HST Records Order Mismatch Error: "Incorrect History Record Definition (HRS_PROFILE_HST) for Record HRS_APP_PROFILE. (142,97)" (Doc ID 1946347.1)

Last updated on NOVEMBER 19, 2014

Applies to:

PeopleSoft Enterprise HRMS Talent Acquisition Manager - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue with 9.2 Talent Acquisition Manager (TAM) Data Archive Manager for the Record HRS_APP_PROFILE.

1. Primary Record HRS_APP_PROFILE: Having the field HRS_AUDIT_SBR as last field in it.
2. History Record HRS_ PROFILE_HST: Having the field HRS_AUDIT_SBR as 40th field(not the last one) in it.

Due to field order mismatch getting the error as

"Incorrect history record definition (HRS_PROFILE_HST) for record HRS_APP_PROFILE. (142,97)

The definition of the history record does not satisfy requirements for the Data Archive Manager. The history record must have the subrecord PSARCHIVE_SBR in the first row of the record definition. The remaining fields in the history record must be defined in the same order as the base record."

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