Error When Accessing Account WSDL: Max Number Of Scripts Using New View (Doc ID 2166829.1)

Last updated on AUGUST 14, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0 version, Accounts, Contacts, Households

Error When Accessing Account WSDL: Max Number of Scripts Using New View

I get the following error from our integration:

2016-07-22 10:13:30.921 IW 2.41 TS OSCAcct2DBGS HTTP go: Query executed; Result= env:ServerJBO-25184: Exception in expression "OrganizationDVO" object function getEnterpriseTrainedClinicians() : oracle.jbo.ExprResourceException JBO-25172: Expression exceeded the maximum number of 20 active scripts using new view instances.25184JBO-25184: Exception in expression "OrganizationDVO" object function getEnterpriseTrainedClinicians() : oracle.jbo.ExprResourceException SEVERITY_ERROR25172JBO-25172: Expression exceeded the maximum number of 20 active scripts using new view instances.SEVERITY_ERRORoracle.jbo.ExprResourceException020truetrueLastUpdateDate BETWEEN 2016-07-21T17:55:48.000Z4999-01-01T00:00:00.000ZSalesAccountResourcetrueoracle.jbo.script.ExprScriptException

I have done a count of the scripts doing this, and if all were invoked at the same time, they would total 16, and there are no redundant calls in my code. Is there maybe something about scripts calling scripts that call for a new view counting as 2?

This is causing two of our integration flows to not work.

ERROR
-----------------------
2016-07-22 10:13:30.921 IW 2.41 TS OSCAcct2DBGS  HTTP go: Query executed; Result= env:ServerJBO-25184: Exception in expression "OrganizationDVO" object function getEnterpriseTrainedClinicians() : oracle.jbo.ExprResourceException JBO-25172: Expression exceeded the maximum number of 20 active scripts using new view instances.25184JBO-25184: Exception in expression "OrganizationDVO" object function getEnterpriseTrainedClinicians() : oracle.jbo.ExprResourceException SEVERITY_ERROR25172JBO-25172: Expression exceeded the maximum number of 20 active scripts using new view instances.SEVERITY_ERRORoracle.jbo.ExprResourceException020truetrueLastUpdateDate BETWEEN 2016-07-21T17:55:48.000Z4999-01-01T00:00:00.000ZSalesAccountResourcetrueoracle.jbo.script.ExprScriptException



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Call the Web Service for account.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot invoke account Web Service

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms