Ability to Join Reversal Columns from GL Journals to Subledgers Journals in OTBI

Jason T S

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): FedEx

Description (Required): When I try to add Reversal Columns from the GL Journals Real Time Subject Area to a report that combines columns GL Journals Real Time Subject Area and Subledgers Accounting - Journals Real Time Subject Area I receive an error and no results are produced. I believe this is a bug because the Reversal Columns describe the Journal Name which is a column in the report and other columns are able to be added that describe the Journal Name column are able to be added without the report producing an error.

Use Case and Business Need (Required): In OTBI the GL Subject Areas do not have Debit or Credit Accounted Line Amounts, they have Debit or Credit Total Amounts. Because of this if I a User wants to see what line by line transaction make up a Journal, the User needs to take information from GL Journals Real Time Subject Area and Subledgers Accounting - Journals Real Time Subject Area and do so. When adding the columns Ledger Name, Balancing Segment Code, Journal Name, Journal Source, Journal Header Identifier, Journal Number, Line Description, Accounted Line Debit Amount, Accounted Line Credited Amount, Posting Status, Transaction Number, Accounting Date, Accounting Period Name, Supplier Name, and Supplier Info the report works fine. However, whenever I try to add the Reversal Status or the Reversal Period column from the GL subject area, the report produces quickly produces an error.

Error Message is attached

114_OTBI_GL_v_Sublegers_-_SR (2).docx

Enhancement Request / Service Request: 3-29179901701