My Oracle Support Banner

Complex Purchase Order Gets Error Po.plsql.PO_VALIDATIONS.VALIDATE_SET.-110: C_SHIP_QTY_EXEC ORA-1422 (Doc ID 2582445.1)

Last updated on FEBRUARY 19, 2021

Applies to:

Oracle Services Procurement - Version 12.2.7 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Purchase Order Related

Complex PO error po.plsql.PO_VALIDATIONS.VALIDATE_SET.-110: C_SHIP_QTY_EXEC ORA-1422

Receiving error message when trying to update Complex PO Line amount.


ERROR
-----------------------
po.plsql.PO_VALIDATIONS.VALIDATE_SET.-110: C_SHIP_QTY_EXEC ORA-1422




STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. PO Buyer > Buyer Work Center > Orders
2. Query the PO# XXXXX
2. Choose Update from dropdown & click on GO
3. Go to Lines tab
4. Select Line#3, change amount and click on save.
5. User ended up error.

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.