Skip to main content

AP Supplier Address FBDI Import Error: FBDI Supplier Address Import Returns Error: The Address Is Not Valid. At Least One Of The Address Attributes Failed Validation. (Doc ID 2210891.1)

 Scenario:

When we are trying to create supplier address through FBDI Templates system is not creating the address and throwing error.




Symptoms: 

Import Supplier Address

Unable to Create Supplier Address through Import. Process fails.
The FBDI Supplier Addresses Import Report returns the following reason:
Address not imported
Interface ID = XX
Import Action = CREATE
Supplier = <Supplier Name>
Address Name = <Country>-<State>-<City>-<County>
Reject Reason = The address is not valid. At least one of the address attributes failed validation. Review the address format and Geography setup for more details.


Steps to Reproduce the Error:


1. Populate the Import Supplier Address template (PozSupplierAddresses.zip)
2. Run Load Interface File for Import
3. Review Supplier Addresses Import Report
Notice that the import has failed
The reason is:
'The address is not valid. At least one of the address attributes failed validation. Review the address format and Geography setup for more details. '

Cause:

This error message is displayed when Geography Validation is enabled for the Country, but the correct values for Geography Fields ( in this case Country, State, City, County)  were not correctly provided in the template (for example, user did not populate the fields in the template) or the combination provided in the template is being checked against Manage Geography Hierarchy and it is not a valid combination in Manage Geography Hierarchy.
 
The user must review their Manage Geographies  Setup and provide valid combination of  Geography fields (in this case Country, State, City, County) in the template or load the combination of fields in Manage Geography Hierarchy prior to execute the import.

Solution:

 To check if Geography Validation is enabled

  1. Go to Setup and Maintenance
  2. Search for task 'Manage Geographies'
  3. Search by Country code = 'Country'
  4. Select the line returned for the Country > then  Actions menu > then  Manage Geography Validation. Review the value of the field Geography Validation Level for Country value. If it does not show None, it means that Geography Validation is enabled. 

To check Geography Validation Setup/Required fields

  1. Go to Setup and Maintenance
  2. Search for task 'Manage Geographies'
  3. Search by Country code = 'Country'
  4. Select the line returned for the Country > then  Actions menu > then  Manage Geography Validation.
  5. Review Geography Mapping and Validation section to determine what fields are required (Geography Validation column)

To check if the Geography Combination provided in the template is a valid combination/exists in Manage Geography Hierarchy.

  1. Go to Setup and Maintenance
  2. Search for task 'Manage Geographies'
  3. Search by Country code = 'Country'
  4. Select the line returned for the Country > then  Actions menu > then Manage Geography Hierarchy.
  5. Review Manage Geography Hierarchy data to determine if the combination provided in the template is a valid geography combination. For example, in this case the combination of Country, State, City, County values provided must exist.





Comments

Post a Comment

Popular posts from this blog

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more