Using Territory Where Exists Obsolete Record Causing PONAUCT Workflow To Fail (Doc ID 1601721.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Sourcing - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to create RFQ with territory (e.g.) 'Lithunia', the following error occurs in the PONAUCT workflow

ERROR
-----------------------
Error Name -1422
Error Message ORA-01422: exact fetch returns more than requested number of rows
Error Stack Wf_Engine_Util.Function_Call(PON_AUCTION_PKG.POPULATE_ROLE_WITH_INVITEES, PONAUCT, 76651-15675, 812706, RUN)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Change user preference field 'Territory' to Lithunia.
2. Create RFQ
3. Review and Publish it.
4. Check PONAUCT workflow via Status Monitor
5. See error

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