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.
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.
ORA-01427: single-row subquery returns more than one row
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms