Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Last date of the month when submitting a concurrent program

edited Jan 8, 2012 2:32PM in Core Concurrent Processing - EBS (MOSC) 4 comments
Hello Experts,

PROBLEM DESCRIPTION
===================
Have a date parameter in a concurrent progrm.
Default Type: SQL Statement
SQL to get last date: select last_day(sysdate) from dual

When submit this program standalone then there is no problem.
For example: Submit on 10-JAN, it will show 31-JAN.
             Submit on 23-JAN, it will show 31-JAN.  

The issue starts when scheduling this program to run once everyday.
When it goes to next month to February, the date value still remains 31-JAN


QUESTION
========
Any suggestion to resolve this type of issue.
Is there any Metalink document can be followed ?

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