Supplier Details Section Showing Incorrect DUNS+4 Number And CAGE Code Information For CLM Documents (Doc ID 2210191.1)

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.

Symptoms

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.


SELECT Taxpayer_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.
  duns,
  plus_four,
  cage_code,
  Decode(eft_waiver, 'N', 'Y', 'N')
  INTO l_tin_num,
  p_duns_num,
  p_duns_4_num,
  p_cage_code,
  p_eft_indctr
  --<Bug 17483696>Ends
  FROM FV_CCR_VENDORS
  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.

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