You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Multiple string operations in SQL for Data Exchange fails

edited 4:57PM in Account Reconciliation

Summary:

Transaction matching process: one of the columns coming from a data source needs some transformation. I need to transform a text value from AAAAAA-BBB format to CRBBBAAAAAA. With SQL the transformation needed would be similar to: 'CR'|| substr(col,-3,3) || substr(col, 1, 6). When I apply the SQL formula in Data Exchange, I get error: RuntimeException:java.lang.RuntimeException: Missing IN or OUT parameter at index:: 111

Content (please ensure you mask any confidential information):

I am setting up a transaction matching process in ARCS. In the first data source, I need to manipulate one text column to put it in a format that would allow matching with a column in the 2nd data source. The data in the column I am trying to transform is always 10 characters and looks like AAAAAA-BBB. I need the value transformed to CRBBBAAAAAA.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!