BIP Report is breaking due to the Pay Period parameter
Summary: BIP report is dropping the record of few employees due to the condition trec.start_time between to_date(substr(:P_PERIOD_NAME,1,10),'MM/DD/YYYY') and to_date(substr(:P_PERIOD_NAME,12,21),'MM/DD/YYYY')
P_PERIOD_NAME is a string type parameter which is holding value as '09/19/2020-10/02/2020' , in above condition this value is getting splitted and converted to date. when we are passing person number is person_number parameter along with one value in P_PERIOD_NAME , we are getting the data but when we are selecting multiple options in P_PERIOD_NAME , data model is throwing error 'Missing right parenthesis'.