CLM: 'Generate XML File for EDA' Concurrent Program Fail With Error "ORA-01427: Single-row Subquery Returns More Than One Row" (Doc ID 2037523.1)

Last updated on AUGUST 02, 2015

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.2.2 and later
Information in this document applies to any platform.
POEDAXML.xml

Symptoms

On : 12.2.2 version, Award/PO

When attempting to use the concurrent program 'Generate XML File for EDA' (POEDAXMLGEN) to generate an XML file for a contract out of Contract Lifecycle Management (CLM), receive the following error and it fails to generate the entire file.

The happens consistently on awards to a vendor  with multiple rows in FV_CCR_VENDORS.
This table apparently stores data from CCR vendor extracts, and has the possibility of multiple records
for the same vendor apparently due to multiple addresses.


ERROR
-----------------------
ORA-01427: single-row subquery returns more than one row


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create award
2. Submit 'Generate XML File for EDA' (POEDAXMLGEN) from 'Requests' window

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