EGL: Separate Debits And Credits Not Stored When Ledger Template Uses Record LEDGER_BUDG
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***
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 :
ERR rtncd=1400 msg=ORA-01400: cannot insert NULL into ("SYSADM"."PS_LEDGER_BUDG"."POSTED_TOTAL_DR")
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