USERENV('CLIENT_INFO') getting strange values
504757Dec 7 2007 — edited Dec 7 2007We are using Oracle seeded view HZ_CUST_ACCT_SITES in our custom page to fetch some customer related information. It got the following WHERE clause
NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99);
USERENV('CLIENT_INFO') expects the value of ORG_ID.
When we do the transactions first few times, it is getting the correct ORG_ID value in the CLIENT_INFO. But after few transactions, it is suddenly getting the following value,
"Connect: Please kill this session (trys = 8)"
Then it starts throwing "ORA-01722: invalid number" exception.
Do you have any idea what program or job in database or Oracle Apps set this value?
Or how to debug to find which program actually sets this value?
Thanks a million in advance.
Regards
Sreeram.H