Need help with fetching the data for Salary Components — Cloud Customer Connect
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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Need help with fetching the data for Salary Components

We came across a very weird issue with the Salary Component data stored in the table: CMP_SALARY_PAY_COMPONENTS. where the data is not matching with what we see online.

Below is the Hosing Allowance data that we see online which is Zero.

But the data in backend table is showing, 3000

I ran the below query for your reference:

Select B.NAME,SALARY_DATE_FROM, SALARY_DATE_TO, RATE_AMOUNT from CMP_SALARY_PAY_COMPONENTS A, PAY_RATE_DEFINITIONS_F_VL B
where Assignment_ID = 300000030288782
AND PAY_RATE_DEFINITION_ID = 300000019161534
AND A.PAY_RATE_DEFINITION_ID = B.RATE_DEFINITION_ID

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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