Who's Online Now
0 registered members (), 10 guests, and 19 spiders.
Key: Admin, Global Mod, Mod
Newest Members
Ravi Pasapula, kumar1900, B_DOYLE, rdeshab, samba
1296 Registered Users
Recent Posts
Top Posters(30 Days)
Popular Topics(Views)
492,376 PAYE RTI
59,860 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#11588 - 13/07/16 02:18 PM Rename Security Group via Application  
Joined: Jul 2011
Posts: 117
Jay Kavia Offline
nothin' better to do
Jay Kavia  Offline
nothin' better to do

Joined: Jul 2011
Posts: 117
UK
Hi All,

I'm stuck and would appreciate any advice on this.

We have recently renamed one of our business groups, and I want to rename the associated security group to match (maintained in table FND_SECURITY_GROUPS_TL).

Although the Security Group is automatically setup when the Business Group is setup, renaming the Business Group does not rename the Security Group.
Amending the Short Name on the Business Group Info does nothing.
Amending the Security Profile does nothing.
Running Security List maintenance does nothing.

Any advice appreciated.

Thanks, Jay

#11594 - 21/07/16 12:26 PM Re: Rename Security Group via Application [Re: Jay Kavia]  
Joined: Mar 2005
Posts: 1,293
bcooper Offline
bcooper  Offline

*****

Joined: Mar 2005
Posts: 1,293
Earth, Europe, England, here
Hello Jay
The Business Group and Security Group are intrinsically linked (they share the same ID) so not sure there is a supported means to updating the name via forms.

We have multiple languages installed on our site (8 at last count), so each security group has 8 entries in the FND_SECURITY_GROUPS_TL table. Presumably this means we could, if wanted, provide language translations for our security groups. I'd say the only way to achieve this would be via a fairly simply SQL script (awaits the inevitable barrage of abuse from the non-hackers out there smile ).

Regards
Barry


No signature required
#11603 - 26/07/16 11:33 AM Re: Rename Security Group via Application [Re: Jay Kavia]  
Joined: Jul 2011
Posts: 117
Jay Kavia Offline
nothin' better to do
Jay Kavia  Offline
nothin' better to do

Joined: Jul 2011
Posts: 117
UK
Thanks Barry,
I think we'll have to abandon changing the security group name, as although I'd love to do a quick little table update, our change procedures won't allow for it.
Regards, Jay


Moderated by  Administrator, Geoff Dixon 

Forum Statistics
Forums60
Topics2,227
Posts12,029
Members1,296
Most Online283
Dec 25th, 2019
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,116
delboy 1,306
bcooper 1,293
paulgos 439
SBi 427
pat 254
Gus 252
vkumar 223
April
S M T W T F S
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.019s Queries: 15 (0.006s) Memory: 2.7458 MB (Peak: 2.8901 MB) Zlib disabled. Server Time: 2020-04-07 12:40:40 UTC