how to pass value 01-JAN-1900 in concurrent program parameter
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