WebAdi: Unable to Use DFF for the Journal - Error Value XX For The Flexfield Segment XXXXXX Does Not Exist In The Value Set XX
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)
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
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms