My Oracle Support Banner

EGL9.2: While Build Views In FS_CF_CREATE_VIEW Project Getting "ORA-01789: query block has incorrect number of result columns" Error For EM_VCHR_MISC_VW Record (Doc ID 2660383.1)

Last updated on APRIL 16, 2021

Applies to:

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


Chartfield configuration by project process was run & after process ends performing manual steps as listed in CFX0001 report to create views in the Project FS_CF_CREATE_VIEW is carried out.

Getting below error for EM_VCHR_MISC_VW view:

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

1. Add at least 1 custom chartfield using advanced chartfield configuration on any any environment on 9.2 PI 28 or below
2. In a PUM environment with PI 29 or above, Create a change package with make me current option or create a change package that includes Bug 28131917 for the environment referenced in step 1.
3. Apply change package created in step 2.
4. While encounter CA step 'Review Chartfield configuration' , Run Chartfield Configuration by Project process for the project created by change package.
5. After Chartfield Configuration by Project process completes. Open project FS_CF_CREATE_VIEW & build the views,
6. Check Build Log




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.