| Debugging Accrual Fast Formulas [message #475995] |
Mon, 20 September 2010 09:11  |
hfarahat
Messages: 1
Registered: September 2010
|
Junior Member |
|
|
Hi,
I have a problem in my Accrual FastFormula. When i query for the net accrual from the HRMS forms, i got no errors and the number are fine. But when i use the function per_utility_functions.get_net_accrual, i got the following error
""ORA-20001: An error has occurred in a user defined function at line 223 of the formula XX_OULA_PTO_ACCRUAL. The error text associated with the function call is: The system cannot calculate accruals for this date becuase the employee's payroll did not exist for the full accrual term..
Please correct the problem with the function call, or contact your system administrator or support representative.
ORA-06512: at "APPS.PER_FORMULA_FUNCTIONS", line 608
ORA-06512: at "APPS.PER_ACCRUAL_CALC_FUNCTIONS", line 70
ORA-06512: at "APPS.PER_ACCRUAL_CALC_FUNCTIONS", line 129
ORA-06512: at "APPS.PER_ACCRUAL_CALC_FUNCTIONS", line 907
ORA-06512: at "APPS.PER_UTILITY_FUNCTIONS", line 787
ORA-06512: at line 1
""
Line 223 in my FF: "E = GET_PAYROLL_PERIOD (ADD_DAYS(First_Eligible_To_Accrue_Date,1))"
I want to debug the FF to i know the value passed parameter (First_Eligible_To_Accrue_Date) in case of forms calling or SQL calling. How can i do this?
Thanx
|
|
|
|
| Re: Debugging Accrual Fast Formulas [message #476650 is a reply to message #475995] |
Fri, 24 September 2010 06:55  |
 |
Alien
Messages: 292
Registered: June 1999
|
Senior Member |
|
|
Hi,
Oracle has a good document on debugging FastFormula. It is MOS note: 363754.1
The easiest is to start with a simple RETURN.
If needed you can enable debug and use PYUPIP tracing.
Regards,
Arian
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
