My Oracle Support Banner

PAXREDRL: The Resource List Alias Name Does Not Allow More Than 30 Characters Based On The Resource Name (Doc ID 2829634.1)

Last updated on DECEMBER 27, 2021

Applies to:

Oracle Project Resource Management - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.8 version, Resource Profile

ACTUAL BEHAVIOR
Resource List Setup -Alias name is not updating correctly based on the resource name. The length of name resource name exceeds more than 30 characters, but Alias name is truncating to 30 characters.


EXPECTED BEHAVIOR
The expectation is that the alias name should not be truncated to 30 characters.


STEPS:The issue can be reproduced at will with the following steps:
1. Use the Projects responsibility
2. Navigate to the Resource form: Setup->Workplan and Progress->Task Priorities
3. Enter an alias with more than 30 characters
4. Verify in the backend that the alias is truncated to 30 characters.

Use the following statement to verify the alias length:
SELECT resource_name,
       length(resource_name),
       alias,
       length(alias),
       a.*
from PA_CHILD_RESOURCES_V a
where length(alias)  = 30
order by 2 desc

 

 



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.