Invalid Application Username, Password Or Database "Username:APPLSYSPUB"
(Doc ID 371602.1)
Last updated on JANUARY 03, 2023
Applies to:
Oracle E-Business Suite Technology Stack - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]Information in this document applies to any platform.
Symptoms
If territory is changed for a user through self service preferences to any of the following territories listed below then forms cannot be launched through self service page but the same user can access forms directly through http://host.domain:port/dev60cgi/f60cgi.
TERRITORIES:
ARGENTINA
AZERBAIJAN
CHILE
COLOMBIA
COSTA RICA
ECUADOR
EL SALVADOR
FYR MACEDONIA
GUATEMALA
INDIA
NICARAGUA
PANAMA
PERU
PHILIPPINES
PUERTO RICO
RUSSIA
SERBIA AND MONTENEGRO
VENEZUELA
ERROR:
Invalid application username, password or database.
Username:APPLSYSPUB
Database:XXXXXXX
STEPS:
The issue can be reproduced at will with the following steps:
1. Login to Applications through self service.
2. Choose a forms responsibility for user.
Following are the few territories supported. (From Metalink Document: 17210.1 Supported NLS character sets, referring the same here for better clarity)
Character Sets
ID Name Description
--- ------------------- -------------------------------------------
1 US7ASCII ASCII 7-bit American
2 WE8DEC DEC 8-bit West European
3 WE8HP HP LaserJet 8-bit West European
4 US8PC437 IBM-PC Code Page 437 8-bit American
5 WE8EBCDIC37 EBCDIC Code Page 37 8-bit West European
6 WE8EBCDIC500 EBCDIC Code Page 500 8-bit West European
10 WE8PC850 IBM-PC Code Page 850 8-bit West European
11 D7DEC DEC VT100 7-bit German
12 F7DEC DEC VT100 7-bit French
13 S7DEC DEC VT100 7-bit Swedish
14 E7DEC DEC VT100 7-bit Spanish
15 SF7ASCII ASCII 7-bit Finnish
16 NDK7DEC DEC VT100 7-bit Norwegian/Danish
17 I7DEC DEC VT100 7-bit Italian
18 NL7DEC DEC VT100 7-bit Dutch
19 CH7DEC DEC VT100 7-bit Swiss (German & French)
21 SF7DEC DEC VT100 7-bit Finnish
22 TR7DEC DEC VT100 7-bit Turkish
31 WE8ISO8859P1 ISO 8859-1 West European
32 EE8ISO8859P2 ISO 8859-2 East European
33 SE8ISO8859P3 ISO 8859-3 South European
34 NEE8ISO8859P4 ISO 8859-4 North and North-east European
35 CL8ISO8859P5 ISO 8859-5 Latin/Cyrillic
36 AR8ISO8859P6 ISO 8859-6 Latin / Arabic
37 EL8ISO8859P7 ISO 8859-7 Latin / Greek
38 IW8ISO8859P8 ISO 8859-8 Latin / Hebrew
39 WE8ISO8859P9 ISO 8859-9 West European & Turkish
40 NE8ISO8859P10 ISO 8859-10 North European
41 TH8TISASCII Thai Industrial Standard 620-2533 - ASCII 8-bit
42 TH8TISEBCDIC Thai Industrial Standard 620-2533 - EBCDIC 8-bit
61 AR8ASMO708PLUS ASMO 708 PLUS, 8 -bit Latin / Arabic
62 AR7ASMO449PLUS ASMO-449-Plus 7-Bit Latin / Arabic
70 AR8EBCDICX EBCDIC Storage Character Set for XBASIC
81 EL8DEC DEC 8-bit Latin / Greek
82 TR8DEC DEC 8-bit Turkish
90 WE8EBCDIC37C EBCDIC Code Page 37 8-bit 370/c
91 WE8EBCDIC500C EBCDIC Code Page 500 8-bit oracle/c
155 RU8PC855 IBM-PC Code Page 855 8-bit Latin / Cyrillic
180 D8EBCDIC273 EBCDIC Code Page 273/1 8-bit Austrian / German
181 I8EBCDIC280 EBCDIC Code Page 280/1 8-bit Italian
182 DK8EBCDIC277 EBCDIC Code Page 277/1 8-bit Danish
183 S8EBCDIC278 EBCDIC Code Page 278/1 8-bit Swedish
351 WE8MACROMAN8 Mac Extended ROMAN 8 8-bit West European
352 WE8MACROMAN8S Mac Extended ROMAN 8 Server 8-bit West Europe
370 TR8ISO8859P9 Turkish version ISO 8859-9 West European & Turkey
500 AR8ASMO8X Extended ASMO 708, 8-bit Latin /Arabic
829 JA16VMS JVMS 16-bit Japanese
830 JA16EUC EUC 16-bit Japanese
832 JA16SJIS Shift-JIS 16-bit Japanese
833 JA16DBCS IBM DBCS Code Page 1027 16-bit Japanese
835 JA16EBCDIC930 IBM DBCS Code Page 290 16-bit Japanese
840 KO16KSC5601 KSC5601 16-bit Korean
842 KO16DBCS IBM DBCS 16-bit Korean
850 ZHS16CGB231280 CGB2312-80 16-bit Simplified Chinese
860 ZHT32CNS1164386 EUC 32-bit Traditional Chinese
861 ZHT32SOPS SOPS 32-bit Traditional Chinese
862 ZHT16DBT Taiwan Taxation 16-bit Traditional Chinese
863 ZHT32TRIS TRIS 32-bit Traditional Chinese
865 ZHT16BIG5 BIG5 16-bit Traditional Chinese
997 JA16TSTSET2 ASCII-based 16 Bit Test Character Set
998 JA16TSTSET Shift-sensitive ASCII-based Test Character Set
Languages
Name Character set texts Default character set
American US7ASCII US7ASCII
Arabic AR8ISO8859P6 AR8ISO8859P6
Brazilian Portuguese WE8DEC WE8DEC
Canadian French WE8DEC WE8DEC
Czech EE8ISO8859P2 EE8ISO8859P2
Danish WE8DEC WE8DEC
Dutch WE8DEC WE8DEC
Finnish WE8DEC WE8DEC
French WE8DEC WE8DEC
German WE8DEC WE8DEC
Greek EL8DEC EL8ISO8859P7
Hungarian EE8ISO8859P2 EE8ISO8859P2
Icelandic WE8ISO8859P1 WE8ISO8859P1
Italian WE8DEC WE8DEC
Japanese JA16EUC JA16EUC
Korean KO16KSC5601 KO16KSC5601
Lithuanian NEE8ISO8859P4 NEE8ISO8859P4
Mexican Spanish WE8DEC WE8DEC
Norwegian WE8DEC WE8DEC
Polish EE8ISO8859P2 EE8ISO8859P2
Portuguese WE8DEC WE8DEC
Russian RU8PC855 RU8PC855
Simplified Chinese ZHS16CGB231280 ZHS16CGB231280
Slovak EE8ISO8859P2 EE8ISO8859P2
Spanish WE8DEC WE8DEC
Swedish WE8DEC WE8DEC
Thai TH8TISASCII TH8TISASCII
Traditional Chinese ZHT32EUC ZHT32EUC
Turkish WE8ISO8859P9 WE8ISO8859P9
Territories
Name Character set texts
America US7ASCII
Austria WE8ISO8859P1
Brazil WE8DEC
Canada WE8DEC
China ZHS16CGB231280
CIS RU8PC855
Czechoslovakia EE8ISO8859P2
Denmark WE8DEC
Finland WE8DEC
France WE8DEC
Germany WE8DEC
United Kingdom WE8DEC
Greece EL8ISO8859P7
Hong Kong ZHT32EUC
Hungary EE8ISO8859P2
Iceland WE8ISO8859P1
Italy WE8DEC
Japan JA16EUC
Korea KO16KSC5601
Lithuania NEE8ISO8859P4
Mexico WE8DEC
Norway WE8DEC
Poland EE8ISO8859P2
Portugal WE8DEC
Spain WE8DEC
Sweden WE8DEC
Switzerland WE8ISO8859P1
Taiwan ZHT32EUC
Thailand TH8TISASCII
The Netherlands WE8DEC
Turkey WE8ISO8859P9
United Arab Emirates AR8ISO8859P6
In the above lists, 'character set texts' indicates the character set that in which items are specified for that language. Such text items include dates, names,month names etc. The 'Default character set' indicates the character set if you do not specify a character set in NLS_LANG.
E.g. If NLS_LANG="Japanese", then the character set defaults to 'JA16EUC'.
Changes
No change.
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |