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!

DOCUMENTATION ON CMP_SALARY_ENTRY_API

Raymund JeromeJul 14 2020

Hi everyone,

We saw CMP_SALARY_ENTRY_API being used in CMP_ASG_SALARY_V under Tables and Views for Oracle HCM Cloud:

https://docs.oracle.com/cd/E83857_01/saas/global-human-resources/18b/oedmh/CMP_ASG_SALARY_V-view.html

So far we saw 3 functions:

CMP_SALARY_ENTRY_API.GET_SALARY_CHG_PERCENT(PSA.SALARY_ID,PSA.DATE_FROM) LAST_CHANGE_PERCENT,

CMP_SALARY_ENTRY_API.GET_ANNUALIZED_SALARY (PSA.ASSIGNMENT_ID, PSA.DATE_FROM, 0) AS ANNUAL_SALARY,

CMP_SALARY_ENTRY_API.GET_ANNUALIZED_FT_SALARY (PSA.ASSIGNMENT_ID, PSA.DATE_FROM, 0) AS ANNUAL_FT_SALARY,

It appears that it accepts 2/3 parameters, an ID, a date, and returns 0 if no data are found.

We are using Oracle HCM Cloud 20b.

I cannot see any documentations available.

Please help and redirect us to any resources related to this. We are curious if there are any other functions under this API, and its usage.

Any references at all would be great.

Thank you

-

Raymund

Comments

Post Details

Added on Jul 14 2020
0 comments
605 views