EXEC FND_CONC_STAT.COLLECT Parameter Appearing in Concurrent Report Output

Problem: After SQL*Plus concurrent job is registered and run, the concurrent job completes in error and the following message appears in the output:

Enter value for 10: EXEC FND_CONC_STAT.COLLECT;
Enter value for 20:
Enter value for 30: EXIT
     peed.start_date between to_date('EXEC FND_CONC_STAT.COLLECT;', 'RRRR/MM/DD HH24:MI:SS') and  to_date('','RRRR/MM/DD HH24:MI:SS')
                                     *
ERROR at line 18:
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Solution: The parameters in the SQL script must be changed from ‘&P_Start_Date’, ‘&P_End_Date’ and ‘&P_Payroll’ to ‘&1’, ‘&2’ and ‘&3’.

That is, the following SQL code:

peed.start_date between '&P_Start_Date' and  '&P_End_Date'
and     peed.payroll_name = '&P_Payroll'

was changed to:

peed.start_date between to_date('&1', 'RRRR/MM/DD HH24:MI:SS') and  to_date('&2','RRRR/MM/DD HH24:MI:SS')
and     peed.payroll_name = '&3'

The first (Start Date) parameter (Concurrent > Program > Define, Parameters) was set up as follows:

Seq: 1
Parameter: 1
Description: Start Date
Enabled: <checked>
Value Set: FND_STANDARD_DATE
Default Type: <blank>
(Validation) Description: Date Value Set
Default Value: <blank>
Range: <blank>
Required: <unchecked>
Enable Security: <unchecked>
Display Size: 11
Concatenated Description Size: 25
Description Size:
Prompt: Start Date:
Token: <blank>

[amazon asin=0596514468&template=iframe image&chan=default]      [amazon asin=0137142838&template=iframe image&chan=default]      [amazon asin=0071614214&template=iframe image&chan=default]

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


This site uses Akismet to reduce spam. Learn how your comment data is processed.