My Oracle Support Banner

Form Validation Does Not Check Field Length for Fields in BO_DATA_AREA (Doc ID 1673515.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.


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


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.