Skip to main content

I’m grappling with finding Projection/Entity/Permission set combination for this ‘Close Shop Order’ function and wondering if I’m missing a trick.  

 

Projections appear to be ShopOrderHandling and ShopOrdersHandling and ShopOrderMaterialsHandling.

 

Query for Permission set/Projection combination in Projection Grants/Entity Action Grants...

 

Select and Revoke...

 

I’ve been round this a few times now but haven’t nailed removing the permission so think it must be granted somewhere deep or elsewhere or I’m missing something obvious.  

Is there any way/query/trick of identifying the Permission set that has Granted=Yes on Entity=ShopOrd Action=Close?

 

Any suggestions gratefully received!

 

Linda

 

Hi Linda,

Please create a quick report using SQL statement below.

SELECT T.*, FND_PROJ_ENT_ACTION_GRANT_API.GET_PROJ_ENT_ACT_GRANT_STATUS(T.PROJECTION,T.ENTITY,T.ACTION,T.ROLE) GRANTED
FROM PERM_SET_ENT_CUD_ACTIONS T
WHERE PROJECTION = 'SHOPORDERHANDLING'
AND ENTITY = 'SHOPORD'
AND ACTION = 'CLOSE'
AND FND_PROJ_ENT_ACTION_GRANT_API.GET_PROJ_ENT_ACT_GRANT_STATUS(T.PROJECTION,T.ENTITY,T.ACTION,T.ROLE) = 'TRUE'

Hope this helps.

 

Regards

Abdul Rehman

Hi ​@PRODQ

In situation like this I set Read Only state for projection and check error messages appered on specific activity.

Thanks, ​@Abdul Rehman.  Your query was most helpful (did need lower case though)

 

 WHERE PROJECTION = 'ShopOrderHandling'
   AND ENTITY = 'ShopOrd'
   AND ACTION = 'Close'

 

 

It helped identify other Projections the permission was granted in that I hadn’t even considered.  

Thanks again.

Linda

#ThisCommunityRocks

 

 

Thanks, ​@knepiosko - another thing I’d not thought of :-)

 

Linda

 

Reply


Terms & ConditionsCookie settings