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

Termination Alert -

in Human Capital Management 5 comments

Summary:

After copying the seeded alert and making some changes, I am seeing the following errors. Please let me know what I am missing.

EXISTS (SELECT 'X' FROM PER_PERIODS_OF_SERVICE WHERE (TRUNC(ACTUAL_TERMINATION_DATE) >=TRUNC(SYSDATE-7)) AND (TRUNC(ACTUAL_TERMINATION_DATE) <=TRUNC(SYSDATE+2)) AND PERSON_ID = ${PersonId})

java.lang.Exception: Error in Execution of this -> lopp, resource names and expresssion are mismatched
at oracle.apps.hcm.common.core.alerts.processing.AlertFunctionImpl$LoopImpl.executeLoop(AlertFunctionImpl.java:440)
at oracle.apps.hcm.common.core.alerts.processing.AlertFunctionImpl.loop(AlertFunctionImpl.java:192)
at oracle.apps.hcm.common.core.alerts.AbstractAlertFunctionsImpl.loop(AbstractAlertFunctionsImpl.java:2465)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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