WebADI: Descriptive Flexfield Data Not Uploaded Successfully to Journals
Last updated on FEBRUARY 05, 2018
Applies to:Oracle Applications Desktop Integrator - Version 18.104.22.168 and later
Oracle General Ledger - Version 22.214.171.124 and later
Information in this document applies to any platform.
Customer has a WebADI journal layout with fields for descriptive flexfields added.
For Enter Journals: Lines:
- Line DFF Context
- Line DFF
For Enter Journals: Captured Information:
- Captured Info Context
- Captured Info DFF
Both descriptive flexfields are defined with value sets that produce errors when the flexfields are compiled.
For 'Enter Journals: Lines""
'The descriptive flexfield 'Enter Journals: Lines' of application General Ledger uses features which are only supported in Oracle Forms. This flexfield may not function in other environments such as OA Framework or PL/SQL APIs. The segment 'Transaction Date' of Context 'Global Data Elements' uses value set DATE_LIST with format type of Date. This type of value set is only supported in Oracle Forms.
Please use a standard date or standard datetime value set instead.'
For 'Enter Journals:Captured Information':
'The descriptive flexfield 'Enter Journals: Captured Information' of application General Ledger uses features which are only supported in Oracle Forms. This flexfield may not function in other environments such as OA Framework or PL/SQL APIs. The context field uses reference field 'CONTEXT3'.
BLOCK.FIELD references are only supported in Oracle Forms.'
Customer is able to upload the journal from WebADI without errors if 'Upload Descriptive Flexfields without Validation' is selected.
A query of the gl_interface table shows that the values entered in Line DFF and Captured Info DFF are in the gl_interface table (ATTRIBUTE10 and CONTEXT3 respectively) as expected. However, the value entered in Captured Info DFF does not appear in the ATTRIBUTE column defined for the Enter Journals: Captured Information DFF.
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