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:

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

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