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 with Redwood for Oracle Cloud HCM   Begin Now

Fixed Data type List Of Values in BIP

Summary:

Hello,

This is related to the BIP report input parameter type as Menu and List of Values as Fixed Data.

We have a requirement to show the data of either all the terminated employees (with Assignment Status = INACTIVE) or show All (Assignment Status in INACTIVE, SUSPENDED, ACTIVE).


Code : PAAM.ASSIGNMENT_STATUS_TYPE IN (:P_ASG_STATUS)

Only the first selection i.e., INACTIVE is working. But when we select No in input parameter, it is not working. We tried doing via Comma separated values (with and without square brackets), single quotes around each value and double quotes as well. nothing seems to work. Can something be done at data model level?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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