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.