AP-9.2 - Getting An Error While Clicking Geocode Hyperlink In Location Page
(Doc ID 2325621.1)
Last updated on APRIL 27, 2021
Applies to:
PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]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! |
In this Document
| Symptoms |
| Cause |
| Solution |