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 laterOracle 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 |