Payroll and OTL - EBS (MOSC)

MOSC Banner

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

edited Nov 5, 2012 5:19PM in Payroll and OTL - EBS (MOSC) 5 commentsAnswered
*) 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center