BIP Report is breaking due to the Pay Period parameter — Cloud Customer Connect
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

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'.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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