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 220.127.116.11 and later
Information in this document applies to any platform.
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:
- Create a new custom section filled with new Extended Attributes.
- Several of these Extended Attributes have the type 'Long Free Text'.
- Attempt to denormalize these sections.
- Notice the problem.
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