My Oracle Support Banner

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

Last updated on JUNE 20, 2019

Applies to:

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


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

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

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.




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

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