My Oracle Support Banner

FA: SCM: GOP: Collect Planning Data - ESS Process Fails With: Location cannot be null (Doc ID 2233185.1)

Last updated on MARCH 12, 2021

Applies to:

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


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:

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)




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.