My Oracle Support Banner

12.2.7 ENCACNC -ECO Implementation Fails With Errors "GLOBAL_ATTRIBUTE40" invalid identifier (Doc ID 2447460.1)

Last updated on JANUARY 07, 2020

Applies to:

Oracle Product Hub - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On 12.2.7 environment , Engineering Change Order implementation fails with the following errors:

ERROR

Logfile shows : Rollback to IMPL_REV_ITEM_ATTR_CHGS Item Attribute Change Implementation
 When Others Exception -904/ORA-00904: "B"."GLOBAL_ATTRIBUTE40": invalid identifier
 After Calling impl_rev_item_attr_changes, Return Status: U
 When G_EXC_ERROR Exception in impl_item_changes



STEPS
The issue can be reproduced at will with the following steps:

  1. Navigate PIM responsibility
  2. item adv. search > download in excel via webadi >
  3. update lead times for 2-3 items > upload > create ECO during upload >
  4. Approve ECO > Implement ECO > Program Fails

 

BUSINESS IMPACT
The issue has the following business impact:
Upgrade from 12.1.3 to 12.2.7, currently impacting UAT and the GO- Live.



Changes

 

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
Changes
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.