My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.