Collection of Supplier Site Data Fails With an Error:- Location cannot be null (Doc ID 2233185.1)

Last updated on FEBRUARY 13, 2017

Applies to:

Oracle Fusion Order Management Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Global Order Promising - Version 11.1.11.1.0 and later
Information in this document applies to any platform.
***KM Review - Dec 2016 - Checked for Relevance***

Symptoms

Supplier Collections fails, the collection initiates a number of ESS sub processes including, Supplier_Site_Collections. The Collections log file shows errors;

Location cannot be null

Location Collection fails with:

Invalid country_code.

 The issue can be reproduced by executing the following steps:

1. Navigate to Setup and Maintenance (FSM)
2. Search for and select the task - Collect Planning Data
3. Collect Supplier data for Source System - Fusion (generally - OPS)

The collection error can be verified by examing the staging tables for:

MSC_LOCATIONS

MSC_ST_GLOBAL_TRADING_PARTNERS

NOTE: Executing SQL using BI in a Cloud Environment is described in - Fusion Applications BI Publisher : How Can I Use BI Publisher to Run SQL Against the Fusion Applications Database ? (Doc ID 1910762.1)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms