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

Salary HSDL template to list only the actions related to salary update in LOV.

edited Nov 29, 2024 9:05AM in HCM Spreadsheet Data Loader (HSDL) 1 comment

Salary upload HSDL template to list only the actions related to salary update in LOV as in the application. Currently the VO used "oracle.apps.hcm.compensation.salary.core.publicView.SalaryActionsPVO" has below query and hence it lists all the actions.

—SELECT * FROM (select pac.business_group_id ,pac.action_id ,pac.action_code ,pac.action_name ,pac.start_date ,pac.end_date ,pac.action_type_code ,pac.action_type_id ,pac.country ,pac.is_system_action from per_actions_vl pac where :pStartDate between pac.start_date and pac.end_date and decode(pac.country, null, 'Y', decode(sign(instr(pac.country,nvl(:countryCode,pac.country)) ),1,'Y','N')) = 'Y') QRSLT ORDER BY "ACTION_NAME"—

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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