FRT Ends in Error When Parsing Tilde-separated Field Having Ampersand Symbol in the Value (Doc ID 3062575.1)

Last updated on DECEMBER 17, 2024

Applies to:

Symptoms

On ORMB v5.1.0.0.0, Fee Rule Templates (FRT) upload ends in error when parsing tilde-separated field having ampersand symbol in the value.

While processing tilde-separated File request feed file through C1-FTRAN batch, a record having one of the field value as "& a p o s ; D a s B e r l i n e r & a p o" (string should be without spaces, we added spaces here so that Oracle Support site will not parse the xml quote character), process went into error with error message as "The reference to entity "apo" must end with the ';' delimiter." and the input feed file remained in pending status in file upload dashboard.

Expectation is FRT must process this tilde-separated line and just accept the value "& a p o s ; D a s B e r l i n e r & a p o" (string should be without spaces, we added spaces here so that Oracle Support site will not parse the xml quote character) in between the tilde-delimiters as-is.

For this, <Patch 36820425> was provided from Product, but post installation of this patch, there are records which contain ampersand symbol that are erroring-out now whereas they were successfully processed previously before the patch. As far as we can tell, those were the fields with either "& A M P ;" or " & A P O S ;" or "& N D A S H ;" (without the in-between spaces which are to prevent this site from formatting as html char) string in the value.

Samples of the new error we are seeing for these records are:
"org.xml.sax.SAXParseException: The entity "AMP" was referenced, but not declared."
"org.xml.sax.SAXParseException: The entity "APOS" was referenced, but not declared."

ERROR
-----------------------
ERROR (com.splwg.ccb.domain.dataManagement.fileRequest.batch.CommonUtil_Impl) Unexpected DocumentExceptionorg.dom4j.DocumentException:
Error on line 1 of document : The reference to entity "apo" must end with the ';' delimiter.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Prepare FRT input file for data to be uploaded/processed
2. FRT configuration with script to run FRT and Pre-processing algorithm
3. Run C1-FTRAN batch

Cause

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