General Ledger - EBS (MOSC)

MOSC Banner

View gl_je_journal_lines_v not returning any data in R12

edited Jul 18, 2019 7:50AM in General Ledger - EBS (MOSC) 7 commentsAnswered

Hello All,

   Database view View gl_je_journal_lines_v not returning any data in R12. Is this view still relevant? What can be done to retrieve data from query like below:

SELECT BATCH_NAME as batch, HEADER_NAME as Juneral_Entry, JE_SOURCE as Source,

                 LINE_JE_LINE_NUM, LINE_ENTERED_DR_NUM as Entered_Debit,

                 LINE_ENTERED_CR_NUM as Entered_Credit, JE_HEADER_ID, PERIOD_NAME

            FROM apps.GL_JE_JOURNAL_LINES_V,

                 apps.GL_SUMMARY_COMBINATIONS_V

            WHERE GL_JE_JOURNAL_LINES_V.line_code_combination_id = GL_SUMMARY_COMBINATIONS_V.CODE_COMBINATION_ID

            and   nvl(batch_status, ' ') = 'P'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center