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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Leave Balance Calculation date showing different than UI in BIP report

Summary:

Hi Team,


Leave Balance Caluclation date showing diffrent than UI in BIP report

Content (required):


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


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

Select papf.person_number Person_id, 

    ppnf.FULL_NAME,

    papf1.person_number Manager_number,

    ppnf1.FULL_NAME Manager_Name,

    to_char(ppos.ORIGINAL_DATE_OF_HIRE,'MM-DD-YYYY') Enterprise_Hire_Date,

    aapft.NAME Plan_Name, 

    to_char(apae.ACCRUAL_PERIOD,'MM-DD-YYYY') Balance_End_Date,

  apae.END_BAL current_balance,

  haou.name Legal_Employer               

from PER_PERSON_SECURED_LIST_V papf,

   PER_PERSON_NAMES_F ppnf,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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