EBS Inventory Subledger to ARCS

Hi

We are trying to load EBS Inventory to ARCS via the Integration Agent and have developed the below query.

Similar queries work well enough (we think) for AP, AR and FA. But performance is a problem for Inventory.

1. Can this be optimised?
2. Are we taking the correct approach?

SELECT /*+ LEADING (glp aeh) PARALLEL (aeh 4) */

   gcc.code_combination_id,

   gcc.segment1                                            AS "Entity",

   gcc.segment2                                            AS "Account",

   gcc.segment3                                            AS "CC",

   gcc.segment4                                            AS "Territory",

   gcc.segment5                                            AS "BusinessActivity",

   gcc.segment7                                            AS "Intercompany",

   gcc.segment8,

   gll.currency_code                                       AS "CurrencyCode",

   SUM(nvl(ael.accounted_dr, 0) - nvl(ael.accounted_cr, 0)) AS "Amount"