How to find the reversal journal details of a journal in EBS

 When a journal is reversed, the following fields will be populated in the Original Journal related to the Reversal Journal: ACCRUAL_REV_FLAG, ACCRUAL_REV_STATUS, ACCRUAL_REV_JE_HEADER_ID, ACCRUAL_REV_PERIOD_NAME, ACCRUAL_REV_EFFECTIVE_DATE

Execute below query to identify the reversal journal. The below query will give you the reversed journal header name, header id and period.

SELECT
    glhr.je_batch_id    "Reversal JE Batch ID",
    glhr.name           "Reversal JE Name",
    glhr.je_header_id   "Reversal JE Header ID",
    glhr.period_name    "Reversal JE Period Name"
FROM
    gl_je_headers   glho,
    gl_je_headers   glhr
WHERE
    glho.accrual_rev_je_header_id = glhr.je_header_id
    AND glho.accrual_rev_je_header_id IS NOT NULL
    AND glho.je_header_id = &je_header_id;