My Oracle Support Banner

EGL9.2: Flat File Commitment Control Budget Journal Import (KK_JRNL_IMP) Process Fails With "Field does not exist -- BUS_UNIT_TBL_GL.KK_AF_APPR_OPT_BU. (180,104)" Error (Doc ID 1612976.1)

Last updated on JULY 17, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.



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)

Steps to Replicate:
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




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.