Receiving the following error when submitting Services Procurement requisition, Invalid message while SQL transaction in process: Allocate the changed amount based on the split distribution? (10200,397) (2,178) (Doc ID 2192079.1)

Last updated on DECEMBER 13, 2016

Applies to:

PeopleSoft Enterprise SCM Services Procurement - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

Services Procurement (sPro) Requisition (req) receives error when clicking between pages


ERROR
-----------------------
Invalid message while SQL transaction in process: Allocate the changed amount based on the split distribution? (10200,397) (2,178)
FUNCLIB_REQ.DISTRIB_UPD.FieldFormula Name:balance_dists PCPC:2335 Statement 45

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a new sPro req with expenses allowed
2. Review and Submit
3. Click Add Items and Services tab
4. Unselect Allow Expenses
5. Review and Submit

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