BI Publisher (MOSC)

MOSC Banner

BI Publisher Conditions

edited Nov 1, 2024 11:34PM in BI Publisher (MOSC) 2 commentsAnswered ✓

We are in the process of updating our Employee Offer Letters in BI Publisher and we are not having much success getting 2 different paragraphs to display based on the Job Code the new employee will be hired into.

We would like different verbiage to display is they are SAL employee's vs HRLY and Union employees. The job codes for the Salaried start with an "S" and job codes for non salaried start with either "N", "O" or "U".

I have tried using a wild card '%' in the condition and also using an "if substr" code to only look at the 1st character in the job code and neither of these give us the desired results.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center