EGL: Separate Debits And Credits Not Stored When Ledger Template Uses Record LEDGER_BUDG (Doc ID 642168.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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

This document was previously published as Customer Connection Solution 200986503


***Checked for relevance on 17-Feb-2012***


Symptoms

Having implemented the steps detailed in PeopleBooks to hold separate debits and credits in our ledgers we have an issue with posting to the Budget ledger.  Only the debit side of the accounting entry is processed to the LEDGER_BUDG table.

Oracle Software Support identified that  some columns (POSTED_TOTAL_CR, POSTED_TOTAL_DR, POSTED_TRAN_CR and POSTED_TRAN_DR) were missing from the LEDGER_BUDG table.   However the project GLSEPDRCR does not contain all the required tables.  Attempts to alter the table LEDGER_BUDG with these columns in a test instance have resulted in a failure of the journal Post process, so there must be other tables missing from the project.

Another customer reported the error : 

Error message
===========
ERR rtncd=1400 msg=ORA-01400: cannot insert NULL into ("SYSADM"."PS_LEDGER_BUDG"."POSTED_TOTAL_DR")

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