Get Started with Redwood for Oracle Cloud HCM Begin Now
Wrong Values On CMP_ASG_SALARY_V
Summary:
our Requirement is to fetch compensation zone data from Compensation Screen.
I followed below steps
Step1)
Compensation value exists in Compensation Screen
Navigation for Compensation Screen
- Login to HCM Application and Search for person number
- Click on Show More (Left Side)
- Click on Compensation tab
- Compensation Screen will be displayed
Step2)
ZONE_NAME is displaying null from below SQL Query
select PERSON_ID,ASSIGNMENT_ID,ZONE_NAME,ZONE_TYPE_NAME,ZONE_ID,ZONE_TYPE_ID
from CMP_ASG_SALARY_V
where person_id in ( select person_id from per_all_people_f papf where person_number ='995029')
Step3)
0