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 SEPTEMBER 28, 2016

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)

Symptoms

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
<Patch 18538028:R12.BNE.B> R12 WEB ADI DOES NOT VALIDATE DFF


ERROR:

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

STEPS:
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

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