ora-20001: HR_289609_PDP_NOT_EXIST

While Terminating CWK we might encounter the error: ora-20001: HR_289609_PDP_NOT_EXIST

Used the following query to find out the message :

select message_text from fnd_new_messages
where message_name = ‘HR_289609_PDP_NOT_EXISTS’;

Use the following query to get the Date_start that needs to be passed to P_DATE_START

select PPS.OBJECT_VERSION_NUMBER, PAPF.PERSON_ID,PPS.DATE_START
INTO l_num_ovn, l_num_person_id, l_dat_date_start
FROM per_all_people_f papf,
PER_PERIODS_OF_PLACEMENT_V pps
WHERE papf.person_id = pps.person_id
and PAPF.BUSINESS_GROUP_ID = FND_PROFILE.value(‘PER_BUSINESS_GROUP_ID’)
AND papf.employee_number= C_CWK_TERM.EMPLOYEE_NUMBER
and papf.current_npw_flag = ‘Y’
AND sysdate BETWEEN papf.effective_start_date AND papf.effective_end_date;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s