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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

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

OTBI Goal plan Approval status 'APPROVED' details issue

Summary:

OTBI Goal plan Approval status details issue

Content (required):

Hi Team,

To get the Goal plan Approval status of 2023 review period details we have joined "Human Capital Management - Transaction Administration Real Time" and "Workforce Goals - Goal Plan Assignments Real Time" subject areas and were able to get 'PENDING' Goal plan approval status however the Goal plan 'APPROVED' status details are not giving correct number when compared with actual approved Goal plan Employees.

Please advise on this attached the SQL query.

OTBI Employee Goal Plan 'APPROVED' count: 1532

BIP Version Type CODE-'ACTIVE' Employees Count: 3688

Difference : 2156

Regards,


Naidu G

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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