Last updated on DECEMBER 02, 2016
Applies to:Oracle Contract Lifecycle Management for Public Sector - Version 12.1.3 and later
Information in this document applies to any platform.
Supplier Details section showing incorrect DUNS+4 Number and CAGE Code information for CLM documents when a vendor has multiple records in fv_ccr_vendors table. The DUNS+4 Number and CAGE Code of the very first record is shown in the Supplier Details section. The vendor (same DUNS) has multiple records in fv_ccr_vendors table with unique values for DUNS+4 Number and CAGE Code.
Steps To Reproduce
1. Login as federal user
2. Select CLM Purchasing Super responsibilty
3. Create an award
4. While creating award in Address and Suppliers tab, observe the Duns Number, Duns+4, Cage code are not populating properly.
FND log:Return value = ORA-01422: exact fetch returns more than requested number of rows in Package po.plsql.PO_FED_FIELD_FUNCTIONS. Procedure supplier_details_XD: ORA-01422: exact fetch returns more than requested number of rows
Excerpt of the code in the .PO_FED_FIELD_FUNCTIONS. Procedure supplier_details_XD that is causing the error when there are more than one record in fv_ccr_vendors for a given vendor_id.
--<Bug 17483696>Starts:As per FV, for a supplier that is linked to a CCR registration, CCR is the source
--of truth for DUNS, CAGE, TIN, CCR Registration Status, CCR Registration Indicator.
Decode(eft_waiver, 'N', 'Y', 'N')
WHERE vendor_id = x_supplier_id;
In fv_ccr_vendors table a vendor can have multiple records (with different duns+4 and cage codes). So, the above sql fetch into, it will fail when there are more than 1 record.
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