My Oracle Support Banner

CP Query By Buyer Name Errors With "Too Long" In Horizontal View (Doc ID 2426616.1)

Last updated on AUGUST 19, 2019

Applies to:

Oracle Collaborative Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Horizontal View in PROD

Users are on 12.1.3 and have applied VCP 12.1.3.3 Patch 10389190 - Users are querying by Buyer in CP Horizontal View. However for some buyer names over 25 characters the query returns the following error:

ERROR
-----------------------
Form validation failures:
Value "Buyer_last_name, Buyer_first_name (Buyer Name)" in "Buyer" is too long

Users have file version MSC_HZ_ADV_SEARCH_MAIN.xml 120.1

This is the exact same issue for 11.5.10 in note 754943.1 - When The Name Of The Buyer Is Very Long,The Search Of CP Home Give An Error - Bug 7434764 - WHEN THE NAME OF THE BUYER IS VERY LONG,THE SEARCH OF CP HOME GIVE AN ERROR - The fix was created for file MSC_HZ_ADV_SEARCH_MAIN.xml 115.7.11510.3

The maximumm length of buyer field is seeded as 25 characters in the XML page for Advanced Horizontal Search. In ARU there is only one R12 apps version MSC_HZ_ADV_SEARCH_MAIN.xml 120.1 and it shows the problem as it limits max length to 25 characters too

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Query by Buyer in CP horizontal view with buyer name > 25 characters
2. Error occurs

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
References


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