My Oracle Support Banner

EGL: SQL Error 805 occurred at FS_BP_POST.InsertKK.InsLedg When Posting A Budget Journal on MS SQL Server. (Doc ID 1297088.1)

Last updated on MARCH 02, 2018

Applies to:

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

Symptoms

On : 9.1 version,

When attempting to post a one-line budget journal, the following error occurs.

ERROR
-----------------------
AE trace:

-- 15.37.17 SQL Error 805 occurred at FS_BP_POST.InsertKK.InsLedg (ignoring)
-- 15.37.32 Process 11306 ABENDED at Step FS_BP_POST.InsLoop.InsLedg (Action Call Section) -- RC = ?
ROLLBACK


ENVIRONMENT
---------------------------
FSCM 9.1 PT 8.50 on SQL server 2008r2.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Commitment Control > Budget Journals > Enter Budget Journals.
2. Enter budget journal header and line.
3. Choose 'Post Journal' from Journal Line tab Process drop down list and click 'process'.
4. The above error shows in the message log and trace.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot post budget journal.

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!


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