EHR: Changes to Job Component Is Making The Employee Data Available To All Security Access Types (Doc ID 2674698.1)

Last updated on JANUARY 26, 2024

Applies to:

Symptoms

Four different access types are created to ensure Security of Employee Information between companies. After creating a new Security Access type, it was that when we make any job data update such was adding a new effective dated row to Job Data, the specific employee data becomes accessible to all security access types.

 Select Employee for Testing purposes

1. Create a new Security Access Type 111
2. Modify the SQL of the where clause to exclude (not Include) specific data
3. In the test we chose to exclude employee with a JOB.JOBCODE NOT IN (XXX)
4. Run a SQL query against the PS_SJT_PERSON table for the employee used in the test, note the initial results of the query show that the person has 2 SCRTY_TYPE_CD

5. Insert an effective dated row in Job Data for the employee used in testing

6. After the row insert Run a SQL query Against the PS_SJT_PERSON table note the results, now this employee has 3 SCRTY_TYPE_CD, it added the new one even this employee is not supposed to have access to employees in that access type.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.