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