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]
0 Comments.