My Oracle Support Banner

CopyToIntakeRecordFields Attached Rule Fails When Attached To Intake Record Transaction (Doc ID 2527570.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Insurance Policy Administration J2EE - Version and later
Information in this document applies to any platform.


On : version, General

Intake Record processing transaction fails when CopyToIntakeRecordFields business rule is attached.

Failed to load IntakeRecords for Group Customer for query: SELECT AsIntakeRecord.IntakeRecordGUID AS "IntakeRecordGUID", AsIntakeRecord.ChangesXML AS "ChangesXML", AsIntakeRecord.ChangeTypeCode AS "ChangeTypeCode", AsIntakeRecord.FileID AS "FileID", AsIntakeRecord.IntakeFileGUID AS "IntakeFileGUID", AsIntakeRecord.PreProcessGMT AS "StatusCode", AsIntakeRecord.ProcessGMT AS "ProcessGMT", AsIntakeRecord.RecordCorrelationID AS "RecordCorrelationID", AsIntakeRecord.RecordTypeCode AS "RecordTypeCode" , AsIntakeRecord.RecordXML AS "RecordXML" , AsIntakeRecord.StatusCode AS "StatusCode" , AsIntakeRecord.ProcessOrder AS "ProcessOrder" FROM AsIntakeRecord JOIN AsIntakeFile ON AsIntakeRecord.IntakeFileGUID = AsIntakeFile.IntakeFileGUID
 JOIN AsIntakeProfile ON AsIntakeFile.IntakeProfileGUID = AsIntakeProfile.IntakeProfileGUID
WHERE AsIntakeProfile.GroupCustomerClientGUID= '' .
Conversion failed when converting from a character string to uniqueidentifier

Note that this is not a configured Query. This logic does not appear anywhere in the configuration for the File transaction.

Sample Configuration used:
Transaction logic defining variable for attached rule -

CopyToIntakeRecordFields transaction should process successfully, and copy data back into dynamic Record level fields.

The issue can be reproduced at will with the following steps:
 1) Create an Intake Profile
2) Configure Record Definition XML with dynamic fields, and a processing transaction.
3) Configure Intake Record transaction, with CopyToIntakeRecordFields attached business rule.
4) Process an intake file on this profile with at least one record.
5) Navigate to Records associated with completed intake file, view System Errors associated with intake record processing transactions.

Analysis performed by Intake Record transactions cannot write to dynamic configured Intake Record Fields, impeding reporting, history logging, and user interface clarification.




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.