| Wrong client_info passes [message #173346] |
Mon, 22 May 2006 00:12  |
patelhemantg
Messages: 25
Registered: May 2006
|
Junior Member |
|
|
Hi friends,
Information
----------------------------------------------------
=>Discoverer desktop edition version: 4.1.37.00.0
=>Oracle Apps version 11.5.5
=>Oracle DB version 8.1.7.4.0
----------------------------------------------------
1) Created a view in DB based on a single SELECT query which uses ........
NVL(ORG.OPERATING_UNIT,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)
......
2) Created a folder in business a area (e.g. BA1) which is having MO: Operating Unit profile option value 42.
3) Created a report based on this folder.
4) Assigned responsibility R1 to BA1 in discoevrer admin edition.
Now,
When USERA logs in discoverer => chooses R1 => result is correct (Here client_info shows 42 when querying v$session).
When USERB logs in discoverer => chooses R1 => result is INCORRECT (Here client_info shows 45 instead of 42 when querying v$session).
Hemant.
|
|
|
|
|
|
| Re: Wrong client_info passes [message #173524 is a reply to message #173346] |
Mon, 22 May 2006 22:05  |
patelhemantg
Messages: 25
Registered: May 2006
|
Junior Member |
|
|
Here is it:
Seect ....
....
FROM fnd_user a,FND_USER_RESP_GROUPS b,FND_RESPONSIBILITY c,FND_RESPONSIBILITY_TL d, FND_PROFILE_OPTION_VALUES PRO, ORG_ORGANIZATION_DEFINITIONS ORG
WHERE a.user_id = b.user_id
AND b.RESPONSIBILITY_ID = c.RESPONSIBILITY_ID
AND b.RESPONSIBILITY_APPLICATION_ID = c.APPLICATION_ID
AND c.RESPONSIBILITY_ID = d.RESPONSIBILITY_ID
AND c.APPLICATION_ID = d.APPLICATION_ID
AND b.end_date IS NULL
AND a.end_date IS NULL
AND PRO.LEVEL_ID =10003
AND PRO.PROFILE_OPTION_ID=1991
AND PRO.LEVEL_VALUE=C.RESPONSIBILITY_ID
AND PRO.PROFILE_OPTION_VALUE=ORG.operating_unit
AND ORG.OPERATING_UNIT=ORG.ORGANIZATION_ID
AND NVL(ORG.operating_unit,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)
....
....
Hemant.
|
|
|
|
|
|
| Re: Wrong client_info passes [message #173963 is a reply to message #173783] |
Thu, 25 May 2006 07:09 |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
Hi Hermant,
I won't be able to try the query before monday. It's a bank holiday where I live, so no access to any apps instance till monday...
But just from the look at it, I would expect something wrong in the configuration of apps. Because Discoverer isn't actually doing anything besides showing the results of the query.
Could you please check the configuration (like users, organizations, etc.)? If you can't find it, I'll have a look on monday!
Regards,
Sabine
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
