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