My Oracle Support Banner

Groovy Script : How to Filter Inactive Organizations (Doc ID 2429827.1)

Last updated on NOVEMBER 08, 2019

Applies to:

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

Symptoms

 User has groovy script to get to get a value from an attribute but does not want to include soft-deleted parties.

def vo = newView('OrganizationProfile')
def as400Id = getAttribute('as400Id_c')
vo.appendViewCriteria("as400Id_c = '${as400Id}' and StatusCode = 'A'");
vo.executeQuery()
def rowCount = vo.getEstimatedRowCount();
println(String.valueOf(rowCount));

 

ERROR

Exception in expression "oracle.apps.cdm.foundation.parties.publicModel.organizations.entity.OrganizationDEO" trigger "DuplicateAccount" : oracle.jbo.expr.JIMultipleSyntaxErrors Failed to build ViewCriteria from expression"as400Id_c = '120270' and StatusCode = 'A"' using view object OrganizationProfile_1 at "oracle.apps.cdm.foundation.parties.publicModel.organizations.entity.OrganizationDEO" trigger "DuplicateAccount" line 3

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


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