Problem with ARF using DATE as PK
Hello,
I have a table with a PK of type DATE. I've created a form on the table, using APEX wizard, with a date picker of DD/MM/YYYY on the DATE field. When I submit the page, a new record is created in the proper table, but then I'm getting an error message " ORA-01843: not a valid month" from the ARF process. I created a report on the table, and I'm getting the records just fine. In the session state window, the value of the date item is also appears fine.
It seems like the ARF don't see the proper DATE format. Any ideas?
Thanks,
Arie.