EBS Inventory Subledger to ARCS
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.
- Can this be optimised?
- Are we taking the correct approach?
SELECT /*+ LEADING (glp aeh) PARALLEL (aeh 4) */
gcc.segment1 AS "Entity",
gcc.segment2 AS "Account",
gcc.segment3 AS "CC",
gcc.segment4 AS "Territory",
gcc.segment5 AS "BusinessActivity",
gcc.segment7 AS "Intercompany",
gll.currency_code AS "CurrencyCode",
SUM(nvl(ael.accounted_dr, 0) - nvl(ael.accounted_cr, 0)) AS "Amount"