Are there any known issues between EPM Integration Agent and EBS v9.2?
We have been using the Integration Agent with EBS numerous times successfully, but running into a very puzzling problem.
Our usual process is to connect directly to the database using Oracle SQL Developer to develop the SQL Statement, then copy it into the Integration Agent when we are happy with it.
However, the integration agent is only extracting numeric and date fields, and will export an empty field in place of text.
We have simplified down our query to demonstrate the issue:
When run via the Integration Agent, the .dat file produced has this format:
They are using the same user account to connect.