OIC Lookup Import Error – "The Type, Name and Description Line is Invalid" [Resolved]

Issue Case:

While trying to re-import a modified Lookup CSV file back into Oracle Integration Cloud (OIC), an error occurred:

"Failed to import lookup file ‘XYZ.csv’. The lookup is formatted incorrectly. The Type, Name and Description line is invalid."

This happened despite exporting the Lookup directly from OIC and only updating its rows.

Root Cause:
Upon opening the exported CSV file in Notepad, it was observed that the header line:

Type,Name,Description,,,,,,,

...contained extra trailing commas. These additional commas beyond the expected three fields caused the file to be rejected by OIC during import, as it violates the expected format.

Solution Steps:

1. Open the exported Lookup CSV file using Notepad or any plain text editor.
2. Locate the first line that should read:

   Type,Name,Description
   

3. Remove all extra commas after "Description" so that only three fields are defined in the header row.
4. Save the file with the same CSV format (UTF-8 or ANSI).
5. Retry the import in OIC — it should now succeed without error.