Jounral import Program is completing with Warning - KEY_FLEX_FAIL (Doc ID 1996195.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Purchase to Pay Flow

Jounral import Program is completing with Warning KEY_FLEX_FAIL

Material transactions are moved to PA. The Accounting for the Material Transaction is done in INV. No more accounting is wanted or needed in PA.
Therefore, Capitalizable in Project Expenditure Items form cannot be updated.
However, with Mass Adjust, it is possible to update these records. As a result of that update, Streamline DXU process picks up these records, and tries to make a journal entry.
This journal entry errors out because of: KEY_FLEX_FAIL. The GL account returned by AutoAccounting does not pass validation rule.

When trying to correct the data in GL interface, records are showing and also not even in projects.

ERROR
-----------------------
EC12 The entered amount must equal the accounted amount in a functional or STAT currency journal line.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Material transactions are moved to PA. The Accounting for the Material Transaction is done in INV. No more accounting is wanted or needed in PA.
Therefore Capitalizable in Project Expenditure Items form cannot be updated.
2. In Mass Adjust it is possible to update these records. As a result of that update
3.Run streamline interfacing processes (DXU) - which picks up these records, and tries to make a journal entry.
4. This journal entry errors out because of: KEY_FLEX_FAIL, The gl account returned by AutoAccounting does not pass validation rule

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Cannot close period in Prod

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