My Oracle Support Banner

EGL9.2: After Advanced Chartfield Configuration Or Chartfeild Configuration By Project Process While Building AQS_OU_%_VW Views Getting "ORA-01730: invalid number of column names specified" Error (Doc ID 2664325.1)

Last updated on APRIL 30, 2020

Applies to:

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

Symptoms

Advanced Chartfield Configuration or Chartfield Configuration by Project process Changes View structure to include newly added chartfield  but corresponding View SQL not changed to reflect changes for below delivered Advanced query security views for Operatung Unit Chartfield:

AQS_OU_P_VW
AQS_OU_R_VW
AQS_OU_U_VW

Upon Building views in FS_CF_CREATE_VIEWS project as part of manual steps post configuration, getting error for above mentioned 3 views:



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

1. Add any custom chartfield(s) using advanced chartfield configuration
2. Run process to complete auto configuration.
3. After process completes open the above 3 views in application designer & check if newly added chartfield in step 1 has been included in both Record Fields tab & also in the View SQL. Build the above mentioned views.

Please see replication screenshots for more details.

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.