OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » fast formula calculation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

fast formula calculation [message #581001]

Sun, 31 March 2013 00:50

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

Report message to a moderator

Re: fast formula calculation [message #581006 is a reply to message #581001]

Sun, 31 March 2013 04:21

Littlefoot
Messages: 21756
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.

Report message to a moderator

Re: fast formula calculation [message #581012 is a reply to message #581006]

Sun, 31 March 2013 06:36

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.

Report message to a moderator

Previous Topic:	Delay time in receiving mail
Next Topic:	Web ADI and Portal Integration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 31 17:15:56 CST 2023