My Oracle Support Banner

Denorm Issue With "Long Free Text" Fields (Doc ID 2484500.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Agile Product Lifecycle Management for Process - Version 6.2.2.0 and later
Information in this document applies to any platform.

Symptoms

Using 6.2.2 and created new Custom Sections filled with new Extended Attributes. Several of these Extended Attributes have the type 'Long Free Text'. When attempting to denormalize these sections for performance and reporting reasons, the script fails on the 'Long Free Text' fields. They display XX!!XX before their field name, and their data type is processed as 'Long Free Text' instead of a valid SQL data type.

Steps to reproduce:

  1. Create a new custom section filled with new Extended Attributes.
  2. Several of these Extended Attributes have the type 'Long Free Text'.
  3. Attempt to denormalize these sections.
  4. Notice the problem.

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


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