My Oracle Support Banner

URL Is Being Truncated When Display Letter Button Is Clicked From The Customer Contact Page (Doc ID 1671717.1)

Last updated on AUGUST 24, 2020

Applies to:

Oracle Public Sector Revenue Management - Version and later
Information in this document applies to any platform.


In the Customer Contact page, when the Display Letter button is clicked, the generated URL is being truncated to 200 characters. When the actual value is checked in the database (CI_CC.C1_CC_DATA_AREA), the actual URL length is larger (for example 338 chars).

Current URL redirection when pressing the display letter button(incomplete)

Customer Contact Data Area URL (Complete URL)

From both URLs (complete and incomplete), it is possible to generate the letters. Although the incomplete URL does not have all parameters, at least it has one parameter (in this case P_TAXFORM_ID) for data extraction. So it gets generated with some information while other related info to the missing parameter appear in blank.

Upon copying the complete URL to the browser the address field, the letter gets generated as expected.

The issue can be reproduced at will with the following steps:
1. Go to Customer Contact page
2. Click Display Letter button
3. check the URL generated
4. compare with the DB: select * from cisadm.ci_cc where cc_id='xxxxxxxxxx', see the contents of field C1_CC_DATA_AREA. it shows the following biPublisherURL. notice the difference in length




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

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