You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Date From mismatch on CMP_SALARY_SIMPLE_COMPNTS and CMP_ASG_SALARY_SIMPLE_CMPTS_V

in Compensation 1 comment

Summary:

We have a report that populates simple component amounts for our employees, and recently I noticed a data anomaly where the join did not pull forward amounts for someone. After some investigating, I realized that there was a date mismatch between two of the referenced tables: CMP_SALARY_SIMPLE_COMPNTS and CMP_ASG_SALARY_SIMPLE_CMPTS_V.

The CMP_ASG_SALARY_SIMPLE_CMPTS_V view showed the correct Date From for the salary row as seen on the Salary History page in the UI. The Date From row in the CMP_SALARY_SIMPLE_COMPNTS table did not match. This is keeping Salary_ID and Assignment_ID constant. I ran another query and found the inconstancy for 8 unique persons.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!