How to get the
values from user the Preferences
Current
Session
Language
SELECT FND_PROFILE.VALUE_SPECIFIC (NAME => 'ICX_LANGUAGE',
USER_ID=>9999) FROM
DUAL;
Output : AMERICAN
Territory
SELECT FND_PROFILE.VALUE_SPECIFIC (NAME =>'ICX_TERRITORY', USER_ID=>9999)
FROM
DUAL;
Output : AMERICA
Date Format
SELECT FND_PROFILE.VALUE_SPECIFIC (NAME =>'ICX_DATE_FORMAT_MASK', USER_ID=>9999)
FROM
DUAL;
Output : DD-MON-RRRR
Number Format
SELECT FND_PROFILE.VALUE_SPECIFIC ('ICX_NUMERIC_CHARACTERS', 9999)
FROM DUAL;
Output : .,
This is such a great resource that you are providing and you give it away for free. I love seeing websites that understand the value of providing a quality resource for free. It is the old what goes around comes around routine. join free to b2bmap.com global suppliers directory
ReplyDelete