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:

Symptoms

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

Location Collection fails with:

 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)

Changes

Cause

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