This discussion is archived
0 Replies Latest reply: Sep 9, 2011 6:44 AM by 874471 RSS

Error while creating SR using CS_ServiceRequest_PUB.Create_ServiceRequest

874471 Newbie
Currently Being Moderated
Hi All,
I am getting below error while creating an SR from the backend using API 'CS_ServiceRequest_PUB'.

Error:
"
API Programming Error (CS_ServiceRequest_PUB.Create_ServiceRequest): An error occurred when validating the descriptive flexfield.
Additional information:Program error: Please inform your support representative that:

FLEXFIELDS SERVER-SIDE VALIDATION package reports error:

validate_desccols() exception: ORA-20005: DVLB.get_default_context() failed. SQLERRM: ORA-01403: no data found
ORA-06512: at "APPS.FND_FLEX_DESCVAL", line 931
ORA-01403: no data found
Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

"

I have intialised the context as below while running the stand alone procedure in SQL Developer.

Fnd_Global.apps_initialize (user_id => 1368347,
resp_id => 21739
resp_appl_id => 514 );


We are on 11.5.10.2 and database version is 9i.

Can you please help??

TIA,
S

Legend

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