Location Import Errors Report

Purpose: Use the Location Import Errors Report to review errors related to locations that occurred during the import into Order Broker Cloud Service using the process described under Importing Locations. You can schedule imports or run them on demand through the System Import Schedule screen.

Successfully imported locations not listed: Only location import records that resulted in error are listed on the report. For example, if the import process included 500 locations, and 495 locations were created or updated without error, the report lists the 5 errors.

Invalid address? The import process creates a location record even if the address specified in the import file is incomplete or invalid. In this case, the location is not listed on the errors report. If the location is not included as expected in inventory search results or order assignments, you can use the Edit Location to verify or correct the address.

Correcting import errors: See Understanding location import errors for more information.

Database table: The errors listed on this report are from the location_import table. Records in that table with a processed code of 40 are not included in the report, as these updates processed successfully.

For more information: See Importing Locations.

Used for the Routing Engine module.

How to generate this report: Available if Use Routing Engine is selected at the Tenant screen. At the Run Reports screen:

1.      Click the plus sign next to the Operations folder in the left-hand navigation pane.

2.      Highlight the Location Import Errors Report. The center of the screen displays the related Report Options.

3.      Select:

•         Organization: The organization to include on the report. Defaults from the organization associated with the Default Shipping System from your user profile, but you can override this default.

•         Date range: Select either:

•         Rolling Dates: One of the date ranges available from this field to include location imports that failed during this range of dates. See Rolling Dates for more information; or,

•         From and To dates: Enter or select the first and last dates to include. The report includes location imports that failed during this range of dates. The From and To dates can be the same, and can be the current date.

Note: If the error occurred earlier than the Days to Keep Errors specified at the System Import Schedule screen, it is not retained in the table or eligible to print on the report.

•         Export to PDF: Select this option to generate a PDF version of the report that you can review in a PDF viewer.

•         Export to Excel: Select this option to generate the report in .XLS format, which you can open in a spreadsheet application.

Note:             You must select either Export to PDF or Export to Excel, or both.

•         Email List: Optionally, enter one or more valid email addresses, separated by semicolons (;), to receive the report.

Note:             If you select both Export to PDF and Export to Excel, each email recipient receives two separate emails, each with a version of the report attached.

4.      Click Run Report.

For more information: See Viewing generated reports.

Contents:

•         Organization Name and report title

•         Report Criteria heading:

•         Locations: All.

•         Date Range: The range of dates entered at the Run Reports screen, or calculated based on the Rolling Dates selection at the Run Reports screen or the Schedule Report window.

•         Import ID. Each import ID starts on a new page.

•         System code

•         For each error with the same Import ID:

•         Location code: The location to import from the external system.

•         Location type: The location type assigned to the location, describing one or more locations within an organization. Each location type indicates the location category (store, warehouse, or vendor), and can also provide additional information, such as “East Coast Stores” or “Outlet Stores.”

•         Name: The name of the location.

•         City: The city for the location’s address.

•         State: The state for the location’s address.

•         Postal: The postal code for the location’s address.

•         Country Code: The country code for the location’s address.

•         Error: See Understanding location import errors.

The footer on each page of the report lists:

•         the date and time when the report was generated

•         the current page number and total number of pages (for example, Page 1 of 6)

Understanding location import errors

Note:             No errors are listed on the report if, for example, the number of columns in the flat file is invalid, the setting of one of the preference fields is not set to Y, N, or blank, or the length of a field exceeds the maximum length in the database. In this case, a general error is listed at the System Imports History screen. See Importing Locations for background.

________________________________

Copyright © 2018, Oracle and/or its affiliates. All rights reserved.
Legal Notices