Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue with DUNS Number field when Importing the Supplier

Summary:

We have Identified a very weird Oracle Behavior while importing our suppliers through FBDI into Production instance.

We have importing around 23K suppliers into Oracle and notice that D-U-N-S Number field is Auto Populating when left blank in the below scenarios.


1. D-U-N-S Number is getting Auto populated with the supplier number prefix with adding zero. For example: if supplier number is #1016043, then DUNS number updated by system is #001016043.

2. D-U-N-S Number auto adjusting, when 7 digit DUNS number was provided system auto added zero's in the beginning to make it a 9 digit number.


Interestingly, this auto adjustment and auto update has happened only for suppliers whose TAX Payer ID was present at the time of import.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!