My Oracle Support Banner

Got Error When Importing Segment Values (Doc ID 2348475.1)

Last updated on MAY 31, 2023

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.12.1.0.0 and later
Oracle Fusion General Ledger - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

I faced two issues.Including importing segment values and uploaded AP Invoices csv.
 

value used for ROWS parameter changed from 64 to 21
Record 2: Rejected - Error on table GL_SEGMENT_VALUES_INTERFACE, column DESCRIPTION_US.
second enclosure string not present
Record 3: Rejected - Error on table GL_SEGMENT_VALUES_INTERFACE, column DESCRIPTION_PL.
second enclosure string not present
Record 4: Rejected - Error on table GL_SEGMENT_VALUES_INTERFACE, column VALUE.
ORA-01400: cannot insert NULL into ("FUSION"."GL_SEGMENT_VALUES_INTERFACE"."VALUE")

Record 33: Rejected - Error on table GL_SEGMENT_VALUES_INTERFACE, column DESCRIPTION_US.
second enclosure string not present
Record 34: Rejected - Error on table GL_SEGMENT_VALUES_INTERFACE, column DESCRIPTION_PL.
second enclosure string not present
Record 35: Rejected - Error on table GL_SEGMENT_VALUES_INTERFACE, column VALUE.
ORA-01400: cannot insert NULL into ("FUSION"."GL_SEGMENT_VALUES_INTERFACE"."VALUE")

Record 148: Rejected - Error on table GL_SEGMENT_VALUES_INTERFACE, column DESCRIPTION_US.
second enclosure string not present
Record 149: Rejected - Error on table GL_SEGMENT_VALUES_INTERFACE, column DESCRIPTION_PL.
second enclosure string not present
Record 151: Rejected - Error on table GL_SEGMENT_VALUES_INTERFACE, column DESCRIPTION_US.
second enclosure string not present
Record 152: Rejected - Error on table GL_SEGMENT_VALUES_INTERFACE, column DESCRIPTION_PL.
second enclosure string not present
Record 150: Rejected - Error on table GL_SEGMENT_VALUES_INTERFACE, column VALUE.
ORA-01400: cannot insert NULL into ("FUSION"."GL_SEGMENT_VALUES_INTERFACE"."VALUE")

Record 153: Rejected - Error on table GL_SEGMENT_VALUES_INTERFACE, column VALUE.
ORA-01400: cannot insert NULL into ("FUSION"."GL_SEGMENT_VALUES_INTERFACE"."VALUE")

Record 233: Rejected - Error on table GL_SEGMENT_VALUES_INTERFACE, column DESCRIPTION_US.
second enclosure string not present
Record 234: Rejected - Error on table GL_SEGMENT_VALUES_INTERFACE, column VALUE_SET_CODE.
no terminator found after TERMINATED and ENCLOSED field

Table GL_SEGMENT_VALUES_INTERFACE:
 220 Rows successfully loaded.
 14 Rows not loaded due to data errors.

Solution

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
Goal
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.