URL Is Being Truncated When Display Letter Button Is Clicked From The Customer Contact Page

(Doc ID 1671717.1)

Last updated on OCTOBER 18, 2016

Applies to:

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

Symptoms

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).

Examples:
Current URL redirection when pressing the display letter button(incomplete)
http://xxx.xx.x.xxx:xxxx/xmlpserver/LT/TXLR_CRLTR/TXLR_CRLTR.xdo?_xpf=&_xpt=0&_xdo=%2FLT%2FTXLR_CRLTR%2FTXLR_CRLTR.xdo&_xt=TXLR_CRLTR_BASE&_xf=pdf&_xmode=3&P_TAXFORM_ID=671227112890&P_CONTROL_SEQ=0000

Customer Contact Data Area URL (Complete URL)
http://xxx.xx.x.xxx:xxxx/xmlpserver/LT/TXLR_CRLTR/TXLR_CRLTR.xdo?_xpf=&_xpt=0&_xdo=%2FLT%2FTXLR_CRLTR%2FTXLR_CRLTR.xdo&_xt=TXLR_CRLTR_BASE&_xf=pdf&_xmode=3&P_TAXFORM_ID=671227112890&P_CONTROL_SEQ=0000%2F2014%2F000006&P_USER_ID=MLACANIA&P_REPORT_CD=TXLR_CRLTR&P_CUSTCONTACT_ID=0043391382

 
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.

STEPS
-----------------------
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


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms