R12 GLXJEENT- Non Zero Debits And Non Zero Credits in Same Journal Line (Doc ID 2089255.1)

Last updated on AUGUST 27, 2019

Applies to:

Goal

Standard application behavior permits Debits and Credits in a Single Journal Line for the same account only for Consolidation Journals as well as for the journals imported using Journal Import program and Year end closing journals. The Journal Import program picks data from gl_interface as they are, this may cause debit and credit amounts to exist for the same line as well.

For Consolidation journals you need to set the profile option: "GL Consolidation: Separate rows for debit and credit account balances in consolidation journal" to No in order to have debit and credit amounts for the same account code in the same line.

Year end closing journals follow the same pattern, ie. Bug 857892 : CLOSING JOURNAL: THE CREATED JOURNALS HAVE 0 IN CR/DR INSTEAD OF NULL. This is the expected behavior.  Both debits and credits will always be
populated.  This is consistent with Consolidation.

You would like to have a similar profile option or setup to achieve consistent behaviour for all journals including the journals created manually via Journal Entry form.

Solution

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