Friday, October 10, 2014

APP-PAY-06153 per_pdp_bus.chk_actual_termination_date Error in HR

APP-PAY-06153   per_pdp_bus.chk_actual_termination_date


select * from per_all_people_f
where 1=1
and first_name like '%AXXXX%'
and last_name like '%DaAAAAA%'


select *  from per_all_assignments_f
where 1=1
and person_id =XXX
and BUSINESS_GROUP_ID=XX

--create table bolinf.xxta_per_all_assignments_f as (select *  from per_all_assignments_f
where 1=1
and person_id =XXXXX
and BUSINESS_GROUP_ID=81
and ASSIGNMENT_NUMBER='053202')

commit;

--update per_all_assignments_f
set PERIOD_OF_PLACEMENT_DATE_START = to_date('09-JUN-2014','DD-MON-RRRR')
where 1=1
and person_id =XXXX
and BUSINESS_GROUP_ID=XXX
and ASSIGNMENT_NUMBER='XXXX'

commit;

No comments: