Wednesday 10 June 2015

User Preferences in Oracle E-Business Suite


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 : .,

1 comment:

  1. 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