My Oracle Support Banner

21D Release: The User-defined Measure FBDI Load for Sales & Operations Planning Is Failing with the Validation Message “SOR_LVL_MEMBER_NAME is invalid” (Doc ID 2832295.1)

Last updated on MAY 06, 2022

Applies to:

Oracle Sales and Operations Planning Cloud Service - Version 11.13.21.10.0 and later
Information in this document applies to any platform.

Symptoms

 After 21D upgrade, when loading measure data via the Supply Chain Planning Measures FBDI template (ScpMeasuresImportTemplate.xlsm), the load will fail if the following condition occurs:

1. The SOR_LVL_NAME column contains “Sales Rep” and the SOR_LVL_MEMBER_NAME column is populated with a Sales Rep that was collected via the Supply Chain Planning User-Defined Hierarchy FBDI template (ScpUser-DefinedHierarchyImportTemplate.xlsm) and not from the Fusion source (CX).
2. The error will state “Invalid SOR_LVL_MEMBER_NAME”.

Steps to reproduce:
1. Fill Template ScpMeasuresImportTemplate.xlsm having SOR_LVL_NAME and SOR_LVL_MEMBER_NAME column populated
2. Run Load Planning Data from Flat Files

Cause

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
Symptoms
Cause
Solution
References

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