Home » Applications » Oracle Fusion Apps & E-Business Suite » Period_Name column reference in GL_Balances and GL_Je_Lines tables
Period_Name column reference in GL_Balances and GL_Je_Lines tables [message #503423] Fri, 15 April 2011 07:42 Go to next message
sammydude
Messages: 34
Registered: November 2007
Member
Hello all,

GL_Balances and GL_Je_Lines tables have period_name column.
Are they the same?

Should the following queries return the same value for a given period and code combination?
(I've left out other where clauses. Included only the important ones relavent for this question)

select sum(l.accounted_dr),sum(l.accounted_cr)
from gl_je_lines l
where 1=1
and set_of_books_id = 1
and l.period_name like 'Jan-06'
and l.code_combination_id = 17347
and l.actual_flag = 'A'

select period_net_dr,period_net_cr from Gl_Balances j
where 1=1
and set_of_books_id = 1
and j.code_combination_id = 17347
and j.period_name like 'Jan-06'
and l.actual_flag = 'A'

So, if we sum up the values for a code combination at lines level, should it match the period_net value in GL_Balances table for the same period?

Please help.

Regards,
Sam
Re: Period_Name column reference in GL_Balances and GL_Je_Lines tables [message #504029 is a reply to message #503423] Thu, 21 April 2011 03:33 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Yes, in ideal scenarios..
period_net values are NET values.
Whichever is higher in sum(l.accounted_dr) and sum(l.accounted_cr) of gl_je_lines,
only that side will be populated in gl_balances with the difference.

By
Vamsi
Re: Period_Name column reference in GL_Balances and GL_Je_Lines tables [message #504236 is a reply to message #504029] Fri, 22 April 2011 13:44 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Same post on OTN too...
But not always dr - cr, it may be cr - dr, if the sum of credits is higher than sum of debits.

By
Vamsi
Previous Topic: utl_file_dir
Next Topic: Unable to add role to user in EBS
Goto Forum:
  


Current Time: Thu Mar 28 05:18:20 CDT 2024