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 AUGUST 08, 2023
Applies to:
Oracle Financial Services Revenue Management and Billing Cloud Service - Version NA and laterInformation 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 |