My Oracle Support Banner

Post 21C - Under “Manage Planning Attribute”, the “Source Attribute Reference” LOV is coming Null (Doc ID 2805782.1)

Last updated on SEPTEMBER 09, 2021

Applies to:

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


After 21C Update, under “Manage Planning Attribute” the user reported that “Source Attribute Reference” LOV is null and not able to select any values for “Global” and “Standard” Attributes

Steps to Reproduce:

1. Setup & Deploy DFF under "Manage Descriptive Flexfields"
2. Verify the DFF in the work area like Work Order Header
3. Log into the planning application and click on the Task ‘Manage Planning Attributes" in Plan Inputs work area
4. Create a planning attribute and then click on add in Define Planning attribute mapping
5. Select work order as collection entity from source, and Work order header as entity additional details
6. Global and Standard options are not displayed for selection in Source attribute reference



The Collection Job Set will also Error out at "Planning Attribute" Extract Entity with below Error:


Extract Oracle Fusion Entity ESS process for collections is failing with following error.

MSC_PIMORG_GT lv_stale_stats = 0

MSC_PIMORG_GT After Gather Stats lv_stale_stats = 0

MSC_TRANSORG_GT lv_stale_stats = 0

MSC_TRANSORG_GT After Gather Stats lv_stale_stats = 0

Is Project-Driven Supply Chain enabled = 1

Is Attribute-Based Planning enabled = 1

The Extract Oracle Fusion Entity process started for entity PLANNING_ATTRIBUTE_VALUES with refresh number 15001.

ORA-00936: missing expression

ORA-00936: missing expression

ORA-06512: at "FUSION.MSC_COLL_ATTRIBUTE", line 334






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.