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’.
Recent Comments