My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.