EGL9.2: Journal Generator Process(FS_JGEN) Updates GL_DISTRIB_STATUS as 'D' in PS_RECV_LN_ACCTG Table For Rows Having Budget Error. (Doc ID 2289956.1)

Last updated on SEPTEMBER 13, 2017

Applies to:

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

Symptoms

Issue:
-------

Journal generator(FS_JGEN) updates GL_DISTRIB_STATUS as 'D' in PS_RECV_LN_ACCTG table for the rows that have budget error(BUDGET_LINE_STATUS vlaue 'E').

Steps to Replicate:
---------------------------

1. Make sure Commitment control is active for Purchasing, Receipt Accrual & General Ledger on Installation option - Products page
2. Check the ensure that budget is available for the Business unit that would be used for testing.
3. Make sure that Receipt Accrual is enabled for PO at Purchasing Business unit options.
4. Create a PO with distribution lines having chartfield to have budget check enforced. It should hit & reduce the available budget in step 2.
5. Budget check PO & then Dispatch it
6. Create a Receipt from PO created in above steps & Run Receipt Accrual
7. Run budget check. Review Accrual accounting entries in PS_RECV_LN_ACCTG. One of the rows need to have failed budget checking. If not, then manually reduce the available budget & then budget check again.
8. Run Journal generator for RECACCRL definition.
9. Review Accrual accounting entries in PS_RECV_LN_ACCTG. See the values in GL_DISTRIB_STATUS & other Journal details columns against the row(s) which failed budget checking.


Please see Replication screenshots for more details.

Actual Behavior:
----------------

Journal generator(FS_JGEN) updates GL_DISTRIB_STATUS as 'D' in PS_RECV_LN_ACCTG table for the rows that have BUDGET_LINE_STATUS in 'E'


Expected Behavior:
-------------------

Journal generator(FS_JGEN) shouldn't update the GL_DISTRIB_STATUS as 'D' in PS_RECV_LN_ACCTG table for the rows that have BUDGET_LINE_STATUS in 'E' as they weren't picked up for processing by FS_JGEN


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