Security Join for Table WKF_CNT_CLAUSE Results in Duplicate Rows Due to Incomplete Security Join

(Doc ID 2081133.1)

Last updated on NOVEMBER 24, 2015

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Security Join For Table WKF_CNT_CLAUSE Results In Duplicate Rows Due To Incomplete Security Join

STEPS

The issue can be reproduced at will with the following steps:

1.Workforce Admin > Job Info > Contract Administration > Update Contracts:
- employee x is active, has 1 contract and a contract clause
2. Reporting Tools > Query > Query Manager
- Create a simple query showing the contract clauses and run it
-> correct result
3. Main Menu > Workforce Admin > Job Info > Add Employment Instance
- Add an additional employment instance for the employee (no new contract number)
4. Reporting Tools > Query > Query Manager
- Run the contract clause query again
=>Result is showing the same row twice



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms