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?
Tagged:
0