Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to get the start date of a payroll period using the coverage start date — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get the start date of a payroll period using the coverage start date

Accepted answer
11
Views
4
Comments

Summary:

Rate Start Formula: START_DATE of the payroll period containing the coverage start date.


Content (required):

I'm attempting to use the BEN_FN_GET_CHAR_VALUE function for the PAY_TIME_PERIODS table to return the start date of the payroll period. I'm first calculating the coverage date (l_cvg_start_dt), and using it in parameter 6. I've tried different versions of the formula, some of which compile but all are returning one error or another. The current formula version fails to compile. I'm receiving the error message: Formula FAY_NEW HIRE RATE START DATE, line 27, either function BEN_FN_GET_CHAR_VALUE doesn't exist or the combination of parameter types doesn't match the statement.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!