Collection of Supplier Site Data Fails With an Error:- Location cannot be null
Last updated on FEBRUARY 13, 2017
Applies to:
Oracle Fusion Order Management Cloud Service - Version 11.1.11.1.0 and laterOracle 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 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)
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