My Oracle Support Banner

EGL9.2: Advanced Chartfield Configuration Or Chartfeild Configuration By Project Process Leads to Data Swapping Issue for Views that Use Delivered Standard SQL Definitions (e.g. DEPR_AD_PD_VW) (Doc ID 2664337.1)

Last updated on APRIL 16, 2021

Applies to:

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


Advanced Chartfield Configuration or Chartfield Configuration by Project process leads to data swapping issue for views that use delivered Standard SQL definitions.

This is an issue when multiple custom chartfields have been added. The sequence of the chrtafileds in the Record Fields tabs of a view are not same as that of the sequence of the chrtafileds the view SQL definition after the meta SQL is resolved

The issue can be reproduced at will with the following steps:

1. Add at least 4 custom chartfield using advanced chartfield configuration.
2. Run full chartfield configuration process
3. After process completes open any view that has references to any of the below standard delivered SQL definitions in application designer e.g. DEPR_AD_PD_VW
4. Compare the sequence of added custom chartfields in Record fields tab of the view & the sequence after the meta SQL in the view SQL is resolved.

Please see replication screenshots for more details.




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.