PO 9.1 Brazilian Localization: Error PeopleCode When Log has More than 100 Messages (Doc ID 2043963.1)

Last updated on AUGUST 13, 2015

Applies to:

PeopleSoft Enterprise FIN Purchasing Brazil - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

PeopleCode error when saving an electronic invoice

When saving Fiscal Document with more than 100 log messages error.

Got the error message:

ERROR
“Think-time PeopleCode event (Warning), but a SQL update has occurred in the commit interval. (2,148) FUNCLIB_PBL.VALIDATION_NF_PBL.FieldFormula Name:InsRecvLog PCPC:648 Statement:11
Called from:FUNCLIB_PBL.MATCH_VALID_PBL.FieldFormula Name:Pop_NFE Statement:23
Called from:FUNCLIB_PBL.MATCH_VALID_PBL.FieldFormula Name:Pop_rcv_po Statement:264
Called from:NF_HDR_BRL.BUSINESS_UNIT.SavePreChange Statement:25

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.”



STEPS
The issue can be reproduced at will with the following steps:
1 - Create a PO with more than 100 lines. Approve, Validate KK and Dispatch.
2 - Receipt PO as Eletronic Fiscal Document
3 - Create Fiscal Doc with Receipt
4 - Save. Got the message
“Warning -- There are too many errors at Fiscal Doc. Not all errors will be displayed. (30000,331)
There are too many errors at this Fiscal Document. Not all of them
will be displayed. Correct some of them and validate the document again.”

5 - OK to 'Warning - Check the log Messages (30000,215)
6 - OK for log messages
7 - Got the message:
“Think-time PeopleCode event (Warning), but a SQL update has occurred in the commit interval. (2,148) FUNCLIB_PBL.VALIDATION_NF_PBL.FieldFormula Name:InsRecvLog PCPC:648 Statement:11
Called from:FUNCLIB_PBL.MATCH_VALID_PBL.FieldFormula Name:Pop_NFE Statement:23
Called from:FUNCLIB_PBL.MATCH_VALID_PBL.FieldFormula Name:Pop_rcv_po Statement:264
Called from:NF_HDR_BRL.BUSINESS_UNIT.SavePreChange Statement:25

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

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