Hello Team,
could you please help me with error below?
create materialized view bi\_gl\_balancesv4 BUILD IMMEDIATE REFRESH FAST as
SELECT GLB.rowid ROWID1,glc.rowid ROWID2,glg.rowid ROWID3,GLB.BUDGET_VERSION_ID BUDGET_VERSION,
glc.segment1
Company,
glc.segment2
CostCentre,
glc.segment3
Account,
glc.segment4
SubAccount,
glc.segment5
LOB,
glc.segment6
Partner,
glc.segment7
Project,
glc.segment8
Flow,
glc.segment9
Intercompany,
glc.segment10
Spare,
glc.summary_flag,
glc.ACCOUNT_TYPE
account_type,
GLB.period_name,
GLB.PERIOD_YEAR,
GLB.period_num,
GLB.actual_flag,
SUM (
NVL (GLB.begin_balance_dr, 0) - NVL (GLB.begin_balance_cr, 0))
BeginBalance,
SUM (NVL (GLB.period_net_dr, 0) - NVL (GLB.period_net_cr, 0))
PTDBalance,
SUM (
NVL (GLB.begin_balance_dr, 0)
- NVL (GLB.begin_balance_cr, 0)
+ NVL (GLB.period_net_dr, 0)
- NVL (GLB.period_net_cr, 0))
YTDBalance,
GLB.CURRENCY_CODE
FROM gl_balances GLB,
gl_code_combinations glc,
gl_ledgers glg
WHERE glc.code_combination_id = GLB.code_combination_id
AND glg.ledger_id = GLB.ledger_id
AND glg.currency_code = GLB.currency_code
AND glc.summary_flag = 'N'
AND actual_flag <> 'E'
GROUP BY GLB.rowid,glc.rowid,glg.rowid,GLB.BUDGET_VERSION_ID,
glc.segment1,
glc.segment2,
glc.segment3,
glc.segment4,
glc.segment5,
glc.segment6,
glc.segment7,
glc.segment8,
glc.segment9,
glc.segment10,
glc.ACCOUNT_TYPE,
-- gl_lookups.description,
glc.summary_flag,
glc.account_type,
GLB.period_name,
GLB.PERIOD_YEAR,
GLB.period_num,
GLB.actual_flag,
GLB.CURRENCY_CODE;
ORA-12033: cannot use filter columns from materialized view log on
"GL"."GL_LEDGERS"
Thanks,
Roshan