...
written by Swamy , January 25, 2007

hello Anil

can you please tell me how to :
schedule a daily process to automate end dating of user responsibilities where a user hasnt accessed Adelphi(our production environment) for at least 6 months.

thank you

...
written by Anil Passi , January 27, 2007

Hi firstly check if fnd_logins retains the login details for over6months.

Alternately, attach a workflow event subscription to the event which is raised when user login takes place. next, write a concurrent program that compares the records in fnd_user with those in fnd_logins/your temp table, and end date responsibility assignment

let me know if you want SQL for end dating responsibility assignment

thanks
anil

...
written by Hari , February 23, 2007

Hi Anil
Which table stores the details of present and previous employment details including employer name.
Thanks
Hari

...
written by Anil Passi , February 24, 2007

Hi Hari

The table name if PER_PREVIOUS_EMPLOYERS

If you wish to migrate data into this table, then use API Hr_previous_employment_api

Thanks
Anil

...
written by Anil Passi , February 26, 2007

Hi Chunnu

Please have a look at the link provided in article http://oracle.anilpassi.com/or...-demo.html

There is a dedicated section for HRMS/iRecruitment

Thanks
Anil

...
written by chunnu , February 26, 2007

hi anil,

this is chunnu i am new to oracle HRMS. to start with HRMS payroll what is step by step procedure to get in it?
can u help me with some documntations or tutorials it will be of great help
tahnk you

...
written by uma , March 07, 2007

hi Anil,

I AM UNABLE TO REAPPLY FOR A VACANCY WHICH HAS BEEN WITHDRAWN IN IRECRUITMENT.Can u help me?

regards
uma

...
written by uma , March 15, 2007

hi Anil,

Tanx for ur response.i ll do the same.Can u say the steps,profile options for OTL ?

tanx in advance

regards
Uma

...
written by monalisa , March 29, 2007

Hi Anil, the article syou have provided is amazing. Specially th e article on XML publisher.You could make the subject so easy and interesting. Thanks on behalf of all my friends amd me.It is very helpful. I needed some article on payroll data migration from legacy to Oracle Apps.Could you please post some article as interesting as the XML publisher? I know nothing about Payroll.How do I start? Please suggest. Thank you so much again for creating this site.It has been very helpful to me and so many people I know. -Mona

...
written by Anil Passi , March 31, 2007

hi mona
Thanks for your compliments. I am unable to write on that subject in near term[unit june07]. However if you get stuck with any of your payroll migration tasks, then feel free to ask

Thanks,
Anil

...
written by Dd , April 11, 2007

Hi Anil
How are you. I am good and I am in Bangalore. Just today only I came to know about your website. Its looking very interesting..I need to go thru again. One thing I didnt find in the Training menu about the modules about MFG and Distribution. If you have any good materials can you please add.


Thank you very much.
dd

...
written by Venkata Naga Kumar , May 22, 2007

Hi Anil,

Its nice to intaract with you. I have seen many articles of urs. And I impressed with them.

I an very new for Oracle Apps HRMS Functional. Can u plz help me with Implementation steps for HR & Payroll?

Thanks & Regards
Venkat

...
written by yogita sarang , August 07, 2007

hi Anil,
Can you please share some documents or important information for payroll interface or payroll related API'S. This would Be a great help.

regards,
yogita

...
written by yogita1 , August 07, 2007

hi Anil,
can u Please share some documents or program on Payroll Interface or Payroll API's.
it Would be a great help.

regards,
yogita

...
written by Sunit Kumar , September 18, 2007

Hi Anil,

First congratulations on this wonderful site. My question is not related to HRMS, its with SQLLDR, i have control character i.e. RETURN KEY, in the column of the staging table while loading data in the staging table from a .CSV file. It happens only on the last column.

Thanks.

With Regards

Payroll Query
written by Nimish , October 02, 2007

Hi Anil,
Thanks for your work on this site, it helps me and others very much.

My background is mainly on core HR, and now I need to write something which will get
the pro-rated salary for every employee(number) with an active assignment record.

Can you please point me to tables I need to refer.

Thanks,
Nimish

HRMS Functional
written by Anshul , October 03, 2007

Hi Anil,

This is the first time i am writing here. I need some functional documentation on Oracle HRMS and Payroll. I would be grateful if you could provide me the same.

Regards,
Anshul singhal

...
written by khurshid , November 17, 2007

Hi Anil,
I saw ur website only 2 days back,it was referred by my friend.Iam new to HRMS,i have to do a project which is conversion of employees and buyers.
i have done comversion in OM ,i know the basic step is to create a staging table ,then pass the validated values to interface table and finally run a concurrent program called order import.
But ,in hrms ,I neither find any interface table regarding per_all_people_f or i dont find any concurrent program to run. can u please explain me how to do the conversion of employees and buyers. it will be really helpfull.u r my last hope.
thanks
khurshid

...
written by arunp , November 20, 2007

Tried creating new site,it gave the following error.
You must supply a City. Please enter a value for City and resubmit your request.

City was supplied. Verified everything was correct.

please help

oracle hrms
written by bapuji , November 29, 2007

hi anil, its amazing to see such type of activities by you of giving suggetions regarding oracle for the seekers. i am an mba 3rd semester student opted to hr specialisation. i am very much interested in oracle hrms. can i have basic concepts of it. as i am new to this oracle hrms.

Sequencing the training articles
written by Prasad478 , January 08, 2008

Hi Anil,

Great stuff!!
I think it would be helpful if you could categorize your articles in sequencial fashion to help a new learner to go through the training in an orderly and incremental fashion.

Regards,
Prasad

Gud Work
written by Nikku , January 17, 2008

Gr8 job,

keep this gud wok going

Anil:Need ur help :Oracle HRMS
written by G.Balaji , January 22, 2008

Hi Anil ,

I'm avid reader of ur blog.Let me tell abt my profile .I have 5 yrs Domain experience in HR -Recruitment and currently purusing Oracle HRMS @ Oracle university and in a week time my classes are getting over .I want to practice my Oracle HRMS training ,my trainer said abt Solution beacon ,how good tht site for practicing and how i shld approach companies on which roles Support/Consultant which one has good career growth.

I appreciate if u could give me valid views it will help me in ur career start in Oracle HRMS

Mail me to hrmsbalaji@aol.in ur queries

Cheers

Balaji

US Payroll Guide
written by Rajesh Panchal , February 12, 2008

Can you Please help to provide US payroll Implementation Guide.Mail me at panchalrajesh16@gmail.com