Balances in Oracle HRMS Payroll

Lets understand it by an example.

Consider you work in a company and your provident fund is being deducted every month. So at some point in time, you may want to know your provident fund balance( Employee Contribution + Employer Contribution), to fulfill this requirement, Balances is a very good feature provided by Oracle.

What steps are required to be performed??

1) Define Element
2) Define Element Links
3) Define Balance
4) Run Quick Pay or Payroll for Testing

Step 1: Define Element and its Inputs

Navigation: Global HRMS Manager --> Total Compensation --> Basic --> Element Description

I have created an element called "Provident Fund Employee Contribution" as shown below.

Balances in Oracle HRMS Payroll


I will use the input "Pay Value" which is created by default.

Step 2: Define Element Links

Navigation: Global HRMS Manager --> Total Compensation --> Basic --> Link


Balances in Oracle HRMS Payroll

For the purpose of understanding, i have created a generic element link. But kindly create link according to your criteria and provide costing details.

Step 3: Define Balance


Navigation: Global HRMS Manager --> Total Compensation --> Basic --> Balance


Balances in Oracle HRMS Payroll



To specify the element and input name for which  you are creating the balance, preferably do not specify them on main balance screen as shown in Screenshot 3. Use the Feeds functionality for this.




Feeds: 
Use the Balance Feeds window to select balances to be fed by the input values of an element. Balances are either fed by whole classifications of elements or by individual elements, but not by both. It gives you extra control of creating a balance using multiple elements.

I just selected the element we created in Step 1.


Balance Feeds in Oracle HRMS Payroll

Dimensions:

Select your required dimensions from list of values. Most common dimension used are

_ASG_PTD                          Period to Date balance
_ASG_ITD                           Inception to date balance
_ASG_FYTD                        Fiscal year to date balance
_ASG_YTD                          Calendar year balance
_ASG_RUN                          Assignment Run

Balance Dimensions in Balances in Oracle HRMS Payroll


Classification: 

Select classification e.g. Earnings, Voluntary Deductions etc. and Add/Subtract for each. Run Results of all elements with classification will be fed into the balance.

NOTE: if you have already selected any element in Balance feeds window, you can not select a classification on Balance classification window.

Balance Classification in Balances in Oracle HRMS Payroll

Initial Feed:

This window is used for balance adjustment.

Step 4:

Attach the Element Entry and run the quick pay or payroll.

I ran quick pay for an employee of some periods. It is shown in screenshot below how balances work.

Navigation: Global HRMS Manager --> People --> Enter & Maintain --> Assignment --> Entries


Balances in Oracle HRMS Payroll

Navigation: Global HRMS Manager --> People --> Enter & Maintain --> Assignment --> Others--> Quick pay

View Results --> Balances

Period 1:


_ASG_PTD                        1500
_ASG_ITD                         1500
_ASG_FYTD                      1500
_ASG_YTD                        1500
_ASG_RUN                        1500

Balances in Oracle HRMS Payroll



Period 2:



_ASG_PTD                        1500
_ASG_ITD                         3000
_ASG_FYTD                      3000
_ASG_YTD                        3000
_ASG_RUN                        1500



Balances in Oracle HRMS Payroll


Fiscal year to date : it will reset itself when new fiscal year starts.
Period to date : Changes every period
Inception to date : Does not change ever.
Calendar year to date: It will change when a new calendar year starts.

I hope this post helped you a bit

Kindly provide your feedback.

Leave a comment for any query.




46 comments:

  1. Why you said: "preferably do not specify them on main balance screen as shown in Screenshot 3. Use the Feeds functionality for this."

    Reason for preference?

    ReplyDelete
    Replies
    1. Hi Abhishek,

      The reason is that if we select element name on main screen while defining the balance, we can only use input values to add/subtract of that particular element. So when you directly select elements from feeds window, you can use multiple elements and its input values to create your rules to add/subtract as per your requirement. if there is any confusion, let me know.

      Regards,
      Waqas

      Delete
  2. Hi Waqas,I liked your post and Presentation. Iam doing implementation for Middle East Payroll , How can i enter the initial Payroll Balance for different type of elements , Eg : Loan or GOSI .

    ReplyDelete
    Replies
    1. Hi Praneeth,

      To enter the initial balance, there is a standard feature called Balance adjustments. Kindly go through its details.

      Regards,
      Waqas

      Delete
  3. Hi Waqas, Thanks for the reply.Can you please suggest any document where i can refer.
    thanks in advance

    ReplyDelete
    Replies
    1. Hi Praneeth,
      You shoud go to Oracle Metalink. I am quite sure you will find it there.

      Delete
  4. Very good Blog Waqas Dear.

    Thanks.
    Waqar Azeem

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. Salam to All thanx Waqas Bhai Thanx a lot:very helpfull blog this is
    Another issue i have:::please check it
    we have two elements Loan recovery Elements,and housing advance recovery..
    for some employee during the recovery period When Assignment Information is Changed, Some Element Entries Automatically Change To Null Value....then restrat recovery from the begining.how can i handle it,,??related to this problem i have no such mechanism in oracle to know the exact (deducted and remaining amount) in the application level.by wich i can manually adjust them befor payroll run..what is your suggestion.please.??

    ReplyDelete
    Replies
    1. AoA Shakil,

      You can get that information in balance using balance feeds in combination with different balance dimensions. Got it??

      Delete
  7. Hi Waqas,

    Nice Blog ... i have an generic question ... I am also planning to create a blog like this. can you please let me know the procedure .

    Appriciate your help.

    ReplyDelete
    Replies
    1. Hi Praveen,

      Kindly provide your email id. I will send you a document as attachment.

      Delete
  8. This comment has been removed by the author.

    ReplyDelete
  9. Dear Waqas:
    The Element (Loan Recovery) is working perfectly in the Preprod instance.
    We face the issue only in the Production and UAT instance(latest Cloned).
    I analyzed the Loan Recovery Elements in these two instance and compared one by one i did,t find any diference..But still the issue Exist..Can you suggest where i will find the Problem

    ReplyDelete
  10. Hi

    Need inputs to handle this new requirement of my client:

    The number of leaves the employee is eligible for will have to get changed in the system according to the below criteria. This holds good for those employees who are associated with ‘30 Days Annual Leave' accrual plan:

    No. of years of service -- Annual Leave Entitlement

    First 2 Years -- 30 Days
    2 to 3 Years -- 32 Days
    3 to 4 Years -- 33 Days
    5 Years & above -- 35 Days

    This policy is active from 1-Apr-2010, so the employees’ experience years before that will not be included in the total years of experience. For example, if an employee’s hire date is 1-Jan-2009, the
    total experience till date is 5 years actually, but the leave computation should be effective from 1-Apr-10, so the total experience is 3.75 years and he will get 3 extra days.

    Any pointers on this would be highly appreciated!

    Thanks much in advance!

    ReplyDelete
    Replies
    1. Hi Trupti,

      You will have to modify your accrual formula. In formula, conditions exist on leave band based on number of years of service.

      Regards,
      Waqas

      Delete
  11. Thank you Waqas!

    I am still an amateur when it comes to fast-formulas & functions.

    Request your help in modifying the accrual fast formula. I tried copy-pasting the FF that we have currently, but unable to, due to the 4096 characters restriction here. Please let me know if I can send you the FF.

    Your assistance is much appreciated.

    Thanks

    Regards
    Trupti

    ReplyDelete
    Replies
    1. Hi,

      Send me your FF on my email id uetian.waqas@gmail.com

      Delete
  12. waqa bhai...
    Can you check my post above please...

    ReplyDelete
  13. Hey,

    Do you recommend a balance set for every business group defined on an instance? or one balance set for to shared among multiple business groups.

    thanks,

    ReplyDelete
    Replies
    1. In which context are you using the term of "balance set".


      For each business group, we have to create separate balances. We can not use balances across multiple business groups.

      Delete
  14. This comment has been removed by the author.

    ReplyDelete
  15. Assalam U Alaikum to every one:
    i want to make personalization.in the element entries for Vacation pay element.
    payroll section should not be able process vacation pay element before the data entry in the absence screen by hr.
    Can i do this...? any body can help me.

    Thanks

    ReplyDelete
  16. Assalam U Alaikum to every one:
    i want to make personalization.in the element entries for Vacation pay element.
    payroll section should not be able process vacation pay element before the data entry in the absence screen by hr.
    Can i do this...? any body can help me.

    Thanks

    ReplyDelete
  17. Hi Waqas,

    Good Blog ... i have an generic question ...

    I am writing a blog like this. can you please let me know the procedure of effective way of writing blog.

    ReplyDelete
  18. Hi Waqas,

    I have an issue Like employee will payed 30% in direct deposit and 40% in Cash then remaining 30%
    will be payed by which method?(with Out Default Payment method)

    ReplyDelete
    Replies
    1. Hi Sandeep,

      Enter three different payment methods at employee assignment level and put the percentage accordingly.

      Priority is also important. Highest priority is One. Assign it to your desired payment method.

      Delete
  19. The information you had provided on Oracle HRMS and Payroll are very good and very useful. Your work is greatly appreciated.

    ReplyDelete
  20. Please share tutorials for Element & Element Link in HRMS Payroll

    ReplyDelete
  21. shakil ahmad : aasalam aaleykum bhai am new in hrms functional allh key li plz help me bhai ...
    i don't know real time how to practice if you have any real time setupdocuments plz allah key faal sey send me bhai am very help full to you if you send this this is my mail id shraeefkhan.p@gmail.com.......i have so many problem s i suffer from one year when i attend the interview they asked real time question acutually i don't know bhai plz if you have any real time questions setup document ....releated this module plz send me bhai core hr, payroll, irc,sshr, olm,otl ...i have basic knowlege on this if you help am so help full forn life time bhai ...i am waitng for ur reply

    ReplyDelete
  22. I followed your example but Balance is not updated Pls tell me what I missed? Thank u

    ReplyDelete
  23. Great post.......In accounting, payroll refers to the amount paid to employees for services
    they provided during a certain period of time. Payroll plays a major role in a company for several reasons.
    Click here to learn more

    ReplyDelete
  24. Hello Waqas,
    My issue is related to Annual leave, I have given scenario below.

    Business User has taken leave and manager approved but somehow she did not take the leave. But Payroll already run for current month. Now they want to adjust same leave in next month. let me know please how handle it.

    Regards,
    Ashok Singh

    ReplyDelete
  25. Fiscal year to date : it will reset itself when new fiscal year starts.
    but it has changed to 1500 to 3000?
    Period to date : Changes every period
    but it has not changed?
    Inception to date : Does not change ever.
    It has changed.
    Calendar year to date: It will change when a new calendar year starts.
    It has changed even though calender year not changed?
    as per caluculated as below...Please explain why?
    Period 2:



    _ASG_PTD 1500
    _ASG_ITD 3000
    _ASG_FYTD 3000
    _ASG_YTD 3000
    _ASG_RUN 1500

    ReplyDelete
    Replies
    1. ASG_FYTD Fiscal year to date : it will reset itself when new fiscal year starts. EVERY MONTH INCREASING , BUT AFTER INE YEAR IT WILL RETURN TO 1500
      als ASG_YTD : it will reset itself when new fiscal year starts. EVERY MONTH INCREASING , BUT AFTER INE YEAR IT WILL RETURN TO 1500

      ASG_PTD Period to date : NOT Changes every period 1500
      ASG_ITD Inception to date : change every Period
      ASG_RUN : change every Period

      Delete
  26. Hi Waqas,
    Have a question on Balance and Dimensions. I have to write a Fast formula to fetch the corresponding YTD amount for the Balance and Dimension. I am unable to find the Related DBI for the balance and dimensions.
    Balance Name is 'EPS Profit Sharing'
    Dimension Name is 'Relationship Tax Unit Year to Date'

    Please share if you have any information on the Formula type to be used and the related DBI...
    Thanks,
    AS

    ReplyDelete
  27. Office management is the work associated with designing, implementing, evaluating and maintaining processes of work within the office and other organizations to maintain and improve efficiency and productivity. Try our high quality Office Management Software

    ReplyDelete
  28. Its really helpful for me, Your blog is easily understandable and give complete information. Keep sharing new ideas and features.
    HRMS Software in Dubai
    HRMS Software Dubai
    HRMS Software in UAE
    HRMS Software

    ReplyDelete
  29. Hello, this weekend is good for me, since this time i am reading this enormous informative article here at my home. my balance now

    ReplyDelete
  30. I love to read your articles because your writing style is too good, its is very helpful for all of us and I never get bored while reading your article. KEEP SHARING!!
    android apps apkzm
    android apps apkzm
    android apps apkzm
    android apps apkzm
    android apps apkzm
    android apps apkzm
    android apps apkzm
    android apps apkzm
    android apps apkzm

    ReplyDelete
  31. Thank you for sharing an amazing blog. I have come across an excellent HRMS blog

    ReplyDelete
  32. Bayzat is the one of the best work life HR software that unifies HR, Payroll, and employee management in Dubai, UAE. Payroll Software

    ReplyDelete
  33. HRMS UAE sounds like a fascinating topic! The blog post seems to delve into the significance of Human Resource Management Systems (HRMS) in the Middle East region. As a professional in the HR field, I can appreciate the value of HRMS in streamlining HR processes and enhancing overall efficiency.

    ReplyDelete