My Oracle Support Banner

GPCORE: PAYMENT_STATUS Field Has 'Canceled' instead of 'Cancelled' in XLAT Table (XLATLONGNAME and XLATSHORTNAME) (Doc ID 2815568.1)

Last updated on OCTOBER 20, 2021

Applies to:

PeopleSoft Enterprise HCM Global Payroll Core - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

After analysis of the xlat long and short names of the GP Core Fields containing the 'Cancel' word it has been determined that only PAYMENT_STATUS has misspelled value in the tables XLATLONGNAME and XLATSHORTNAME.

The rest of the fields have 'Cancelled' in the XLAT Tables.

Steps to replicate the issue:

1. Run the following SQL Query

SELECT FIELDNAME, FIELDVALUE, XLATLONGNAME, XLATSHORTNAME FROM PSXLATITEM
where  FIELDNAME IN (select psdbfield.FIELDNAME from psdbfield where
OBJECTOWNERID = 'HG')
AND (XLATLONGNAME like '%Cancel%' OR XLATSHORTNAME LIKE '%Cancel%');

Observe: PAYMENT_STATUS has 'Canceled' translation

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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