Hi ,
I’m trying to submit a concurrent program from another concurrent program
the concurrent program i’m trying to call is “Retropay by Element” which is seeded by oracle
by writing the following pl/sql code :
procedure test_run_requests(retcode Out number ,
Errbuf Out Varchar2 ) is
ret number ;
v_msg varchar2(1000);
l_return_code boolean ;
begin
l_return_code := FND_REQUEST.SET_OPTIONS(’N’,’N’);
ret := FND_REQUEST.SUBMIT_REQUEST(application => ‘PAY’
,program => ‘RETROELE’
,start_time => sysdate
,sub_request => false
,argument1 => ‘RETROELEMENT’
,argument2 => ‘eyad’
,argument3 => ‘ÚäÇÕÑ ÇáÊÓæíÉ ÈÃËÑ ÑÌÚí’
,argument4 => to_char(to_date(’01/04/2009’,’dd/mm/yyyy’),’dd/mm/yyyy’)
,argument5 => to_char(to_date(’01/07/2009’,’dd/mm/yyyy’),’dd/mm/yyyy’)
,argument6 => ‘’
);
if ret = 0 then
FND_MESSAGE.RETRIEVE(MSGOUT => v_msg);
else
commit;
end if;
fnd_file.PUT_LINE(fnd_file.OUTPUT,ret||’ test ‘||v_msg);
end;
but it gives an error
here is the part of the log issued
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01722: invalid number
SQL_NO 4640
TABLE_NAME PER_BUSINESS_GROUPS
APP-PAY-06881: Error ORA-01722: invalid number
has occurred in table PER_BUSINESS_GROUPS at location 4640
Cause: an oracle error has occurred. The failure was reported on table PER_BUSINESS_GROUPS at location 4640 with the error text ORA-01722: invalid number
.
Action: Please contact your support representative.
