How to deal with "MON-YY" date format in Oracle Apps 11.5.10.2.
One of the User requirement is to pull the data by the Period which is in ( MON-YY ) format... like 'JAN-11', 'FEB-11', 'MAR-11'.
we have standard value set "FA_PERIOD_NAME" which would pull the periods in ( 'MON-YY') format as it should be.
When i passed the date from my concurrent program it is not taking in "MMM-YY" format (as it should be ) in 11.5.10.2...same way i had issue for "DD-MON-YYYY" format while working with concurrent program..But i got the correct function to use from the Oracle Notes...it worked out well.
But now i need the function or get around process as now even i pass the period it is not passing correctly to the report.