E-Business Suite General Ledger GL 사전 초기 설정된 쿼리 참조

사전에 초기 설정된 쿼리를 사용하여 Oracle E-Business Suite 소스에서 General Ledger 잔액을 임포트한 후 EPM Integration Agent를 사용하여 Oracle Enterprise Performance Management Cloud 타겟 애플리케이션으로 로드할 수 있는 애플리케이션을 생성하고 등록할 수 있습니다.

Note:

원장과 기간은 E-Business Suite 사전 초기 설정 쿼리를 사용하는 데 필요한 매개변수입니다.

다음 코드는 EPM Integration Agent와 함께 제공되는 사전 빌드된 E-Business Suite 쿼리를 보여 줍니다. 사용자정의 쿼리를 빌드하기 위한 시작점으로 이 쿼리를 사용할 수 있습니다.

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~