Skip to Content
0
Former Member
Jul 14, 2016 at 03:58 PM

Import Enterprise Workbook - This field is required and must have a valid value. [TIME_ZONE].

52 Views

Hello everyone,

I am currently using SAP Sourcing 10 and am trying to upload the Enterprise_QuickStart workbook. Unfortunately, in the companies tab, TIME_ZONE is mandatory and I am getting the following error:

# Record 3. Warning: An error was encountered in column TIME_ZONE which had the value (GMT+5:30): The specified value for field TIME_ZONE was not found in the list of values: (GMT+5:30)

# Failed: object 3: This field is required and must have a valid value. [TIME_ZONE].

I have tried all sorts of values to make this upload work:

EST

GMT

(GMT-5:00) Eastern Standard Time

GMT-5:00

"(GMT-5:00) Eastern Standard Time"

Eastern Standard Time

To no avail.

It also says in the excel:

# Field: # TIME_ZONE

Type: VLV Reference

Required: true

Notes: References the DISPLAY_NAME field of a Value List Value for type 16 (ODP_TIME_ZONE)

I have also tried configuring value_list_types and value_list_values to manually create customized entries in order to enable the upload to no avail.

Please see attached sample file from me, I have tried alot of different combinations but none have worked.

Really hoping for your kind assistance.