Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

GET_PLAN_BALANCE function is not returning value in Absence entry validation formula

3383061Aug 22 2017 — edited Aug 22 2017

Hi Friends,

I am trying to get the accrual plan balance for my absence plan using get_plan_balance in absence entry validation formula. But, the function is returning zero where as the accrual balance is 23. Has any one used it? Please provide your inputs.

CHANGE_CONTEXTS(HR_ASSIGNMENT_ID = l_term_id, PERSON_ID = L_Person_Id, EFFECTIVE_DATE =l_current_date, LEGISLATIVE_DATA_GROUP_ID = l_leg_id)

  (

  L_Leave_Balance = GET_PLAN_BALANCE(l_ldg)

)

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 19 2017
Added on Aug 22 2017
10 comments
1,215 views