Unable to grant access to Custom Page in Aurena

Mike, 

We’re you able to find out what the problem is? I am having the same issue. 
 

Appreciate if you could share your fix for this if you have one already. 
 

Thanks, 

A

Hi Ayaan,

After some investigation I found that when I defined my custom page against my custom projection the view FND_PROJECTION_USAGE was not populated.  This view appears to link your custom page to the projection.  The workaround manually adds that missing record to the view.  Please note, I have only deployed this to a test environment and it is not an official fix but it does work!  In the meantime I have raised a case with IFS.

Workaround for Granting Access to a Custom Page in Aurena (Apps10 UPD9)

To add missing information to FND_PROJECTION_USAGE run the script below as IFSAPP (note you need to change the attribute values according to your own circumstances)

DECLARE

   info_ VARCHAR2(4000);
   attr_ VARCHAR2(4000);
   objid_ fnd_projection_usage.objid%TYPE;
   objversion_ fnd_projection_usage.objversion%TYPE;
   
BEGIN
   
   Client_SYS.Clear_Attr(attr_);
   Client_SYS.Add_To_Attr('PROJECTION_NAME', 'TestProjection', attr_);
   Client_SYS.Add_To_Attr('CLIENT', 'TestLu', attr_);
   Client_SYS.Add_To_Attr('ARTIFACT_NAME', 'TestLuPage', attr_);
   Client_SYS.Add_To_Attr('ARTIFACT', 'page', attr_);
   Client_SYS.Add_To_Attr('ARTIFACT_LABEL', 'Test Lu', attr_);
   
   Fnd_Projection_Usage_API.New__(info_, objid_, objversion_, attr_, 'DO');
   
END;

Where the attribute values are derived from:

ARTIFACT attribute value is hard coded to “page”.

Once script has been run system now reports that my Custom Projection has a related page when granting access to a permission set.

I can now manage my grant using the Manage by Page function:

To make available to an end-user I then use the Navigator Designer to add a navigator option for my new page:

Finally, I need to grant access to that navigator option to my permission set:

Once permission set has been granted, end-user should now see new navigator option and custom page.

Hope this helps.  I'll update further when I get an official fix from IFS.

Regards,