EGL9.2: 'Mark Journals For Unposting' Page When Searching For Adjustment Periods Results to 'SQL Exec: 3 select list items in parameter list, but SQL has 1 select columns. (2,124)'
(Doc ID 2826531.1)
Last updated on DECEMBER 06, 2021
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
SQLExec error is encountered in Mark Journal for Unposting page when searching for Adjustment Periods and when Journal Dates From/To are blank.
Steps to replicate:
1. Navigate to General Ledger > Journals > Process Journals > Mark Journals for Unposting.
Values get defaulted for BU, Ledger group, Year, Period and Journal dates.
Mark Journals for Unposting page:
Unit = i.e 11000
Ledger Group = i.e. ACTUALS
Year = i.e. 2021
Period = i.e. 7
Journal Date From = i.e. 07/01/2021
Journal Date To = i.e. 07/31/2021
2. Click on 'Adjustment Periods' checkbox.
3. Choose a period from period lookup.
Note that the journal dates get blanked out.
4. Click on 'Search' and error comes up.
See replication below.
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