My Oracle Support Banner

No Values Found For Parameter Source Ledger Lov For Program GLMRCU (Doc ID 1295591.1)

Last updated on DECEMBER 04, 2020

Applies to:

Oracle General Ledger - Version 12.0.6 and later
Information in this document applies to any platform.

Goal

On entering the report 'Reporting Currency - Create Opening Balance Journals in Reporting Currency'. The parameter Source Ledger
gives the error message appears: No entries found for List of Values. Can you tell us which field in the Accounting Setup Manager equates to the GL_LEDGERS.alc_ledger_type_code column?

All of our records on the GL_LEDGERS table have alc_ledger_type_code column value = 'NONE', but we believe we cannot run the concurrent program GLMRCU because one of its required parameters is looking for a record on the GL_LEDGERS table with column alc_ledger_type_code = 'SOURCE'.

### Steps to Reproduce ###
Responsibility: 'GL superuser'.
GL: Data Access Set profile value for this responsibility is ‘International Statutory Ledger’.
GL Ledger Name profile value for this responsibility is 'Ops Stat Ledger' [GL Ledger ID 1234].
Navigation: Reports => Standard.
Single Request.
Select Report Name = 'Reporting Currency - Create Opening Balance Journals in Reporting Currency'.
On the Parameters form, click the LOV icon for parameter Source Ledger.
The error message appears: No entries found for List of Values.

Note: The Chart of Accounts parameter defaults the correct desired value.


Solution

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
Goal
Solution


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