ADI - Loading DFF with Std Date format

 

Am using Oracle Financials version 11.5.10.1 and ADI version 7.2.11.07.29, 32 bit (patches have been applied to upgrade ADI for use with Microsoft Excel 2007).

I've created a DFF with format of 'Standard Date' and I can't seem to load any values using ADI. I get a warning message like '21-DEC-2010 for the flexfield segment TRANS DATE does not exist in the value set ....'.

I can go into the application and manually load data to that DFF, just not through ADI. When I do manually load it requires entry using the following date format - DD-MON-RRRR. I've tried changing the cell formatting in ADI to to different date formats and even text, and that doesn't resolve the problem either.