My Oracle Support Banner

WebADI Add Pre-Import Rule to Custom Integrator Creating Error - The Sequence Name Is Invalid. (Doc ID 2849587.1)

Last updated on APRIL 26, 2022

Applies to:

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


Attempting to create a new Integrator with importer validation and when attempting
to assign a validation on Pre-Import Rules on CUSTOM_RUN_ID (PL/SQ: API Procedure CUSTOM_WEBADI_PKG.DATA_VALIDATE)

Note: Names provide are for example only and are not provided in the application as they are user created in this example.

The following error is being seen:
The Sequence name is invalid. Please enter a valid value.

Steps to recreate the issue:
1) Using Desktop Integration Manager.
2) Navigate to Manage Integrators.
3) Query custom integrator that is uploading data and working without this validation rule in place. 
4) Advance to Importer stage.
5) Select from Pre-Import Rules - Add rule.
6) Add Rule name CUSTOMAPI, Type PL/SQL API Procedure. 
7) Select Reference name P_RUN_ID, Source Import, value CUSTOM_WEBADI.RUN_ID
8) Select Apply
9) The error is then seen at the top of the page -
The Sequence Name in invalid. Please enter a valid value.

The integrator upload does work without this validation assigned. Data can be uploaded to the table.
Similar setup was done in 12.1.3 without this error being seen, this issue is new after 12.2 upgrade.


 New integrator being created in 12.2 version of the application.


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

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