My Oracle Support Banner

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 JUNE 14, 2018

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.

Changes

 Implemented OAM 11g / OID 11g configuration.

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.