E-Business Suite :- Single User Multiple Login Sessions Shows Discrepancy In "ICX_SSESSIONS" Table's "NLS_NUMERIC_CHARACTERS" Column Value (Doc ID 2411097.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Applications Framework - Version 11.5.10.2 to 12.2.7 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Symptoms

On E-Business Suite 12.1.3 version =>

ACTUAL BEHAVIOR
---------------
NLS_NUMERIC_CHARACTERS is changing for few sessions from ., to ,. for some users

Prior to that , it was always ".," for all sessions.

Sessions at different timings are shown as below with different NLS_NUMERIC_CHARACTERS.

EXPECTED BEHAVIOR
-----------------------
Would have expected to have same format ".," for all connections.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Query APPS.ICX_SESSIONS table data where user_id = 230368590 (Issue user)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot maintain setting for NLS_NUMERIC_CHARACTERS and form transactions are failing since correct data doesn't get saved.