EBS Customizations (MOSC)

MOSC Banner

Problem passing date parameter to concurrent program xsd design query

edited Feb 5, 2013 5:07AM in EBS Customizations (MOSC) 2 commentsAnswered
I sure hope someone can help me here.

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center