ED01 in Journal Import when importing descriptive flexfields with validation (Doc ID 116248.1)

Last updated on JANUARY 22, 2017

Applies to:

Oracle General Ledger - Version 11.0.3 to 11.5.10.2 [Release 11 to 11.5.10]
Information in this document applies to any platform.
Checked for Relevance as on 30-Apr-2013

Symptoms

You are importing data from a legacy or 3rd party system into General Ledger.
You are trying to import the descriptive flexfield 'Journals - Journal Entry Line'.

When you run the Journal Import with the 'Without Validation' option checked for Descriptive Flexfields, the import runs successfully.

When you run the Journal Import with the 'With Validation' option checked for Descriptive Flexfields, the Journal Import Execution Report contains the following:



Accounting
Error Code Source Date Currency Entered
Debit Entered Credit Accounting Flexfield/CCID
------------------------------ ------------- ----------- -------- --------------
---- ------------------ ----------------------------
ED01 SPREADSHEET J 26-APR-00 USD
0 .99 0327-0000-000000-000000-0000
APP-00812 cannot read value from field lines.accounting_flexfield
ED01 SPREADSHEET J 26-APR-00 USD
0 100 0021-0000-000000-000000-0000
APP-00812 cannot read value from field lines.accounting_flexfield
ED01 SPREADSHEET J 26-APR-00 USD
0 200 0240-0000-000000-000000-0000
APP-00812 cannot read value from field lines.accounting_flexfield




ED01 = The context and attribute values do not form a valid descriptive flexfield for Journals - Journal Entry Lines.

You believe that you have populated the CONTEXT and ATTRIBUTE columns correctly in the GL_INTERFACE table, for the descriptive flexfield.

You are using a table validated value set for one of the descriptive flexfield segments. The Where/Order By clause for this table contains the following:

...
and a.flex_value = substr(:lines.accounting_flexfield,1,4))

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