R12/FV: Central Contract Registration Process (CCR) Does Not Update Vendor Information Correctly (Doc ID 2132575.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Oracle U.S. Federal Financials - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

1.  Supplier Site DUNS number does not capture DUNS+4 reference.

When trying to update an DUNS+4 through the Update Assignments Window the SAM
Data Processing Program FND Debug log shows error:

ORA-01422: exact fetch returns more than requested number of rows

2.  Vendor was updated with SAM information (originally loaded from CCR). The address line1 was loaded correctly but did not properly update address line 2 to null it out.   Instead it left the original data in address line 2 and updated data to address line 1.



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