Data Management Loads are Skipping Records with One Double Quote in the Field
(Doc ID 2660607.1)
Last updated on AUGUST 06, 2024
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 |