My Oracle Support Banner

Getting An Error While Clicking Geocode Hyperlink In Location Page (Doc ID 2325621.1)

Last updated on NOVEMBER 07, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Error while clicking the Geocode hyperlink from location page:

 

Steps:
---------
1. Navigate to  Setup Financials > Common Definition  >Location > Location

2. On Location Definition tab enable vertex.

3. Error occur:

Think-time PeopleCode event (EvalDoModal), but a SQL update has occurred in the commit interval. (2,148) SCM_TAX.Geocodes.InteractiveGeoResolver.OnExecute Name:Resolve PCPC:399 Statement:9
Called from:SCM_TAX.Geocodes.GeocodeFinder.OnExecute Name:SelectUpdate Statement:5
Called from:SCM_TAX.Geocodes.GenericImpl.GenericGeoFinder.OnExecute Name:Lookup Statement:78
Called from:FUNCLIB_TAX.GEO_CODE.FieldFormula Name:tax_geocode Statement:59
Called from:TAX_WRK.GEOCODE_LOOKUP_PB.FieldChange Stateme

Think-time PeopleCode events such as messages requiring a user response cannot be executed if a SQL update, insert, or delete has occurred in the commit interval. Examples of PeopleCode that invoke update type of SQL includes Process Scheduler, TriggerBusinessEvent, or MarkWorked. A unit of work cannot contain both think-time events and update type SQL.

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!


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