EBS Customizations (MOSC)

MOSC Banner

how to pass value 01-JAN-1900 in concurrent program parameter

edited Jul 25, 2013 5:12AM in EBS Customizations (MOSC) 1 commentAnswered
Hi

I need to list AR invoices with TRX Date >= 01-JAN-2000

I have sql plus type executable and created concurrent program and parameter of type FND_STANDARD_DATE

what i found is it defaults to 01-JAN-00 in the program.

how do i preserve it as 01-JAN-1900 ? i fear that 01-JAN-00 could be interpreted as 01-JAN-2000

I tried to have a concurrent program  parameter of type '15 Characters'

then in the sql , i tried to_date on the value 01-JAN-1900, but it converts it to 01-JAN-00

i tried both YY nd RR formats.

any help would be appreciated.

Thanks

T.K

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