Shivmohan Purohit – Now moved to Houston, Texas, USA

Hi All Readers and Subscribers :

Thought to inform you, Recently I moved to Houston , TEXAS  in USA.  Now I will be available US Central Day Time for any help. Also if you sending email then I may able to revert during US day time.

Now I am planning to expand this blog into more a learning plateform using Skype, Google+ Hangout and other new technological tools to share and spread Oracle Knowledge.  If you also like join me in writing Articles, Giving knowledge session or answering Q&A, providing guidance etc , do reach me to collaborate and work together.

Let reach out me via comment here … or send me email – shivmohan.purohit @

Thanks – Shiv


Employee account / User Account to be deactivated for terminated emoloyees

In HRMS responsibility –

1. Run the User Account Extract Process
Batch Name
Start Date
End Date
Run Type: Inactivate User Accounts for Terminated Employees

Inactivate User Account for Terminated Employees :
selects all employees terminated between the start date and end date parameter within the organization or organization hierarchy. Once selected, the terminated employee’s user account is end dated. This run type is used on an ongoing basis to end date terminated employee accounts within the date range.

2. Run Data Pump Engine
Batch Name : Same batch name as mentioned in 1
Validate: No

NO value will commit the data to the database if there are no errors. If there are errors the data will not be committed to the database and you can fix the errors and rerun the batch.


Oracle HRMS 11i/R12 Training Special Offer – Ltd time only

Dear Readers – For the month of August – We are celebrating the Indian Independence Day (August 15th) with a very special offer for you.

Now you can get the 4 DVD set for Oracle HRMS Techno-Functional Training for $99 discount. Currently, its available in USA for $199 with free shipping anywhere in the United States. With the special coupon code FREEDOM100 you’ll get this DVD set for only $100.

This offer is only valid from August 1st till August 31st. This coupon expired on August 31st at 12:00 pm PST.

What do you get in the DVD set? Here’s the list –