This discussion is archived
1 Reply Latest reply: Nov 22, 2011 9:46 PM by 901700 RSS

OLEDB not able to access

560669 Newbie
Currently Being Moderated
I am executing the below function using

fnd_request.submit_request using the Oracle DataProvider for .NET connection
ending up with the error

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.FND_DATE", line 32
ORA-06512: at "APPS.FND_DATE", line 43
ORA-06512: at line 1
ORA-06512: at "APPS.FND_GLOBAL", line 413
ORA-06512: at "APPS.FND_GLOBAL", line 2272
ORA-06512: at "APPS.FND_GLOBAL", line 2546
ORA-06512: at "APPS.FND_GLOBAL", line 2699
ORA-06512: at "APPS.FND_GLOBAL", line 2636

the code in the function is as below

begin

APPS.FND_GLOBAL.APPS_INITIALIZE(p_user, p_resp_id, p_resp_appl_id);
APPS.MO_GLOBAL.SET_POLICY_CONTEXT('M', 148);

v_request_id := APPS.fnd_request.submit_request(
'INV', 'INCTCW', 'Inventory Transaction Worker',
NULL, FALSE, v_id_val, 3, '','','','','','','','', '','','','','','','','','','','','','','','','','','','','', '','','','','','','','','','','','','','','','','','','','', '','','','','','','','','','','','','','','','','','','','', '','','','','','','','','','','','','','','','','','','','', '','','','','','','','','','');

dbms_output.put_line('Request Id: '||v_request_id);


IF v_request_id = 0 THEN
x_mast_status := 'E';
--x_mast_err_msg := SUBSTR(x_mast_err_msg ||' '||'Error submitting request.', 1, 240);
x_mast_err_msg := SUBSTR(x_mast_err_msg ||' '||'Error on Insert. '||sqlerrm, 1, 240);
dbms_output.put_line( x_mast_err_msg);
end if;

end;

any suggestion will help me out.

Regards
Yram

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points