Please find a comprehensive set of HRMS Training Articles.
Oracle HRMS and Payroll Concepts
Date Tracking in HRMS Payroll in Oracle
Main tables in Oracle HRMS and Oracle Payroll
Payroll Elements and Element Links
Balances in Oracle HRMS Payroll
Fast Formulas in Oracle Payroll
Payroll Costing Hierarchy in Oracle
Oracle Payroll Debit Credit Concepts in Costing
Reconcile P35 and Gross To Net in Payroll
Audit Trail in Oracle HRMS
One of the most Important screens in Oracle Payroll
How to call a PL/SQL from Oracle Payroll Fast Formula
Oracle HRMS and Payroll Setups
HRMS Setups - NOT BR100
Security Profiles in Oracle HRMS
RetroPay Enhanced Setups
Special Information Types -SIT in HRMS
Data Migration in Oracle HRMS/Payroll & Misc Scripts
Oracle HRMS API Employee People Migration
HRMS Person Address Migration
Migrate Special Information Types in HRMS
How to Rollout Self Service Module to thousands of users [Scripts]
API to Update FND_USER and Add Responsibility
Other Miscellaneous Articles
Oracle HRMS Payroll Interview Questions
Oracle HRMS Profile Options
Oracle iRecruitment Applicant and Row Level Security
Differences between EIT and SIT in HRMS
Triggers in Oracle HRMS - Concepts
Demo - Audio Video- How to write triggers in Oracle HRMS and Oracle Payroll
written by Anil Passi , January 27, 2007
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
Which table stores the details of present and previous employment details including employer name.
Thanks
Hari
written by Anil Passi , February 24, 2007
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
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
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
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
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
written by Anil Passi , March 31, 2007
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
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
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
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
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
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
written by Nimish , October 02, 2007
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
written by Anshul , October 03, 2007
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
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
You must supply a City. Please enter a value for City and resubmit your request.
City was supplied. Verified everything was correct.
please help
written by bapuji , November 29, 2007
written by Prasad478 , January 08, 2008
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
written by Nikku , January 17, 2008
keep this gud wok going
written by G.Balaji , January 22, 2008
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
written by Rajesh Panchal , February 12, 2008
written by Venu , May 09, 2008
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.
written by Preeth , July 18, 2008
Could you please share any setup document or BR100 for OTL module?
Cheers,
Preeth
written by Eduardo Schñadower , July 28, 2008
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?
written by onkar , August 20, 2008
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
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
To audit, you can keep the original name in an SIT which you can populate during migration
written by prathap , November 04, 2008
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
written by Udai Kumar , November 13, 2008
can you please share BR 100 template for OTL,
Thanks in Advance,
Udai
written by Jalli , November 24, 2008
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
written by kalpana , July 27, 2009
Regards
kalpana
written by kafajy , August 29, 2009
how i can restore record delete from per_all_people_f using toad by pl/sql command ....thanks
written by kalpana , January 19, 2010
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
written by Murugesh , March 09, 2010
Can you brief me the significance of GROSSUP is Balances
Regards,
R.MURUGESH
written by Rajneesh Candra , March 20, 2010
I need some help in paroll data migration template ... balance intialization...
Please help waiting for ur reply..
regards
Rajneesh
written by Abdulrahman , March 29, 2010
Thanks
Abdulrahman Ahmed
Kuwait
written by Rubel , March 30, 2010
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.
written by lenin , June 01, 2010
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
written by Rizwan_1 , June 02, 2010
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








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