Vous pouvez utiliser une requête prédéfinie pour importer des soldes GL à partir de sources Oracle E-Business Suite, puis créer et enregistrer une application pouvant être chargée vers les applications cible Oracle Enterprise Performance Management Cloud à l'aide de l'agent d'intégration EPM.
Note:
Le livre et la période sont des paramètres requis pour utiliser la requête prédéfinie E-Business Suite.
Voici la requête prédéfinie E-Business Suite fournie avec l'agent d'intégration EPM. Vous pouvez utiliser cette requête comme point de départ pour créer une requête personnalisée.
SELECT
gcc.SEGMENT1 as "Segment1",
gcc.SEGMENT2 as "Segment2",
gcc.SEGMENT3 as "Segment3",
gcc.SEGMENT4 as "Segment4",
gcc.SEGMENT5 as "Segment5",
gcc.SEGMENT6 as "Segment6",
gcc.SEGMENT7 as "Segment7",
gcc.SEGMENT8 as "Segment8",
gcc.SEGMENT9 as "Segment9",
gcc.SEGMENT10 as "Segment10",
gcc.SEGMENT11 as "Segment11",
gcc.SEGMENT12 as "Segment12",
gcc.SEGMENT13 as "Segment13",
gcc.SEGMENT14 as "Segment14",
gcc.SEGMENT15 as "Segment15",
gcc.SEGMENT16 as "Segment16",
gcc.SEGMENT17 as "Segment17",
gcc.SEGMENT18 as "Segment18",
gcc.SEGMENT19 as "Segment19",
gcc.SEGMENT20 as "Segment20",
gcc.SEGMENT21 as "Segment21",
gcc.SEGMENT22 as "Segment22",
gcc.SEGMENT23 as "Segment23",
gcc.SEGMENT24 as "Segment24",
gcc.SEGMENT25 as "Segment25",
gcc.SEGMENT26 as "Segment26",
gcc.SEGMENT27 as "Segment27",
gcc.SEGMENT28 as "Segment28",
gcc.SEGMENT29 as "Segment29",
gcc.SEGMENT30 as "Segment30",
gb.BEGIN_BALANCE_DR as "Beg Balance DR",
gb.BEGIN_BALANCE_CR as "Beg Balance CR",
gb.PERIOD_NET_DR as "Period Net DR",
gb.PERIOD_NET_CR as "Period Net CR",
(gb.BEGIN_BALANCE_DR - gb.BEGIN_BALANCE_CR) + (gb.PERIOD_NET_DR-gb.PERIOD_NET_CR) as "YTD Balance",
(gb.PERIOD_NET_DR-gb.PERIOD_NET_CR) as "Periodic Balance",
CASE
WHEN ACCOUNT_TYPE IN (''A'',''L'',''O'') THEN ((gb.BEGIN_BALANCE_DR-gb.BEGIN_BALANCE_CR) + (gb.PERIOD_NET_DR-gb.PERIOD_NET_CR))
WHEN ACCOUNT_TYPE IN (''R'', ''E'') THEN (gb.PERIOD_NET_DR-gb.PERIOD_NET_CR)
ELSE (gb.PERIOD_NET_DR-gb.PERIOD_NET_CR)
END as "Balance by Acct Type",
gb.BEGIN_BALANCE_DR_BEQ as "Func Eq Beg Bal DR",
gb.BEGIN_BALANCE_CR_BEQ as "Func Eq Beg Bal CR",
gb.PERIOD_NET_DR_BEQ as "Func Eq Period Net DR",
gb.PERIOD_NET_CR_BEQ as "Func Eq Period Net CR",
(gb.BEGIN_BALANCE_DR_BEQ - gb.BEGIN_BALANCE_CR_BEQ) + (gb.PERIOD_NET_DR_BEQ-gb.PERIOD_NET_CR_BEQ) as "Func Eq YTD Balance ",
(gb.PERIOD_NET_DR_BEQ-gb.PERIOD_NET_CR_BEQ) as "Func Eq Periodic Balance",
CASE
WHEN ACCOUNT_TYPE IN (''A'',''L'',''Q'') THEN ((gb.BEGIN_BALANCE_DR-gb.BEGIN_BALANCE_CR) + (gb.PERIOD_NET_DR-gb.PERIOD_NET_CR))
WHEN ACCOUNT_TYPE IN (''R'', ''E'') THEN (gb.PERIOD_NET_DR-gb.PERIOD_NET_CR)
ELSE (gb.PERIOD_NET_DR-gb.PERIOD_NET_CR)
END as "Func Eq Balance by Acct Type",
gld.LEDGER_ID as "Ledger ID",
gld.NAME as "Ledger Name",
gb.PERIOD_YEAR as "Period Year",
gb.PERIOD_NAME as "Period Name",
gb.PERIOD_NUM as "Perion Number",
gcc.ACCOUNT_TYPE as "Acoount Type",
gb.CODE_COMBINATION_ID as "Code Combination ID",
gb.CURRENCY_CODE as "Currecy Code",
gb.ACTUAL_FLAG as "Balance Type",
gb.BUDGET_VERSION_ID as "Budget Version ID",
gb.ENCUMBRANCE_TYPE_ID as "Encumbrance Type ID",
gb.TRANSLATED_FLAG as "Translated",
gb.PERIOD_TYPE as "Period Type",
gcc.ENABLED_FLAG as "Enabled",
gcc.SUMMARY_FLAG as "Summary Account"
FROM GL_BALANCES gb
,GL_CODE_COMBINATIONS gcc
,GL_LEDGERS gld
WHERE (1=1)
AND gcc.CODE_COMBINATION_ID = gb.CODE_COMBINATION_ID
AND gb.ACTUAL_FLAG = ''A''
AND gb.TEMPLATE_ID IS NULL
AND gld.LEDGER_ID = gb.LEDGER_ID
AND gld.NAME = ~LEDGER~
AND gb.PERIOD_NAME = ~PERIOD~