Journal Line Bank Statement Reconciliation

Many times business wants to reconcile a Journal with a bank statement line but it might happen that the Journal Line is not available in the list of Reconcilable lines  , Below are some of the simple checks you can perform to find the reason why the Journal is not available

• Is the Journal Line Posted
• Is the Journal line account same as the Cash Account on the bank account setup
• If you have entered any search criteria in the Find screen which might not be matching the Journal you are expecting to reconcile
• The Journal has not been already reconciled with a bank statement . In Order to check if a Journal line is reconciled against a bank statement  , use the below SQL

          SELECT Count(1)

              FROM ce_statement_lines sl, 

                          ce_statement_reconcils_all sr, 

                          gl_je_headers jh, 

                          gl_je_lines jl ,

                          ce_statement_lines sh

            WHERE 1=1

                 AND sr.statement_line_id=sl.statement_line_id

                 AND sr.je_header_id=jh.je_header_id

                 AND jh.je_header_id=jl.je_header_id

                 AND sr.reference_id=jl.je_line_num

                AND sr.reference_type='JE_LINE'

                AND sl.statement_header_id = sh.statement_header_id

                AND gjh.name = :journal_name

Hope this Helps

Thanks

Journal Batch Posting Error

When Posting a Journal Batch you might encounter an Error where the Posting program fails .
In such cases first thing is to check the OUTPUT and LOG file for potential messages displayed by Oracle.

One of the errors which can occur is : ORA-00001: unique constraint (GL.GL_JE_HEADERS_U2) violated

If you see the table gl_je_headers there is an unique index on Batch Id and Journal Name.

For the same batch you will see that the Journals have a unique name but when doing posting Oracle checks for the First 78 characters of the Journal Name and Batch Id Uniquenss , if the condition is violated we will get the above error.

To resolve the error open the Journals in the batch update the names by adding Unique numbers at the beinging , save your work and Post again

Issue will be resolved.