My Oracle Support Banner

WEBADI Journal Upload With DFF Errors: Unable to perform column validation / No validation rule available for column &COLUMN_NAME (Doc ID 2621062.1)

Last updated on DECEMBER 19, 2019

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Oracle Financials for the Americas - Version 12.0.0 and later
Oracle Web Applications Desktop Integrator - Version 12.0.0 and later
Generic (Platform Independent)

Symptoms

Attempt to upload Webadi Journals to GL using Descriptive Flexfields (DFF) defined in GL for Colombian Globalization errors out.
DFF validation is turned off, still the error occurs.

The same DFF works fine for manual journals entered in Journal Entry form (GLXJEENT).

 

ERROR:

Spreadhseet shows:

Unable to perform column validation;Unable to perform column validation;Unable to perform column validation;Unable to perform column validation;Unable to perform column validation

BNE Log shows:

"ERROR" bne:text="Unable to perform column validation" bne:cause="No validation rule available for column &COLUMN_NAME.
bne:element="line" bne:attribute="GL_INTERFACE.REFERENCE_5
bne:element="line" bne:attribute="GL_INTERFACE.REFERENCE_3"
...the same is reported for GL_INTERFACE.REFERENCE_1, GL_INTERFACE.REFERENCE_4,GL_INTERFACE.REFERENCE_2

 

Changes

 DFF setup for Colombian Localizations defined.

The setup has been defined correctly as described in: Note 338271.1 How To Upload Third Party Information Into General Ledger For Colombian Globalization From An External Source

and it is using REFERENCE1-5 (GL_JE_LINES) for the Transaction Number, Third Party ID, Verifying Digit, Third Party Type, Third Party Name fields.

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.