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.

Symptoms

Issue:
-------

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)

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


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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