Grant Custom LU table to IFSINFO | IFS Community
Solved

Grant Custom LU table to IFSINFO

  • 1 December 2020
  • 3 replies
  • 218 views

Userlevel 7
Badge +15
  • Superhero (Partner)
  • 355 replies

Hi All,

 

When creating a custom Logical unit in Apps9, _CLT table does not getting grantable privilege for IFSINFO, but in Apps10 it does. Is this fixed by a single patch or UPD in Apps9?

Glad if someone can mention patch/UPD if it’s fixed.

We are in Apps9 UPD9

 

Cheers!

icon

Best answer by Charith Epitawatta 30 April 2021, 11:53

View original

This topic has been closed for comments

3 replies

Userlevel 6
Badge +13

Hi @dsj,

You can try this patch - 122692 (Custom Objects Grants for IAL Owner)

Cheers,
Sandun M.

Userlevel 7
Badge +17

Hi @Sandun Madola,

122692 is for IFSAPP9 UPD1, so that might not be what @dsj is looking for as he has mentioned their environment is on IFSAPP9 UPD9. 

There is a more recent patch for IFSAPP10 UPD 5 - patch ID 148158

Alternatively, Custom Field and Custom LU tables are granted to IAL Owner after a delivery via following method:

Database_SYS.Grant_All_Objects_Ial

So as a workaround, you might be able to trigger this method manually until the patch is merged to the environment. 

Hope this helps!

Userlevel 7
Badge +15

Hi @Sandun Madola,

122692 is for IFSAPP9 UPD1, so that might not be what @dsj is looking for as he has mentioned their environment is on IFSAPP9 UPD9. 

There is a more recent patch for IFSAPP10 UPD 5 - patch ID 148158

Alternatively, Custom Field and Custom LU tables are granted to IAL Owner after a delivery via following method:

Database_SYS.Grant_All_Objects_Ial

So as a workaround, you might be able to trigger this method manually until the patch is merged to the environment. 

Hope this helps!

Thanks Charith,

seems patch ID 148158 is not corrected on Apps9 track. However Database_SYS.Grant_All_Objects_Ial is a good workaround to solve the problem :)

 

Cheers!

Damith