My Oracle Support Banner

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 APRIL 08, 2019

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****


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:
Processing file Budet_Journal_Sample_v2.txt ... (5825,104)
2013-11-21- AePcdExecutePeopleCode [188] Exception logged: RC=100.
2013-11-21- 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- DoStepActions [1853] Exception logged: RC=100.
Process 17419 ABENDED at Step KK_JRNL_IMP.PROCESS.Import (PeopleCode) -- RC = 24 (108,524)

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

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

Due to this issue, users cannot complete journal import




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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