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

Access to Fusion transactional tables (GL_JE_LINES, XLA, PJC, CMR) using Fusion Data Intelligence

edited Jan 14, 2026 4:39PM in Reporting and Analytics for ERP 4 comments

Hi,

I need to analyze data that in Fusion transactional schema is stored in tables such as:

  • GL_JE_LINES
  • XLA_DISTRIBUTION_LINKS
  • PJC_EXP_ITEMS_ALL
  • CMR_RCV_DISTRIBUTIONS

We are starting to use Oracle Fusion Data Intelligence (FDI), and so far the only supported way I see to access data is through Subject Areas provided by Oracle.

I have reviewed the official documentation:

However, I could not find:

  • Whether all the information from those transactional tables is available in FDI
  • If Oracle provides physical table mappings (Fusion table → FDI table/view)

My questions are:

  1. Is it possible to access data equivalent to those tables directly in FDI (for example through ADW or exposed views)?
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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