Unable To Upload Data Using Custom Web ADI Integrator (Doc ID 1924629.1)

Last updated on JULY 24, 2017

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Have created a custom WebADI integrator using Desktop Integrator responsibility to upload and update in sourcing rules tables. The integrator is working fine in Development and other instances, but, it is throwing an 'Cannot execute SQL statement' in our UAT instance.

Steps to reproduce the issue:
1. Created a custom WebADI integrator using Desktop Integrator responsibility to upload and update in sourcing rules tables.
2. Run the integrator and it errors with:

'Cannot execute SQL statement'

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms