Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

PER_SHARE_INFORMATION table not returning any data

Received Response
1
Views
1
Comments
Minal Deshmukh-Oracle
Minal Deshmukh-Oracle Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Forum

I came across the following code in one of the seeded query, but it isn't returning any data when executed. Could anyone help me understand what information is supposed to be stored in this table? Additionally, what settings or configurations need to be in place for the data to be populated in this table?

SELECT 1 FROM PER_SHARE_INFORMATION SI WHERE SI.GRANTEE_PERSON_ID = (SELECT NVL(HRC_SESSION_UTIL.GET_USER_PERSONID,-1) FROM DUAL)

Answers

  • RVohra
    RVohra Mod

    If the user is a normal employee or HR person without special "shared access", then:

    • No rows will exist for them
    • The query returns no data
    • This is expected behavior

    This table usually remains empty unless your organization has turned on Workforce Sharing.

    • The Share Data Access task adds rows to PER_SHARE_INFORMATION, and the Revoke Share Data Access process deletes them.
      • There isn't an audit on the table.
      • Once the data is deleted, it can't be recovered. But you can use the Share Data Access task to manually add it again.
      • The data in the table is used by the person security profile. If configured, your person security profile includes the rows in the table when determining data security for your tasks.