EBS Inventory Subledger to ARCS — Cloud Customer Connect
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

EBS Inventory Subledger to ARCS

Received Response
21
Views
1
Comments

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"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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