This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge. Best Quoting Software
December 18, 2020 at 7:07 PM
Trial Balance in Oracle Apps will give you the Credits, Debits and Net balances for a specific account in a given period. Below query does the same. Same query in Oracle Apps can be used to find out the Journals posted in a specific Account, Company for a given period.
select gjh.name Journal_name, gjh.je_category category_name, gjh.je_source source_name, gjb.name batch_name, GCC.SEGMENT1, -- comapny GCC.SEGMENT2, --cost center GCC.SEGMENT3, -- account GCC.SEGMENT4, ---Project GCC.SEGMENT5, --Product GCC.SEGMENT6, --Others SUM(NVL(GJL.ACCOUNTED_DR,0))ACCOUNTED_DR, SUM(NVL(GJL.ACCOUNTED_CR,0))ACCOUNTED_CR, SUM(NVL(GJL.ACCOUNTED_DR,0)-NVL(GJL.ACCOUNTED_CR,0))BALANCE from gl_je_headers gjh, gl_je_lines gjl, gl_ledgers gl, gl_code_combinations gcc, GL_JE_BATCHES GJB where gjl.je_header_id = gjh.je_header_id AND gjh.je_batch_id=gjb.je_batch_id and gjl.code_combination_id=gcc.code_combination_id and gjh.ledger_id=gl.ledger_id and gjh.status='P' --Actual balances AND gjh.actual_flag='A' AND gjh.period_name='AUG-14' AND GL.name='US Vision Operation' --Ledger GROUP BY GCC.SEGMENT1, GCC.SEGMENT2, GCC.SEGMENT3, GCC.SEGMENT4, GCC.SEGMENT5, GCC.SEGMENT6, GCC.SEGMENT7, gjh.je_category , gjh.je_source , gjb.name, gjh.name ;
posted by Santosh Dhongade at 5:08 AM on Oct 31, 2016
"Oracle apps GL Trial Balance Detail Report query"
3 Comments -
copied from http://oracleappstechguide.blogspot.com/2015/06/gl-trail-balance-query-detail.html
July 25, 2017 at 4:33 AM
Yeah
January 6, 2019 at 3:42 AM
This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.
Best Quoting Software
December 18, 2020 at 7:07 PM