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

How to get Job ID based on a derived job code in fast formula

edited Sep 5, 2020 12:17AM in Compensation 4 comments

Summary

How to get Job ID based on a derived job code in fast formula

Content

I need to determine the job an employee can be promoted to based on their current job. The new job code is derived from the first 5 characters of the current job code concatenated with the next integer from the current job code 6th character e.g if the current job code is SMAEG1 the promotion job code would be SMAEG2. Once I derive this new job code, how do I determine the job ID associated with it? Is there an array that contains all the work structure job codes, a function that can return job ID, or a job code

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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