My Oracle Support Banner

XLA Common Accounting Drilldown for Project Accounting Transaction Categories Troubleshooting Guide (Doc ID 406204.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Project Costing - Version to 12.0.0 [Release 11.5.10 to 12.0]
Information in this document applies to any platform.
GLXIQACC.fmb - Account Inquiry form
XLAIQDRL.fmb - Subledger Expenditure Accounting form
XLAIQACL.fmb - Subledger Accounting form



The purpose of this document is to explain the functionality of the Common Accounting Module (XLA) specifically in relation to the transaction categories belonging to Project Accounting and identify and possibly help resolve some of the drilldown issues for PA transactions imported into GL.   XLA drilldown was introduced in release 11i and allows the user to drill down to the subledger form (such as Expenditure Inquiry in Projects) for transactions interfaced and imported in detail. One example of XLA drilldown functionality is accomplished using the GL module administrator (XLAIQDRL.fmb) drilldown and has the following navigation path:

GL responsibility: Inquiry: Journal > Account Inquiry form (GLXIQACC.fmb) (enter GL account based on Project source query in Journal Entry Inquiry form): ‘Show Journal Details’: ‘Drilldown’ > Subledger Expenditure Accounting form (XLAIQDRL.fmb): ‘Show Transaction’ > Subledger form (e.g.: PAXTRAPE.fmb): ‘Show Transaction Accounting’ > Subledger Accounting form (XLAIQACL.fmb)

The XLA features are documented as part of the core product documentation that uses XLA.   

In release 11i, the drilldown is supported for specific journal entry sources and categories.  Before reporting a drilldown bug, please make sure that the journal entry source and category is supported by XLA.   The XLA drilldown is available for Project Accounting in 11i for the following journal entry categories for costing:
Labor Cost, Miscellaneous Transaction, Revenue, Total Burdened Cost, Usage Cost.
… and uses the main views: XLA_PA_EI_AEL_GL_V and PA_AEL_GL_EI_V.

For revenue the XLA drilldown uses the views: XLA_PA_DR_AEL_GL_V and PA_AEL_GL_DR_V.   PA batches of the revenue category are handled by Project Billing.

Other PA and Multiple Reporting Currencies (MRC) related XLA drilldown views used are:


Refer to the eTRM for more information on these views and the associated XLA packages.  Also refer to the online Oracle Applications Release 11.5.10 Documentation CD for complete information on Oracle Financials and Oracle General Ledger/XLA.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Troubleshooting Steps
 FAQs and Current Issues:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.