You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Joining Subledger data with GL data

Accepted answer
33
Views
2
Comments
edited Jun 15, 2023 11:52PM in Reporting and Analytics for ERP 2 comments

I need to build a query which joins subledger data table, xla_ae_lines to gl_je_lines. I am attempting this through gl_sl_link_id but the performance is awful, is there a prescriptive way to accomplish this or possibly should i use different tables. My end goal is to get to the Journal source.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!