Locate Offer Salary

Hazel Fan

Hi,

For the context, we are using HCM 25A.

I'm trying to query the offer salary amount in the job offer.

I have checked IRC_OFFERS, and it doesn't contain the information.

Using CMP_SALARY doesn't give me the initial offer salary either.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/27053/locate-offer-salary

Hi @Hazel Fan,

Welcome to the Oracle Analytics Community!

Can you please check the following tables?

CMP_SALARY_PAY_COMPONENTS
CMP_SALARY_COMPONENTS

Hope this help.

Thank you.

Hazel Fan

Hi Bhaskar,

https://community.oracle.com/products/oracleanalytics/discussion/comment/70896#Comment_70896

Thank you for the suggestions. I tried querying these two tables, but it's not giving me any results.

I have also tried CMP_SALARY, but it only gives me the hired candidates' salary info.

What I want to see is the initial salary offered.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/70897#Comment_70897

Hi @Hazel Fan,

Quick Question: If you generate the offer letter are you getting the same values in the offer letter?

Thank you.

RVohra

Please see if following tables related to job publishing can help

IRC_CC_ELEMENTS_B ,

IRC_CC_ELEMENTS_TL

Look for Element Type Column and check if it has anything related to Salary.