My Oracle Support Banner

WebADI Errors When Using Duplicated Integrators: Unable to upload column UPLOAD_BATCH.P_DIST_NUMBER. Data type is 12 when the expected type is 2. (Doc ID 2831361.1)

Last updated on SEPTEMBER 02, 2023

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to upload the WebADI data to Oracle Applications, the following error occurs in the spreadsheet.

This only happens when using an integrator that was created using the new 'Duplicate' feature provided for WebADI Integrators starting 12.2.


ERROR
Unable to upload column UPLOAD_BATCH.P_DIST_NUMBER. Data type is 12 when the expected type is 2.


STEPS TO REPRODUCE

  1. WebAdi responsibility > Query an existing Integrator
  2. Use Duplicate button to duplicate it
  3. General Ledger Responsibility > Using the new integrator, create a WebAdi spreadsheet
  4. Attempt to upload > See the error in the spreadsheet

Changes

 Used the new 'Duplicate' feature in 12.2 to duplicate integrators.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.