Eliminate Unnecessary Data Transformation (Escape Characters) in Payloads Between OIC and OPA
Due to a missing functionality in Oracle Integration Cloud (Split Invoker Role into Separate Roles for Manual Invocation and Retry in OIC — Cloud Customer Connect), we developed a custom Oracle Process Automation (OPA) flow to handle errored instances. In this flow, we included the ability to reinvoke the payload in case of errors. However, an issue arises when the payload is transferred to OPA from OIC. Oracle’s current behavior inserts escape characters (such as brackets) into the payload during this transfer, which creates complications when trying to reinvoke the same payload back into OIC.
According to Oracle's internal team, the insertion of escape characters is part of data sanitization measures for security purposes. However, this behavior causing errors during reinvocation since those 'brackets' are causing an incorrect format of the JSON file we want to retry, The payload should be kept in its original (unless data transformations are added by ourselfs), unmodified format.