E-AWE:INTERMITTENT DUPLICATE EOW_IDS INSERTED INTO PS_EOAW_USERINST (Doc ID 2220556.1)

Last updated on JANUARY 05, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.

Symptoms

ENVIRONMENT
=============
Environment: Unknown
PT 8.53.25
FSCM 9.2
Microsoft Windows x64 (64-bit) 7

When users try to approve approval requests, sometimes they got the following error.


ERROR
=======
A fatal PeopleCode SQL error occurred. Please consult your system log for details.

Am error occurred while taking action on the purchase order. The following error occurred when calling DoApprove(): at Approval process instance (is = 'SUP_OB_SUPPLIER', Definition ID = 'MCCCD', Effective date '1901-01-01'. Thread id '24795') (18081, 1056):20:1, Step nbr 1 (18081, 1058) EOAW_CORE_ENGINE DefStepInst. OnExecute Name PCPC:9708 Statement: 145
Called from: EOAW_CORE.ENGINE.PathInst.OnExecute Name:Launch Statement:74
Called from: EOAW_CORE.ENGINE.StageInst.OnExecute Name:InnerLaun

This error occurrs when another program (typically another user working in a separate session) updates the data object this process wished to change. Retrying the same operation after refreshing the display is likely to work, provided the other used`s changes haven`t precluded it.



STEPS
======
The issue can be reproduced at will with the following steps:
1. Try to approve a requisition, voucher or supplier


BUSINESS IMPACT
=================
The issue has the following business impact:
Due to this issue, customer is not able to go further with the testing process as this is holding lots of items.

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