My Oracle Support Banner

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

Last updated on MARCH 29, 2019

Applies to:

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

Symptoms

On :  3.18.3.0.0 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.
 
ERROR
-----------------------
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
"SYS.DBMS_STATS", line



STEPS
-----------------------
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 (dUrl.search('api/generic/referencesheetlines/non_base_codes') > 0 ){
dAuth = 'Basic U1ZDX0RhdGFJbnRlZ3JhOkRAdGExbnQzMjE=';  //svc
dUrl1 = dUrl} ;

$.ajax({
//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
});
}

Cause

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
Symptoms
Cause
Solution
References


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