Apps To Fusion

...
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 hasn’t 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 \n This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it 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 \n This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it

...
written by Venu , May 09, 2008

I find your site very informative. I have some issue with payroll flsa hours.
The Overtime 1.5 is not calculating the correct amount . currently it calcualtes like regular salary /regular hours = rate * 1.5
but we ned this to be regular wages/(regular hours + over time hours) = rate * 1.5
like 2888/80 but it should be 2888/(80+5) where 5 is the overtime hours. I have checked the FLSA hours in the element discription for the overtime 1.5 still no luck. Can you please help me.

OTL setup/BR100 doc
written by Preeth , July 18, 2008

Hi Anil,

Could you please share any setup document or BR100 for OTL module?

Cheers,
Preeth

Skipped Assignments
written by Eduardo Schñadower , July 28, 2008

Hello Anil,
What can cause an assignment action to go into status "skipped" when running a payroll run?
I have a problem with some assignments that wouldn't run and instead went into that status, but I don't know where to start looking for whatever causes it.
Can you please tell me what are the probable causes of this?

switching to apps
written by onkar , August 20, 2008

Hi Anil,
I am in d2k development, i want switch to oracle apps...
Will u plz suggests me to have an module like HRMS,FA,OA Framework.
also I am SCJP Certified....

...
written by mnagilla , October 03, 2008

Hi,

I am doing a employee conevrsion in HRMS using API's . The name field in the flat have data exceeding the default col size in the base table. Can you please let me how to deal with this secinario........

Thank you
mnagilla

...
written by Anil- , October 03, 2008

You will have to substring, there is no other choice.
To audit, you can keep the original name in an SIT which you can populate during migration

PAYROLL ISSUE
written by prathap , November 04, 2008

Hi,

I Started Creating a NEW PAYROLL. Everything was working fine till I Create NAME, PERIOD TYPE, FIRST PERIOD END DATE, NUMBER OF YEARS, DATE OFFSET DETAILS, PAYMENT METHOD.

When I came to CONSOLIDATION SET, I tried to Select from LOV. As soon as I select one, it is throwing a ERROR

"APP-FND-01050 : This Flexfield cannot be opened because it has no displayed segments. Please contact your system administrator.

Modify your flexfield definition to display one or more segments. This may also be caused by incorrect use of the DISPLAY=token to the flexfield user exits in the form. In that case,please contact your support representative."

..............
written by prathap , November 04, 2008

Can anyone Plz help me in the above issue

OTL BR100
written by Udai Kumar , November 13, 2008

Hi anil,

can you please share BR 100 template for OTL,

Thanks in Advance,

Udai

Oracle HRMS Interview point questions
written by Jalli , November 24, 2008

Hi,

I had done Oracle HRMS course recently and looking for a Job. Can any one suggest me with wat kind of questions would be asked at the interview point of view.

Thanks in Advance,
Cheers,
Jalli

Hi need help
written by kalpana , July 27, 2009

Can you help me in with the set up document for UK payroll SSP and SMP and snap sort how to perform these things

Regards
kalpana

restore record
written by kafajy , August 29, 2009

hi anil
how i can restore record delete from per_all_people_f using toad by pl/sql command ....thanks

need help to setup payroll in egypt
written by kalpana , January 19, 2010

Hi anil,

need help to setup payroll in egypt as there is no localization patch is avaliable for egypt payroll we have to start the project in feb 1st week can u help me by providing the details how to go about the implementation of payroll for that localization.

Regards
kalpana

Balances
written by Murugesh , March 09, 2010

Hi Anil,

Can you brief me the significance of GROSSUP is Balances

Regards,
R.MURUGESH

Payroll Data migration template
written by Rajneesh Candra , March 20, 2010

Hi Anil How r u.. i am following ur site for quite long time...
I need some help in paroll data migration template ... balance intialization...
Please help waiting for ur reply..
regards
Rajneesh

Good Morning Anil
written by Abdulrahman , March 29, 2010

Anil, I am traveling to India. Can you provide you institute address, so I can passby? Mainly in south India like Bangalore..

Thanks
Abdulrahman Ahmed
Kuwait

What steps are needed to self-service enable function for other
written by Rubel , March 30, 2010

Hi anil,
When converting to multi-org(seperate LE), what steps are needed to enable existing self-service functions for new LE, if you please give a outline, that wold be very helpfull.

tax balaces report
written by lenin , June 01, 2010

Hi Anil,

I have a doubt on head tax in the payroll process.We have one custom report called tax balances report used to calculate the taxes based on the taxtype(Like city tax,state tax,school tax.. etc),now new requirement is to calculate based on the headtax(previously no headtax parameter now we need to add that and calculate only for head tax).Iam not able to calculate for head tax could you please help me out.....

Thanks
Lenin

Oracle HRMS guides
written by Rizwan_1 , June 02, 2010

Hi Anil,

I seen your site some days and found it very informative. I have 7 years of experience in payroll configuration and implementation, now I want to get hands-on of Oracle HRMS. Can you refer me step by step guide for Oracle HRMS (payroll configuration related). I would be very grateful to get these guides.

I have another question here, how can we handle substiture wages in Oracle Payroll. For these type of wages an employee is paid a salary of another designation for a specific day.

Regards,
Rizwan