My Oracle Support Banner

Incorrect field name Used In The Query Which Belongs To The File Record Status Update Batch-C1-FRSUP (Doc ID 2656995.1)

Last updated on APRIL 14, 2020

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.8.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.8.0.0.0 version, BT - Batch

ACTUAL BEHAVIOR
---------------------

Invalid identifier error (ORA-00904) is thrown by the query which belongs to the File Record Status Update Batch-C1-FRSUP.  

Batch code: C1-FRSUP

Batch Process Name: File Record Status Update Batch

Program Name: com.splwg.ccb.domain.dataManagement.fileRequest.batch.FileRequestStatusUpdateBatch

Incorrect field name is used in the group by clause on the query from the File Record Status update batch code (FileRequestStatusUpdateBatch), currently used FILEID instead of correct field name FILE_ID ( hyphen is missing).

 

Below error can be seen in stderr and stdout files:

xxxxxxxx ERROR (com.splwg.base.support.sql.PreparedStatementImpl) : Error executing iterate for rawSQL:

SELECT DISTINCT frd.FILE_ID,frd.STATUS_CD,count(frd.STATUS_CD) NUM_RECS FROM CI_FILE_REQUEST_DETAIL frd,CI_FILE_REQUEST_DTL_MSG frm WHERE

frd.REQUEST_ID = frm.REQUEST_ID(+) AND frd.STATUS_CD = ? AND frd.FILE_ID = ? group by frd.fileId,frd.STATUS_CD /* fetchFileIdsToBeUpdated */

with 'string' parameter named 'status' to : 'ERR ' to indices: 1

with 'string' parameter named 'fileId' to : '0000000027' to indices: 2

java.sql.SQLSyntaxErrorException: ORA-00904: "FRD"."FILEID": invalid identifier




EXPECTED BEHAVIOR
-----------------------
correct field name FILE_ID should be used in the query.


Changes

 

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.