Form Validation Does Not Check Field Length for Fields in BO_DATA_AREA (Doc ID 1673515.1)

Last updated on JUNE 14, 2017

Applies to:

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

Goal

The goal of this article provides details why a Form validation does not check Field length for fields in BO_DATA_AREA.

Replication Steps:
--------------------
Attempt to add a Registration Form via XAI having a long name.

BO for the Registration Form: C1-BusinessRegistrationForm has the following schema section:

  
It maps to the BO_DATA_AREA. The name is mapped to field ENTITY_NAME which has length of 64.
 
Try to import a registration Form via XAI having an owner name larger than 64 chars and see how the form validation bypasses this issue and the form gets posted normally.

Add a new XAI Inbound Service using BO C1-BusinessRegistrationForm (CM-BusinessRegistrationForm-test)
From Admin menu, XAI Submission, submit the a request to add a registration form.

Notice the length of the following name fields in the request:
Owners / Responsible Parties (68 chars) - longer than 64 chars
USER55, RP 123456789012345678901234567890123456789ABCDEFGHIJKLMNOPQR

Navigate to the created Registration Form
Owners / Responsible Parties Name displayed on the form: 68 chars displayed (same as in xml request)
Click Validate on the Form:
The problem is here! No validation error is raised due to the long Owners / Responsible Parties Name.
Post the form.
Go to the created Owner / Responsible Party person:
Notice the name has been truncated and only 64 chars were saved
 

Solution

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