My Oracle Support Banner

Data Management Loads are Skipping Records with One Double Quote in the Field (Doc ID 2660607.1)

Last updated on APRIL 28, 2020

Applies to:

Oracle Enterprise Planning and Budgeting Cloud Service - Version N/A to N/A [Release 11.1]
Information in this document applies to any platform.

Symptoms

Loading data using Data Management, if a record has a "single double quotation mark " in one of the description fields, Data Management skips the record all together and in the processing log shows skipped record is [BLANK].

Sample Data Load File :

Entity,Account,ATTR1,Product,Amount
InputEntity,InputAcct1,Test"Test,P1,1233.98
InputEntity,InputAcct2,T"T,P1,45100.56
InputEntity,InputAcct2,T"T",P1,4000.33
InputEntity,InputAcct3,,P1,-11900.7

Process log :

[TC] - [Amount=NN] Entity,Account,ATTR1,Product,Amount
[BLANK] InputEntity,InputAcct1,Test"Test,P1,1233.98
[BLANK] InputEntity,InputAcct2,T"T,P1,45100.56
Rows Loaded: 5
Rows Rejected: 3

Please Note: If Records having Two Double Quotation Mark then Records will be processed correctly and the issue is seen only with if the records have a  single quotation mark.

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


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