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

Getting Error (HR_6881_HRPROC_ORA_ERR ORA-06512)

Question
49
Views
0
Comments
edited Aug 3, 2017 5:15AM in HCM Integrations

Content

I have an extract where I had to write a fast formula to find out rehire date as per customer's requirement:

The Formula which I have written is given below:

-------------------------------------------------------------------------------

DEFAULT_DATA_VALUE FOR PER_EXT_PAY_HR_REL_DATE_START IS '1951/01/01 00:00:00' (DATE)
DEFAULT_DATA_VALUE FOR PER_EXT_PAY_HR_REL_ORIGINAL_DATE_OF_HIRE IS '1951/01/01 00:00:00' (DATE)

I=1
J=1

WHILE PER_EXT_PAY_HR_REL_DATE_START.EXISTS(I)LOOP
(
DATE1= PER_EXT_PAY_HR_REL_DATE_START[I]

  WHILE PER_EXT_PAY_HR_REL_ORIGINAL_DATE_OF_HIRE.EXISTS(J)
  LOOP
  (
  DATE2= PER_EXT_PAY_HR_REL_ORIGINAL_DATE_OF_HIRE[J]

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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