EGL: KK Budget Journal Import ABENDED at Step KK_JRNL_IMP.PROCESS.Import (PeopleCode) With Error "Field does not exist -- BUS_UNIT_TBL_GL.KK_AF_APPR_OPT_BU. (180,104)" (Doc ID 1612976.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
****Checked for Currency on 06-Jan-2016****

Symptoms

On :  9.2 version, Flat File Journal Import

Import Commitment Control Budget Journal runs  to No Success  with below error if Control Budget Journal Approval Option is as required:
 
ERROR
-----------------------
Processing file Budet_Journal_Sample_v2.txt ... (5825,104)
2013-11-21-10.38.52.522641 AePcdExecutePeopleCode [188] Exception logged: RC=100.
2013-11-21-10.38.52.522645 GetNextStateRecord [68] Exception logged: RC=3.
Field does not exist -- BUS_UNIT_TBL_GL.KK_AF_APPR_OPT_BU. (180,104) KK_JRNL_IMP.PROCESS.GBL.default.1900-01-01.Import.OnExecute Name:approvalIsOn PCPC:633 Called from:KK_JRNL_IMP.PROCESS.GBL.default.1900-01-01.Import.OnExecute Name:ProcessHeader Statement:249
Called from:KK_JRNL_IMP.PROCESS.GBL.default.1900-01-01.Import.OnExecute Name:ImportData Statement:540
Called from:KK_JRNL_IMP.PROCESS.GBL.default.1900-01-01.Import.OnExecute Statement:619
2013-11-21-10.38.52.522730 DoStepActions [1853] Exception logged: RC=100.
Process 17419 ABENDED at Step KK_JRNL_IMP.PROCESS.Import (PeopleCode) -- RC = 24 (108,524)

WHAT IS WORKING
----------------------------------
If Control Budget Journal Approval Option is not required at BU/LEDGER level, process run to success and budget journal is imported into system.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enable Commitment Control for BU/Ledger on Set Up Financials/Supply Chain > Business Unit Related > General Ledger > Ledger For A Unit.
2. Turn on Control Budget Journal Approval Option
     - General Ledger Definition > Approval Options, Control Budget Journal Approval Option = Required
     - Ledger For a Unit > Approval Options, Control Budget Journal Approval Option = Default To Higher Level.
3. Navigate to page Commitment Control > Budget Journals > Import Budget Journals
4. Run Budget Journal Import with following run control parameters
    - Char Set
    - Journal ID Mask
    - Attached File
5. Process run to no success with above error presented in the message log

BUSINESS IMPACT
-----------------------
Due to this issue, users cannot complete journal import

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