EGL: JRNL_HEADER_IU Not Being Cleared of Row for the Business Unit That No Longer Has Any Journal Lines on the Journal (Doc ID 3063200.1)

Last updated on DECEMBER 11, 2024

Applies to:

Symptoms

Journal is created with for 4 lines - 2 lines for the 1st Business Unit and 2 lines for the 2nd Business Unit. After Journal Edit is run, Inter/IntraUnit balancing lines are created for both Business Units, and one of the lines for the 2nd Business Unit has a combination edit error. Both lines for the 2nd Business Unit are deleted. Once the Journal is saved, the balancing lines for the 2nd Business Unit are still present. After Journal Edit is run, the balancing lines are removed for the 2nd Business Unit but the 2nd Business Unit is still displayed in the Totals section. The 2nd Business Unit is not being deleted from PS_JRNL_HEADER_IU even though it no longer has any Journal lines. As a result, when two lines are added to the Journal, one for the 1st Business Unit and one for the 2nd Business Unit, once the Journal is saved, an error occurs.

ERROR
Data being added conflicts with existing data (18,2)

STEPS TO REPLICATE
1. Set Up Financials/Supply Chain > Install > Installation Options > Products link > Products page - under Enable Commitment Control, check box for General Ledger
2. Set Up Financials/Supply Chain > Install > Installation Options > Overall link > Overall page - box un-checked for Use Legal Entity for InterUnit
3. Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > ChartField Inheritance > Define CF Inheritance Options
    a. SetID = SHARE
    b. Inheritance Group = AP Header / Department = Always Inherit
    c. Inheritance Group = AP Distrib / Department = Always Inherit
4. General Ledger > Ledgers > Define Ledger Group > Balancing page
    a. SetID = SHARE
    b. Ledger Group = RECORDING
    c. Check box for IntraUnit Balancing Entries
    d. Check Balance box for Department
5. Set Up Financials/Supply Chain > Business Unit Related > General Ledger > General Ledger Definition
    a. Business Unit = US003
    b. Journal Options page - Journal Balance Option = Recycle / Journal Edit Errors Option = Recycle
    c. Inter/IntraUnit page - InterUnit Template = CORP / IntraUnit Template = CORP
6. Set Up Financials/Supply Chain > Common Definitions > Inter/Intra Unit > InterUnit Template
    a. SetID = SHARE
    b. InterUnit Template = CORP
    c. Transaction Code = GENERAL
    d. InterUnit Payable and InterUnit Receivable have Account chartfield populated
7. Set Up Financials/Supply Chain > Common Definitions > Inter/Intra Unit > IntraUnit Template
    a. SetID = SHARE
    b. IntraUnit Template = CORP
    c. Transaction Code = GENERAL
    d. IntraUnit Payable and IntraUnit Receivable have Account chartfield populated
8. Set Up Financials/Supply Chain > Business Unit Related > General Ledger > Ledger for a Unit
    a. Commitment Control Options page - Business Unit = US001 and US003 / Ledger Group = RECORDING / Check box for Enable Commitment Control
    b. Journal Edit Options page - Business Unit = US003 / Ledger Group = RECORDING / Process Group = EXP-CE / Transaction Source Option = All Transaction Sources
9. PeopleTools > Utilities > Administration > Maintain TableSet Controls
    a. Set Control Value = US003
    b. FS_22 (ChartField Combination Edits) = SHARE
10. Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Combination Editing > Define CF Combination
      a. SetID = SHARE
      b. Combination Definition = EXP-CE
      c. ChartField = Account and Deparment
      d. Check Anchor Chartfield box for Account
11. Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Combination Editing > Combination Rule > ChartField Combinations
      a. SetID = SHARE
      b. Combination Rule = EXP-CE
      c. ChartField = Account / Selected Detail Values / Node/Value = 120055
      d. Non-Chartfield = Department / Selected Detail Values / Node/Value = 42000
12. Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Combination Editing > Combination Group
      a. SetID = SHARE
      b. Process Group = EXP-CE
      c. Combination Definition = EXP-CE
      d. Combo Editing Option = Combo Data Tabe
      e. Anchor Values Not In Rules = Mark Valid
      f. Combination Group Defines = Invalid Combinations
      g. Combination Rule = EXP-CE
13. Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Combination Editing > Build Combination Data
      a. Business Unit = US001 / Ledger Group = RECORDING / Build Option = Build Data Table
      b. Business Unit = US003 / Ledger Group = RECORDING / Build Option = Build Data Table
14. General Ledger > Journals > Journal Entry > Create/Update Journal Entries
      a. Add Journal for Business Unit = US001
      b. Journal > Lines page has 4 Lines
      c. Line 1 / Unit = US001 / Account = 100000 / Amount = 500.00
      d. Line 2 / Unit = US001 / Account = 120055 / Amount = -500.00
      e. Line 3 / Unit = US003 / Account = 100000 / Amount = 450.00
      f. Line 4 / Unit = US003 / Account = 120055 / Dept = 42000 / Amount = -450.00
      g. Click Save
      h. Process = Journal Edit / Click Process to run Journal Edit
      i. 4 Inter/IntraUnit balancing entries are created - 2 lines for US001 and 2 lines for US003
      j. Line 4 in Error due to an invalid chartfield combination
      k. Journal > Errors page, Line Errors shows "Combo error for fields Account/Dept in group ECP-CE."
      l. Journal > Lines page, check the Select box for Lines 3 and 4 / Click the - sign
      m. Under the Totals section, balancing lines for US003 are still present
      n. Click Save
      o. Process = Journal Edit / Click Process to run Journal Edit
      p. Under the Totals section, the balancing lines for US003 are deleted but US003 is still present
      q. Through SQL, BUSINESS_UNIT US003 is not being deleted from PS_JRNL_HEADER_IU even though it no longer has any Journal lines
      r. Add 2 lines, 1 for US001 and 1 for US003
      s. Above error is received

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.