Sample Setup For Case Scenarios in Oracle Payroll - Loan
Sample Setup For Case Scenarios in Oracle Payroll - Loan
Sample Setup For Case Scenarios in Oracle Payroll - Loan
TheaimofthispostistoprovidesamplecasestudyforbeginnersinOraclePayroll.Thiscasestudywilltakeyou
throughtherealtimerequirementsinpayrollforUAElegislation.Infurtherpostswewillbedealingwithscenarios
relatedtocostingandresolutionforissuesduringpayrollsupport.
Note:Allsetupsareeffective01Jan1951
1.LoanSetup
Case: In your organization, an employee is eligible to apply for a loan. Now the administrator will determine the
number of installments required to recover this loan. This loan is internal and does not require payment to be
madetoathirdparty.Letuskeepitverysimple.OraclePayrollbydefaultprovideselementsforHandlingLoans.
Youmayusetheseorcreateyouown,asIhavedoneforsimplicitysake.
Approach:Youneedanonrecurringelement,somethingthattheadminwilladdintheelemententriestosaythat
in this run the loan is to disbursed to the employee. Then recurring elements for deducting the installment in
subsequentrunsuntiltheentireamountisrepaid.Alsothecorrespondingbalancesneedtobecreated.Thenwe
writethefastformulaforprocessingtheloanandvalidationsifany.Definetheformularesult.Gototheelement
entryscreenaddtheloanelementandrunthequickpaytocheckoursetup.
ElementandBalanceSetup:TotalCompensation>Basic>ElementDescription
TotalCompensation>Basic>Balance
___________________________________________________________________________________
Element
LoanAmount
Classification
Earnings
Type
NonRecurring
TerminationRule LastStandingProcess
OtherOptions
ProcessinRun
Priority
7552
InputValues
PayValue
ElementLoanRepayment
Classification
Type
TerminationRule
VoluntaryDeductions
Recurring
LastStandingProcess
OtherOptions
ProcessinRun
Priority
7550
Number
ofLoan
Installments(Number)
Amount(Money)
InputValues
Element
Classification
Type
TerminationRule
OtherOptions
Priority
LoanOutstanding
Earnings
NonRecurring
LastStandingProcess
ProcessinRun
7561
InputValues
Outstanding
Amount(Money)
Balance
Loan
Once
Period
in
IndirectResult
Each
Feeds
LoanRepayment(Add)
Dimension
Assignment Inception to
AssignmentRun
Date
Element Entry
Inception
to
Date
___________________________________________________________________________________
TotalCompensation>Basic>WriteFormula
FastFormula:LoanCalculation
Type:OraclePayroll
DEFAULTFORPAY_PROC_PERIOD_START_DATEIS'1951/01/0100:00:00'(date)
DEFAULTFORPAY_PROC_PERIOD_END_DATEIS'4712/12/3100:00:00'(date)
DEFAULTFOREMP_HIRE_DATEIS'4712/12/3100:00:00'(date)
DEFAULTFORAMOUNTis0
DEFAULTFORSTOPIS'NO'
DEFAULTFORLOAN_OUTSTANDINGIS0
DEFAULTFORLOAN_INSTALLMENTIS0
INPUTSARELOAN_AMOUNT,NUMBER_OF_INSTALLMENTS
IFLOAN_BALANCE_ASG_ITD=0ANDPAY_PROC_PERIOD_START_DATE=ENTRY_START_DATETHEN
(
LOAN_OUTSTANDING=LOAN_AMOUNT
MSG='Loanisdisbursed'
RETURNLOAN_OUTSTANDING,LOAN_AMOUNT,MSG
)
IFLOAN_AMOUNTLOAN_BALANCE_ASG_ITD>0THEN
(
LOAN_INSTALLMENT=LOAN_AMOUNT/NUMBER_OF_INSTALLMENTS
LOAN_OUTSTANDING=LOAN_AMOUNTLOAN_BALANCE_ASG_ITDLOAN_INSTALLMENT
IFLOAN_OUTSTANDING>0THEN
(
MSG='LoanRecoveryinprogress'
RETURNLOAN_OUTSTANDING,LOAN_INSTALLMENT,MSG
)
ELSE
(
MSG='Loanrecoverycompleted'
STOP='YES'
RETURNLOAN_OUTSTANDING,MSG,STOP
)
)
FormulaResult:TotalCompensation>Basic>FormulaResults
[http://4.bp.blogspot.com/fAIkJUSVK28/Ubmp67svSYI/AAAAAAAASWw/bGVEorSyVPQ/s1600/formula+result.JPG]
[http://1.bp.blogspot.com/i5NtJYRd1so/UbmrVSszHI/AAAAAAAASXA/U79kO7dTgoM/s1600/formula+result+2.JPG]
Nowwegototheemployeeassignmentscreenandaddtheentryasshown.LoanRepaymententryforemployee
inFeb
Note:Thishasalreadybeenprocessed,hencethecheckandenddate.
QuickPayResults:People>EnterandMaintain>
1.Selecttheemployee
2.ClickonAssignment
3.ClickonOthers
[http://4.bp.blogspot.com/7UBuvAHeNY/UbmyYmZaKKI/AAAAAAAASXQ/N_P1Rk6q544/s1600/element+entry.JPG]
4.ClickonQuickPay
[http://4.bp.blogspot.com/TvFoV4Ab2ls/Ubm_yMMFLI/AAAAAAAASYo/OVUpdGMvcQ/s1600/quick+pay.JPG]
February:
[http://3.bp.blogspot.com/iiPGDt_DKPI/Ubm0N7EpRKI/AAAAAAAASXg/r2kWrP0B8MQ/s1600/feb.JPG]
[http://3.bp.blogspot.com/XnDKtDmHwsE/Ubm0S74THbI/AAAAAAAASX0/dpi2MVrHm9s/s1600/jul.JPG]
[http://3.bp.blogspot.com/XnDKtDmHwsE/Ubm0S74THbI/AAAAAAAASX0/dpi2MVrHm9s/s1600/jul.JPG]
[http://1.bp.blogspot.com/R7vqDuYPY0I/Ubm0S1oGoRI/AAAAAAAASX4/T9_JlP3_ZU/s1600/jul+result.JPG]
March:
[http://3.bp.blogspot.com/uKA6yT5pMBw/Ubm0TDGMTI/AAAAAAAASX8/Uoc0pFiodyo/s1600/mar+result.JPG]
[http://1.bp.blogspot.com/2egM0pE65jw/Ubm1AE99INI/AAAAAAAASYU/1384bDAZEM/s1600/mar.JPG]
July:
[http://3.bp.blogspot.com/XnDKtDmHwsE/Ubm0S74THbI/AAAAAAAASYA/hHVWDUu6Glc/s1600/jul.JPG]
[http://1.bp.blogspot.com/R7vqDuYPY0I/Ubm0S1oGoRI/AAAAAAAASX4/T9_JlP3_ZU/s1600/jul+result.JPG]
Posted13thJune2013byVasudhaandSreekanth
3 Viewcomments
JasminMezet April8,2014at7:30AM
HiVasudhaandSreekanth,
Very good post. But I was not able to get the results as you did. First, I needed to change the Loan Amount
earningelementfromRecurringtoNonrecurringsinceitwillnotappearinFormularesultsif(Earningelement)it's
Recurring.Ihopeyouarestill"online"sowecandiscussthisproblem?
Regards
Jazzmean
Reply
Replies
VasudhaandSreekanth
May21,2014at6:32AM
HiJazz,
Sorryforthedelayedresponse.Youarerighttheloanamountearningshouldbenonrecurring.Asyou
can see in the first screenshot where loan disbursed, the loan amount is an indirect result and hence
cannotbearecurringelement.Ihavenowcorrectedthetypo.
Pleasedoletmeknowifyouneedfurtherinformation.Ihopetobeactivelyavailableonthisblog:)
Regards,
VasudhaandSreekanth
Reply
VenuR November10,2014at7:00AM
Thiscommenthasbeenremovedbytheauthor.
Reply
Enteryourcomment...
Commentas:
Publish
GoogleAccount
Preview