Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
OTL: ORA-20001: This person does not have preferences for the selected effective date on submitting
*) I got user_id by following query
SELECT USER_ID, USER_NAME, FND_USER.*
from FND_USER where user_name = '205174';
*) resource_id by following query:
select * from APPS.PA_PROJECT_ASSIGNMENTS where RESOURCE_ID in (select RESOURCE_ID from APPS.PA_RESOURCES_DENORM where PERSON_ID
in (select PERSON_ID from APPS.PER_ALL_PEOPLE_F where EMPLOYEE_NUMBER= 205173) ) ;
*) person_id by following query:
select * from APPS.PA_RESOURCES_DENORM where PERSON_ID in (select PERSON_ID from APPS.PER_ALL_PEOPLE_F where EMPLOYEE_NUMBER= 205173) ;
and
Hi,
When I am running following query to submit timesheet, getting following warning msg
SELECT USER_ID, USER_NAME, FND_USER.*
from FND_USER where user_name = '205174';
*) resource_id by following query:
select * from APPS.PA_PROJECT_ASSIGNMENTS where RESOURCE_ID in (select RESOURCE_ID from APPS.PA_RESOURCES_DENORM where PERSON_ID
in (select PERSON_ID from APPS.PER_ALL_PEOPLE_F where EMPLOYEE_NUMBER= 205173) ) ;
*) person_id by following query:
select * from APPS.PA_RESOURCES_DENORM where PERSON_ID in (select PERSON_ID from APPS.PER_ALL_PEOPLE_F where EMPLOYEE_NUMBER= 205173) ;
and
Hi,
When I am running following query to submit timesheet, getting following warning msg
0