Home » Applications » Oracle Fusion Apps & E-Business Suite » fast formula calculation
fast formula calculation [message #581001] Sun, 31 March 2013 00:50 Go to next message
hany_marawan
Messages: 198
Registered: April 2005
Location: Cairo - Egypt
Senior Member
Hello,
I try learning how to write fast formula in oracle payroll.
I hired employee at 1-3-2013 and I want calculate the payroll at 10-3-2013.
How can I write the calculation to calculate these allowances depend on these days only not all month.

Thanks
Re: fast formula calculation [message #581006 is a reply to message #581001] Sun, 31 March 2013 04:21 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Theoretically, that would be
full_March_payroll * 10 / number_of_days_in_March

Number of days can be calculated, for example, as follows:
SQL> select extract (day from last_day(sysdate)) from dual;

EXTRACT(DAYFROMLAST_DAY(SYSDATE))
---------------------------------
                               31

SQL>


However: as I don't use software product you do, there's a high possibility that the answer to your question is different. Someone else will assist with that, I hope.
Re: fast formula calculation [message #581012 is a reply to message #581006] Sun, 31 March 2013 06:36 Go to previous message
hany_marawan
Messages: 198
Registered: April 2005
Location: Cairo - Egypt
Senior Member
thanks for attention,
I know the code in SQL, but in fast formula the situation is different.
There's another code and syntax.
I want the code in fast formula.
Previous Topic: Delay time in receiving mail
Next Topic: Web ADI and Portal Integration
Goto Forum:
  


Current Time: Thu Mar 28 12:37:23 CDT 2024