Getting An Error While Clicking Geocode Hyperlink In Location Page
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.
Error while clicking the Geocode hyperlink from location page:
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.
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