Tuesday 1 March 2016

REP-0788: Warning: The value of restricted LOV parameter P_1 is not among the selectable values. - Oracle EBS R12

http://generalledger-gl.blogspot.com/2016/03/rep-0788-warning-value-of-restricted.html

REP-0788: Warning: The value of restricted LOV parameter P_1 is not among the selectable values.

+---------------------------------------------------------------------------+
General Ledger: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

GLTRANS_PRL: Ledger Transactions (Replica For Testing)
+---------------------------------------------------------------------------+

Current system time is 02-MAR-2016 10:18:15

+---------------------------------------------------------------------------+


+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
p_ledger_name='2021'
p_from_date='2016/02/01 00:00:00'
p_to_date='2016/02/29 00:00:00'
P_COA_ID='50308'
P_1='AED'
P_2='AED'
P_FROM_ACCOUNT='101111601'
P_TO_ACCOUNT='101112001'
P_GROUP_BY='A'
P_USER_NAME='ADM'
P_LEDGER_ID='2021'
P_ORG_ID='82'
------------

 APPLLCSP Environment Variable set to :

 Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8

'.,'

Enter Password: 
REP-0004: Warning: Unable to open user preference file.
REP-0788: Warning: The value of restricted LOV parameter P_1 is not among the selectable values.

Report Builder: Release 10.1.2.3.0 - Production on Wed Mar 2 10:18:16 2016

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Program exited with status 1
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 1515540.

Review your concurrent request log and/or report output file for more detailed information.


+---------------------------------------------------------------------------+
No completion options were requested.

Output file size: 
0

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 02-MAR-2016 10:18:17

+---------------------------------------------------------------------------+


Solution


Open the Report in Report builder.

Navigate to user Parameter P_1

Add the Value or Uncheck Restrict List to Predetermined Values