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 SEPTEMBER 14, 2016

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

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 hundreds of Community platforms