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

need an OTBI report for an accrual plan matrix

Accepted answer

Summary: need an OTBI report to list our contents of the accrual matrix online:

I can get most of the information from ANC_ABSENCE_PLANS_VL and   ANC_ACCRUAL_BANDS_F  table but could not find source table of Accrual formula info

Content (required):Need to find DB table containing the Accrual formula info

Version (include the version you are using, if applicable): 23B

Code Snippet (add any code snippets that support your topic, if applicable):

have the following incomplete code snippet:

select abpl.absence_plan_id,

abpl.effective_start_date abpl_eff_stdt, abpl.effective_end_date abpl_eff_enddt,

Howdy, Stranger!

Log In

To view full details, sign in.


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