My Oracle Support Banner

WebAdi: Unable to Use DFF for the Journal - Error Value XX For The Flexfield Segment XXXXXX Does Not Exist In The Value Set XX (Doc ID 2063850.1)

Last updated on FEBRUARY 28, 2018

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Oracle Web Applications Desktop Integrator - Version 12.1.3 and later
Information in this document applies to any platform.
WebAdi Descriptive Flexfield (DFF)


From DFF for the journal line, enabled a value set, YYCustomer with Validation Type: Table and List Type: LOV, which contains a query for selecting customers.
Table: (SELECT (SUBSTR(party_name, 1, 30)) party_name, status,party_id FROM HZ_PARTIES) party

Trying to load the journals from the Webadi where DFF was enabled for the journal line, unable to select a few of customers using DFF Line from WebAdi Layout. For other customers (DFF values) it worked fine.


The following patches were installed but did not solve the issue:
<Patch 16655943:R12.BNE.B> Oracle Web Application Desktop Integrator Consolidation Patch


Value XX For The Flexfield Segment XXXXXX Does Not Exist In The Value Set XX

The issue can be reproduced at will with the following steps:
1) General Ledger>Journal>Launch Journal Wizard
2) Click on Create document
3) Click on enable content
4) Go to review and click on unprotect
5) Click on the line DFF
6) Enter Flexfield: Enter Journals: Lines
7) Search for customer: Select the Customer


To view full details, 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 a vibrant support community of peers and Oracle experts.