My Oracle Support Banner

Invalid input value 'xxxx' for column: ACCT_NBR. while persisting data in Table CI_TXN_DETAIL_STG error With File Transformation Batch (C1-FTRAN) While processing Pipe delimited file with double quotes. (Doc ID 2820753.1)

Last updated on NOVEMBER 19, 2021

Applies to:

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

Symptoms

On : NA version, MICC Transfer to TSC

ACTUAL BEHAVIOR
---------------------
Issue with File Transformation batch (C1-FTRAN) while processing Pipe delimited file with double quotes.

Batch ends with java error with no logs.

 

Following errors can be seen in TPW log,

threadpoolworker.xxx-TPW.xxx.log:

 

 -   2021-09-16 08:14:06,895 [5] ERROR

(dataManagement.txnDetailStageUpload.TransactionDetailStageUploadService)

com.splwg.shared.common.ApplicationError: (Server Message)

Category: 90003

Number: 88

Call Sequence:

Program Name: TransactionDetailStageUploadService

Text: Invalid input value 'xxx' for column: ACCT_NBR.

Description:  

Table: null

Field: null

 -   2021-09-16 08:14:06,909 [5] ERROR (api.batch.ThreadWorkUnitExecutable)

Error #1 encountered at work unit FileRequestDetail_Id(50100020000000000000)

- this error will be logged and the unit skipped during the database

transaction replay

com.splwg.shared.common.ApplicationError: (Server Message)

Category: 90003

Number: 7

Call Sequence:

Program Name: TransactionDetailStageUploadService

Text: Exception: Invalid input value 'xxx' for column:

ACCT_NBR. while persisting data in Table CI_TXN_DETAIL_STG

Description:  

Table: null

Field: null



EXPECTED BEHAVIOR
---------------------------
Records should be processed.

 

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.