940199 wrote:Please see ( How to Handle New Date Formats in SQL*Plus and PL/SQL Procedures? [ID 376034.1]).
We have 2 different environments that should be identical. We have a concurrent sql plus program with a date parameter whose value set is FND_STANDARD_DATE (in both environments). In one instance, the date gets passed to the report in DD-MON-YYYY format. In the other environment, the date is getting passed in YYYY/MM/DD HH:MM:SS. To my knowledge, the canonical format being passed is the correct one. What would be causing the one environment to be passing it in DATE format? What is happening between submitting the concurrent request and the values getting to the report? Thanks in advance!