OIC - Combining Source File Records into a Single Line in Oracle Integration Cloud (OIC)

Working...

Issue Statement:

In many real-time integrations, especially in ERP or data migration scenarios, source files are received in a structured format (e.g., one header record followed by multiple detail records). However, certain downstream systems or services may require this data to be flattened into a single string line (e.g., HeaderDetailDetailDetail...) before further processing. Oracle Integration Cloud (OIC) does not offer a direct activity to do this in a single step, so a custom approach is required.

Solution Steps:

Technique 1 : for small size source file

Read the file:

Read the source file as raw line by line using a sample csv file uaing ftp adapter.

Write File using stage and translate for each line new line :

translate(ns22:FileData, "

", "")

This XSLT function removes newline (
) and carriage return (
) characters from each line, which is essential when combining multiple lines into a single line in OIC.

Technique 2: For bigger size file - 10k ~ 30k size.

TBD