Tuesday, November 17, 2015

Unable to import Payroll journal in GL "This new code combination includes summary segment"

Issue:

This new code combination includes summary segment
EF04    This is an invalid Accounting Flexfield.  Check your cross-validation rules and segment values.

Solution:


To import journals from a subledger into General Ledger:

     1.  Navigate to the import journals form.

     2.  Enter a source and group ID.

     3.  Select run options and import descriptive flexfields option.

     4.  Enter a date range.

     5.  Click on the [Import] button.

This spawns a concurrent request.  In the view my request form the process
completed with a status of "Normal."

Click on [Report] and view the journal import execution report, the following
error is shown:

      EF04:  This is an invalid Accounting Flexfield.
             Check the cross-validation rules and segment values.

The specific error message is:
'Value 000 has been disabled'
for disabled segment values and
'This new code combination includes summary segment'
for parent segment values

This error is specific to journal import and is not caused by consolidation
mappings.  The only reason the error show up when consolidation is run is due
to the run option (journal import) being enabled in the consoldation mapping
form.  If the process is run separately, the error will show up on the journal
import.

Cross-validation rules are set up as follows:

Include: AAA.AAAAAA.AAAAA.AAA.AAA.AAAAA - 999.999999.99999.999.999.99999
Exclude: AAA.131000.AAAAA.AAA.001.AAAAA - 999.131000.99999.999.999.99999
change: NOTE ROLE:  The Navigation Path is:
            Responsibility = General Ledger Super User
       Navigation = Setup>Financials>Flexfields>Key Rules
       Form Name  = FNDFFMCV (Cross-Validation Rules)


            Responsibility = General Ledger Super User
       Navigation: Setup>Financials>Flexfields>Key>Segments
   Form Name  = FNDFFMIS (Key Flexfield Segments)
cause: Cross validation rules and/or segment values exist which do not
allow the journal import process to complete successfully.



fix:

The following options are supported:

I.   Check cross-validation rules defined as follows:
 
     1.  Navigate to cross-validation rules form.

     2.  Cross validation rules evaluate from numeric to alphanumeric.

        a. Include should be:
           000.000000.00000.000.000.00000 - AAA.AAAAAA.AAAAA.AAA.AAA.AAAAA


        b. Exclude should be:

           999.131000.99999.999.999.99999 - AAA.131000.AAAAA.AAA.001.AAAAA


II.  Check segment values as follows:
 
     This error could also mean that posting is being attempted to a parent
     account.  Oracle General Ledger does not allow posting to parent accounts.
     Change the values to non-parent values or create child accounts and
     use those accounts to post to.  Make these changes on the
     Segment Values form.

III. Disable the cross-validation rule that is causing the error and re-run the
     consolidation process with the run option set to run journal import.

IV.  Change the cross-validation rules to not exclude the combination that is
     causing the error.

V.   Fix the combination at the source and re-run process.

1 comment:

  1. I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site. As a result of checking through the net and meeting techniques that were not productive, Same as your blog I found another one Oracle Cloud Applications .Actually I was looking for the same information on internet for Oracle Cloud Applications Consultant and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete