My Oracle Support Banner

HTML5 Page With Ajax Async = True - Creates Error (Doc ID 2523942.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Health Insurance Claims Adjudication - Version and later
Information in this document applies to any platform.


On : version, Integration Points

On fee schedule lines, when async is set to false, the files load correctly and in order.
When async is set to true, errors are returned on the POST function.
GEN-ORA-ERR: A database error occurred: "ORA-06533: Subscript beyond countORA-06512

result.responseText 100-<ns0:feeSchedule
 code="FFS_NG_BLUE_B_TEST">result="F">GEN-ORA-ERR: A
 database error occurred: "ORA-06533: Subscript beyond countORA-06512:
at "SYS.DBMS_STATS", line 36873ORA-06512: at "SYS.DBMS_STATS", line
36507ORA-06512: at "SYS.DBMS_STATS", line 35428ORA-06512: at
"SYS.DBMS_STATS", line 33883ORA-06512: at "SYS.DBMS_STATS", line
32254ORA-06512: at "SYS.DBMS_STATS", line 31899ORA-06512: at
"SYS.DBMS_STATS", line 31461ORA-06512: at "SYS.DBMS_STATS", line
31416ORA-06512: at "SYS.DBMS_STATS", line 31293ORA-06512: at

The issue can be reproduced at will with the following steps:
Execute html page from c drive.

Change ajax async method to true on POST (sendToOHI function)

sendToOHI = function(dUrl, FS_Data, success, error, complete)
dAuth = '';
//dAuth = 'Basic U1ZDX0RhdGFJbnRlZ3JhOkRAdGExbnQzMjE='
dAuth = 'Basic U1ZDX1NlcnZpY2VlbnE6UzNydjFjMzEyMQ=='; //SVC_Serviceenq

dUrl1 = dUrl + FS_Data ;
console.log('upload xml ' + FS_Data);
if ('api/generic/referencesheetlines/non_base_codes') > 0 ){
dAuth = 'Basic U1ZDX0RhdGFJbnRlZ3JhOkRAdGExbnQzMjE=';  //svc
dUrl1 = dUrl} ;

//async      : false,
crossDomain: true,
url        : dUrl1, //+ FS_Data ,
async      : true,
method     : 'POST',
data       : FS_Data,
//entity  : verifyResponse,
headers    : {
'Accept': 'application/xml' ,
'Access-Control-Allow-Origin': '*',
'Access-Control-Allow-Methods': 'POST, GET, OPTIONS',
'Content-Type': 'application/xml',
'Authorization': dAuth
success    : success,
error      : error,
complete   : complete


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.