I migrated a collection of mappings from OWB to ODI 12.2.1. When I run one of the mappings I get an ORA-01722: invalid number error message. I would like to debug the sql code generated by the mapping using the ODI debug function. I click Run/Debug/Start debug Session, accept the defaults on the Debug dialog and click okay. The system displays an error ‘…ensure that there is one step in the in the session execution.’
I would like to know how to get started on using the debug tool to debug a mapping. What is the session execution and how do I add steps?