Unable To Perform Column Validation Error On WEBADI While Using KFF Validator (Doc ID 1915740.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, WebADI Templates
Unable to perform column validation Error on WEBADI while using Accounting KFF Validator on a custom integrator (Custom API), for testing this functionality in FAH journal upload .
Have a custom API using OA_FLEX component.
After entering the valid segment values in concatenated segments and upload, it is throwing "Unable to perform column validation" error.
This error is repeated for each segment.

When attempting to upload with Accounting KFF on custom WebADI Integrator, the following error occurs:
ERROR
Unable to perform column validation
No validation rule available for column &COLUMN_NAME

Are able to upload without KFF (Key Flex Field).
This KFF is used in General Ledger journals integrator and the issue does not occur there.

The same issue is documented in <Bug: 12552144>.
The customer reported: I already tried this workaround almost 20 times but no use.

The issue still occurs after applying these patches:

    WEB ADI 12.1.3.1 CONSOLIDATED PATCH 16655943
    OAF 12.1.3.2 PATCH 15880118 (Released) TRACKING BUG FOR OA FRAMEWORK


STEPS
The issue can be reproduced at will with the following steps:
KFF_Configuration_in_webadi.doc
Navigate to the Integrators page in Oracle E-Business Suite Desktop
Integration Framework (Desktop Integrator Manager responsibility > Create Integrators
Create a new Integrator Interface = ORACLE_KFF_012
for segment ACCOUNT (ALL are setup the same)
Set Validation Type = Key Flexfield
From Excel => Add-Ins => Oracle => Upload


Changes

 Created a custom integrator that uses a Key FlexField

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