Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Concurrent Request "increment date parameters each run" results in ORA-01861

edited Apr 3, 2014 12:00PM in Core Concurrent Processing - EBS (MOSC) 3 commentsAnswered

Hi,

I have a custom built concurrent program that has a date parameter.  This date parameter has been assigned the FND_STANDARD_DATE value set.  My "ICX: Date format mask" is set to DD.MM.RRRR

When I submit the concurrent request, I was required to enter the date parameter in following format: DD-MON-RRRR, which I did as 25-MAR-2014.  I scheduled the report to run daily and chose the option to increment the date parameter.  For the first request that ran I could see that the date parameter was stored in FND_CONCURRENT_REQUESTS table in the standard canonical format (2014/03/25 00:00:00).  The request completed normally.  However, the subsequent scheduled request that was automatically created, incremented date parameter value correctly by 1 day, but stored the value in FND_CONCURRENT_REQUESTS in the following format: "26.03.2014 00:00:00".  This should not

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center