Skip to main content
Solved

Grant Custom LU table to IFSINFO

  • December 1, 2020
  • 3 replies
  • 404 views

dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)

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!

Best answer by Charith Epitawatta

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!

This topic has been closed for replies.

3 replies

Sandun Madola
Hero (Employee)
Forum|alt.badge.img+13
  • Hero (Employee)
  • April 30, 2021

Hi @dsj,

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

Cheers,
Sandun M.


Charith Epitawatta
Ultimate Hero (Employee)
Forum|alt.badge.img+31

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!


dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Author
  • Ultimate Hero (Partner)
  • May 3, 2021

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