My Oracle Support Banner

Unable to Extend the View ArCMAnalysisCFSearchResultsVO (Doc ID 2627758.1)

Last updated on JANUARY 30, 2020

Applies to:

Oracle Credit Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version

When attempting to extend the View ArCMAnalysisCFSearchResultsVO following error occurs.


ERROR
--------------
Each row in the Query Result Columns must be mapped to a unique Query Attribute in the Mapped Entity columns


STEPS
-------------
Extend the view ArCMAnalysisCFSearchResultsVO thru JDeveloper

BUSINESS IMPACT
-------------
The issue has the following business impact:
Due to this issue, users cannot extend the VO

Changes

 In view select statement, selecting column "app.application_date" but there is no attribute defined corresponding to this column.
        
  Added following:

      
           <ViewAttribute
              Name="ApplicationDate"
              IsPersistent="false"
              Type="oracle.jbo.domain.Date"
              ColumnType="VARCHAR2"
              AliasName="APPLICATION_DATE"
          Expression="APPLICATION_DATE"
              SQLType="DATE" >
          <DesignTime>
                 <Attr Name="_DisplaySize" Value="7" />
              </DesignTime>
           </ViewAttribute>

Cause

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
Symptoms
Changes
Cause
Solution
References


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