Home » Applications » Oracle Fusion Apps & E-Business Suite » Debugging Accrual Fast Formulas (EBS R12)
Debugging Accrual Fast Formulas [message #475995] Mon, 20 September 2010 09:11 Go to next message
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 Go to previous message
Alien
Messages: 282
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
Previous Topic: service contracts
Next Topic: Oracle Apps Installation failed
Goto Forum:
  


Current Time: Sun Sep 19 01:07:28 CDT 2021