Problem passing date parameter to concurrent program xsd design query
For some reason on a new report I'm designing in Oracle EBS 12.1.2, I cannot get a date parameter to pass to the concurrent report's design query properly. No matter how I try to pick up the date parameter in the .xsd query (truncating, converting to_date with various formats), I get all kinds of errors when comparing the date parameter to dates from the OTL hxc_timecards_v view. I can't seem to figure out the date format it needs.
The concurrent report is using an LOV for the date field that uses table validation from per_time_periods.end_date (type=date) to offer the user pay-period end dates in Payroll. It is defined with format validation type = "standard date".