Unable to set Preferred Ordering Method to NULL

[a648598]

Hi All,

I am trying to set the Preferred Ordering Method of a Supplier Location to NULL or empty so the new Supplier Location we have uploaded is defaulted as Contact during transaction creation.

I’ve seen 2 Knowledge Base from Connect, telling that setting the field as NULL (all caps) is supposed to work. I also tried to delete first and update the Master Data Default values from “Printing” to “No Choice” before re-loading the SupplierLocationConsolidated.csv, but still not working. I even tried zipping the file and upload via Import Batch (Deactivate first, then Load option) but same result, POM = Printing).

If anyone has any idea on how I can nullify this field via file upload, without doing FULL LOAD (Load & Delete), that would be great.

*********Knowledge Base from Ariba Connect

KB0405045 - How to update a field value as null through import?

Add to FavoritesSave for LaterEmail

FAQAPPLIES TOATTRIBUTESLANGUAGES (10)

Activate item to go to section in page

Symptom

How to remove a field value/update it as null through import?

Resolution

Update the field value in the .csv file to NULL.

Note that NULL value must be in all capital letters. Sending null or empty/blank value in the field column of the import will not remove the existing value.

Applies To

• Core Procurement > Core Administration > Core Administration Import/Export

Attributes

Created:

14 Mar 2023

Edited:

14 Mar 2023

Personas:

Admin, Buyer

From <https://connectsupport.ariba.com/sites#item-view&/KB0405045>

=========

KB0393377 - What does the Allow Null column represent in the data dictionary?

Add to FavoritesSave for LaterEmail

FAQAPPLIES TOATTRIBUTESLANGUAGES (10)

Activate item to go to section in page

Question

What does the Allow Null column represent in the data dictionary?

Answer

The following chart shows all of the possible combinations of values for the Required and Allow Null columns in the data dictionary:

Required

Allow Null

Meaning

true

Yes

You can specify null values in the column.

true

No

Null values are not allowed in the column; you must use at least a blank string.

true

?

Null values are not allowed in the column; you must use at least a blank string.

false

Yes

You can specify null values in the column.

false

No

Null values are not allowed in the column; you must use at least a blank string.

false

?

You can specify null values in the column.

?

Yes

You can specify null values in the column.

?

No

Null values are not allowed in the column; you must use at least a blank string.

?

?

Null values are not allowed in the column; you must use at least a blank string.

For example, the Export Plants Data task shows that the CompanyCode.UniqueName column is required, but Allow Null is blank for this column.

To clarify blank strings versus the existence of a column, blank strings are considered valid values during data import tasks, so you can think of this as the column existing. However, if you were to upload a blank string for the UniqueName column, you would receive an error message because there's no matching entry to update. The data dictionary does not take your master data values into consideration when stating whether something is required or not.

Keep in mind that when the Allow Null column is set to "Yes" for a column, you have the option to enter "NULL" in all capital letters in order to blank out a value for a given entry. If Allow Null is set to "No" for the column, you do not have this option.

Additional Information

For the full description of columns in each data dictionary worksheet, see the Administration and Data Maintenance Fundamentals Guide.

Applies To

• Catalog Management
• Core Procurement > Core Administration > Core Administration Import/Export
• Invoicing

Attributes

Created:

31 Jul 2012

Edited:

02 Apr 2022

Personas:

Admin, Buyer

From <https://connectsupport.ariba.com/sites#item-view&/KB0393377>

Regards,

Oyie