When Adding Item to Requisition Page, Get Error When Quantity is Less Than Minimum Quantity
(Doc ID 3063551.1)
Last updated on DECEMBER 13, 2024
Applies to:
PeopleSoft Enterprise SCM eProcurement - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
When adding item to requisition page, get error when quantity is less than minimum quantity.
The issue can be reproduced at will with the following steps:
1. Navigate : Items > Define Items and Attributes > Purchasing Attributes
Enter Item ID 10000
Click Item Supplier> Item Supplier UOM
Enter Minimum Quantity : 5
Order Quantity Multiples : 5
Save
2. Navigate : eProcurement > Create Requisition
Click Express Entry
Enter Item 10002 Qty : 1
Enter Item 10000 Qty : 3
Click Add
Issue : Receive Error
Think-time PeopleCode event (Warning), but a SQL update has occurred in the commit interval.
WEBLIB_PVMOBILE.PV_ISCRIPT_LIB.FieldFormula Name:AddtoCart PCPC:57456 Statement:839
Called from:PV_MOB_CHK_WRK.PV_ADD_PB.FieldChange Name:AddKitItem Statement:364
Called from:PV_MOB_CHK_WRK.PV_ADD_PB.FieldChange Name:AddMultiItems Statement:517
Called from:PV_MOB_CHK_WRK.PV_ADD_PB.FieldChange Statement:668
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.
Changes
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 |
Changes |
Cause |
Solution |
References |