How to access Global Scope Table from Scoped Application

[Rohit Singh]

I am trying to create a Flow Designer in a Scope Application where the trigger point is Record Inserted or updated in a table which is in a scoped application. Now in the action through script I am creating a record in the Global application but when my Flow is triggered I am getting an error "Create access to (Global table name) not granted". Please suggest how I can get the access to a Global scope from a scoped application.

[Utpal Dutta]

Hi Rohit,

I suggest you go to sys_db_object which is tables table and open your table record. Go under application access section and check if your table has access to Can create from all application scope. If Can Create is no checked then please check it and then try.

Also check accessible from 'All application scope' is selected.

If my answer helps then please mark it correct.

Thanks,

Utpal

[Tai Vu]

Hi @Rohit Singh 

Have you tried to define Cross scope privilege for your scoped app? Like below.

And also make sure the Can create checkbox in the Application Access section from your target table is checked.

 

Cheers,

Tai Vu

[Rohit Singh]

Hello Tai,

Would you please let me know the table name where cross scope privilege record can be created.

[Tai Vu]

Hi @Rohit Singh 

Sure mate there you go!

Table: Cross scope privileges [sys_scope_privilege]

URL: https://<instance_name>/sys_scope_privilege_list.do

Navigation Menu: Application Cross-Scope Access

Cheers,

Tai Vu