Tuesday, 12 July 2016

To Check Reversal Periods not assigned to Auto Reversal Category (Query) - Oracle EBS R12

http://generalledger-gl.blogspot.com/2016/07/to-check-reversal-periods-not-assigned.html

To Check Reversal Periods not assigned to Auto Reversal Category

select * from gl_je_headers yy
where 1=1
and yy.JE_CATEGORY in ('2','35','9','41','47')
and yy.ACCRUAL_REV_PERIOD_NAME is null
and yy.REVERSED_JE_HEADER_ID is null
and (yy.RUNNING_TOTAL_DR <>0 or yy.RUNNING_TOTAL_CR <>0)

No comments:

Post a Comment