My Oracle Support Banner

EGL9.2: Chartfield Configuration Process Does Not Update The Record Field Property Key Order. (Doc ID 1930646.1)

Last updated on MARCH 02, 2018

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On :  9.2 version, ChartField Configuration

CF Configuration process does not update the record field property  

Background- Upgrading the PeopleSoft FSCM application from v9.1/v8.52 to v9.2/v8.53 (PI-6).

Activated CHARTFIELD1 .
Charfield Configuration Process goes to success.
Process marks the activated CHARTFIELD1 as “Key” in Chartfield record but does not update the Key Order.
Above is also confirmed by querying CHARTFIELD1 related rows in PSKEYDEFN and KEYPOSN.

As such index alter/creation script generated for chartfield record does not contain activated chartfield as index column

EXPECT OUTCOME
----------------------------------
CHARTFIELD1 is marked as key fields and with key order.
It is also added to the index for all concerned tables/records.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Activate CHARTFIELD1 .
2. Run chartfield configuration process
3. Process runs to success.
    However, charfield1 is marked as “Key” in Chartfield record but is not updated with key order.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, index alter/creation script generated for chartfield record does not contain activated chartfield as index column, which will leads to unique constraint error later on at various page/process.

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
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.