My Oracle Support Banner

EAP: Load SAM File Does Not Update Existing Supplier With New Data If SAM File Has Blank DUNS Number (Doc ID 2886105.1)

Last updated on FEBRUARY 15, 2023

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On the USF_VNDR_XREF table, the DUNS_NUMBER is populated for the USF_UEID and the corresponding VENDOR_ID for a SAM Supplier created from the Maintain SAM Entities page.

As of April 4, 2022, the System for Award Management (SAM.gov) website is no longer populating the DUNS_NUMBER on the SAM File. So, if try to load a SAM File that has a USF_UEID that already exists on the USF_VNDR_XREF table and the DUNS_NUMBER is blank in the SAM file, when the Load SAM file (AP_SAM_LOAD) process runs, the Supplier does not get updated with the changes from the SAM file

The issue is with Step AP_SAM_LOAD.Vendor.AddHdr. Since the DUNS_NUMBER from the USF_VNDR_HDR table is blank but the DUNS_NUMBER from the USF_VNDR_XREF table is populated, the Supplier will not get updated with the changes from the SAM file since the DUNS_NUMBER from both tables are not matching.

STEPS
1. Navigate to Set Up Financials/Supply Chain > Install > Installation > Federal Processing Options
2. Check the boxes for (1) Enable SAM, (2) Suppliers, and (3) Use Taypayer Name for Alternate Withholding
3. Navigate to Suppliers > System for Award Management > Load SAM File
4. Run Load SAM File to load 1st SAM File where UEI and the DUNS_NUMBER are populated
5. Navigate to Suppliers > System for Award Management > Inquire SAM File Load
6. Verify that the file loaded from Step 4 has File Status = Loaded
7. Navigate to Suppliers > System for Award Management > Maintain SAM Entities page
8. Display the UEI loaded from Step 4
9. Verify the DUNS Number is populated
10. Click Create Supplier
11. Click Yes to the question about the Parent UEI does not exist
12. On the SAM Entity Create page, populate the Supplier SetID and Supplier ID
13. Click Create
14. Click Yes to "Are you sure you want to create this supplier?"
15. Click OK to "Supplier(s) were successfully created."
16. Through SQL, verify that on PS_USF_VNDR_XREF, for the USF_EUID that was loaded from the SAM file in Step 4, the VENDOR_ID field is populated with the Supplier ID specified in Step 12 and the DUNS_NUMBER is populated
17. Navigate to Suppliers > Supplier Information > Add/Update > Add/Update Supplier
18. On the Supplier > Identifying Information page, DUNS Number is populated
19. On the Supplier > Address page, Address 1 has the Address from the SAM file
20. Run Load SAM File to load 2nd SAM File where UEI matches the UEI from the 1st SAM file but now, the DUNS_NUMBER is blank and there is a Address change to Address 1
21. On the Inquire SAM File Load page, verify that the file loaded from Step 20 has File Status = Loaded
22. On the Maintain SAM Entities page, click Search
23. In the Search Results, 2 rows exist with the same UEID
  a. One row has the DUNS Number populated (this is the row from the 1st SAM file)
  b. Another row has a blank DUNS Number (this is the row form the 2nd SAM file)
24. Select the row with the blank DUNS NUMBER
25. Confirm that the Address has changed for Address 1
26. Display the Supplier > Address page
27. Notice that Address 1 is not updated to the new Address. The old Address remains.

Changes

 As of April 4, 2022, the System for Award Management (SAM.gov) website is no longer populating the DUNS_NUMBER on the SAM File.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.