My Oracle Support Banner

How to Resolve Unposted Budget Journal Where KK_BUDGET_HDR Row With UNPOST_SEQ = 1 Has BD_HDR_STATUS "P" & BUDGET_HDR_STATUS "E" (Doc ID 2885420.1)

Last updated on SEPTEMBER 09, 2022

Applies to:

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

Symptoms

A Commitment Control budget journal was unposted but the unpost is not reflected in the commitment control ledger, KK_REV_BUD.

--upgraded from Tools 8.57 to 8.58 on 5/1/22
--unpost of budget journal was 5/25/22

--next queried for other KK_BUDGET_HDR rows with UNPOST_SEQ = '1' and BUDGET_HDR_STATUS = 'E'
--found 4 budget journal headers with the same PROCESS_INSTANCE, DTTM_STAMP_SEC and OPRID

UNPOST_SEQ  LEDGER_GROUP  JRNL_PROCESS_REQST  BD_HDR_STATUS  JRNL_TOTAL_DEBITS   POSTED_DATE             DTTM_STAMP_SEC             BUDGET_HDR_STATUS
        0              KK_REVENUE                   N                               U             724892                          10-Feb-22    10-FEB-22 03.02.53.216431000 PM               V
        1              KK_REVENUE                   P                                P            -724892                          10-Feb-22    25-MAY-22 04.57.28.463297000 PM               E            << note


--user had run the batch budget checking, called the helpdesk as the process got stuck, then continued running the process
--not sure how the budget check of the budget journal header with UNPOST_SEQ = '1' got BD_HDR_STATUS = 'P' yet BUDGET_HDR_STATUS = 'E'
--if it really did pass budget checking there should be corresponding rows in KK_SOURCE_HDR and KK_ACTIVITY_LOG, however there are no corresponding rows

STEPS:
1) Post a Commitment Control budget journal
2) Run the batch budget checking process to Unpost a Commitment Control budget journal
3) Review budget details

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.