Hi All,
I need your inputs for the error im facing while running my mapping.
its failing at insert new rows step. This was working fine in 11g. Any suggestion to troubleshoot the same.
PLP_GLBalanceAggrByAcctSegCodes.W_GL_BALANCE_A using ikm: IKM BIAPPS Oracle Period Delete Append.
Error message below:
com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
Task: 100
java.lang.Exception: BeanShell script error: Parse error at line 151, column 3. Encountered: if BSF info: null at line: 0 column: columnNo
at com.sunopsis.dwg.codeinterpretor.SnpTaskNameCodeInterpretor.transform(SnpTaskNameCodeInterpretor.java:547)
at oracle.odi.runtime.agent.execution.interpreter.SessionTaskCodeInterpreter.applyAdditionalTransformations(SessionTaskCodeInterpreter.java:233)
at oracle.odi.runtime.agent.execution.interpreter.SessionTaskCodeInterpreter.codeInterpretation(SessionTaskCodeInterpreter.java:187)
at oracle.odi.runtime.agent.execution.interpreter.SessionTaskCodeInterpreter.codeInterpretation(SessionTaskCodeInterpreter.java:80)
at oracle.odi.runtime.agent.execution.SessionTask.createTaskLog(SessionTask.java:359)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:843)
at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225)
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.bsf.BSFException: BeanShell script error: Parse error at line 151, column 3. Encountered: if BSF info: null at line: 0 column: columnNo
at bsh.util.BeanShellBSFEngine.eval(Unknown Source)
at bsh.util.BeanShellBSFEngine.exec(Unknown Source)
at com.sunopsis.dwg.codeinterpretor.SnpTaskNameCodeInterpretor.transform(SnpTaskNameCodeInterpretor.java:537)
... 22 more
Text:
insert <$ if (bulkClause.equals("Y")) { $> /*+ append */ <$}$> into ADWX4_DW.W_GL_BALANCE_A
(
LEDGER_WID,
BALANCING_SEGMENT_WID,
COMPANY_ORG_WID,
BUSN_AREA_ORG_WID,
BALANCE_DT_WID,
BALANCE_TM_WID,
TREASURY_SYMBOL_WID,
GL_DATASET_SEC_WID,
DB_CR_IND,
TRANSLATED_FLAG,
ACCT_CURR_CODE,
LOC_CURR_CODE,
BALANCE_ACCT_AMT,
BALANCE_LOC_AMT,
BALANCE_GLOBAL1_AMT,
BALANCE_GLOBAL2_AMT,
BALANCE_GLOBAL3_AMT,
ACTIVITY_ACCT_AMT,
ACTIVITY_LOC_AMT,
ACTIVITY_GLOBAL1_AMT,
ACTIVITY_GLOBAL2_AMT,
ACTIVITY_GLOBAL3_AMT,
SEGMENT2_WID,
SEGMENT4_WID,
SEGMENT5_WID,
SEGMENT6_WID,
DATASOURCE_NUM_ID,
TENANT_ID,
GROUP_ACCT_WID,
MCAL_CAL_WID,
NATURAL_ACCOUNT_WID,
COST_CENTER_WID,
BUDGET_PERIOD_WID,
BALANCE_TYPE_WID,
CARRY_FORWARD_ACCT_AMT,
CARRY_FORWARD_LOC_AMT,
CARRY_FORWARD_GLOBAL1_AMT,
CARRY_FORWARD_GLOBAL2_AMT,
CARRY_FORWARD_GLOBAL3_AMT,
FINANCIAL_GL_FLG,
BUDGETARY_CONTROL_FLG,
SEG_PROJECT_WID,
SEG_PROGRAM_WID,
BUDGET_WID,
BUDGET_LEDGER_WID,
BUDGET_MCAL_CAL_WID,
XX_ORG_HIER_WID,
XX_GAAP_EXCH_RATE_WID,
XX_FIXED_EXCH_RATE_WID,
XFQTD_DAILY_ACTIVITY_ACCT_AMT,
XFQTD_DAILY_ACTIVITY_LOC_AMT,
X_BALANCE_DT_DAY_D_WID,
XFPTD_DAILY_ACTIVITY_GAAP_AMT,
XFQTD_DAILY_ACTIVITY_GAAP_AMT,
XFYTD_DAILY_BALANCE_GAAP_AMT,
X_HFM_ADJ_FLG,
GL_ACCOUNT_WID,
MCAL_QTR_WID
,SEGMENT1_WID,
SEGMENT3_WID,
W_INSERT_DT,
W_UPDATE_DT,
PROFIT_CENTER_WID
)
select
LEDGER_WID,
BALANCING_SEGMENT_WID,
COMPANY_ORG_WID,
BUSN_AREA_ORG_WID,
BALANCE_DT_WID,
BALANCE_TM_WID,
TREASURY_SYMBOL_WID,
GL_DATASET_SEC_WID,
DB_CR_IND,
TRANSLATED_FLAG,
ACCT_CURR_CODE,
LOC_CURR_CODE,
BALANCE_ACCT_AMT,
BALANCE_LOC_AMT,
BALANCE_GLOBAL1_AMT,
BALANCE_GLOBAL2_AMT,
BALANCE_GLOBAL3_AMT,
ACTIVITY_ACCT_AMT,
ACTIVITY_LOC_AMT,
ACTIVITY_GLOBAL1_AMT,
ACTIVITY_GLOBAL2_AMT,
ACTIVITY_GLOBAL3_AMT,
SEGMENT2_WID,
SEGMENT4_WID,
SEGMENT5_WID,
SEGMENT6_WID,
DATASOURCE_NUM_ID,
TENANT_ID,
GROUP_ACCT_WID,
MCAL_CAL_WID,
NATURAL_ACCOUNT_WID,
COST_CENTER_WID,
BUDGET_PERIOD_WID,
BALANCE_TYPE_WID,
CARRY_FORWARD_ACCT_AMT,
CARRY_FORWARD_LOC_AMT,
CARRY_FORWARD_GLOBAL1_AMT,
CARRY_FORWARD_GLOBAL2_AMT,
CARRY_FORWARD_GLOBAL3_AMT,
FINANCIAL_GL_FLG,
BUDGETARY_CONTROL_FLG,
SEG_PROJECT_WID,
SEG_PROGRAM_WID,
BUDGET_WID,
BUDGET_LEDGER_WID,
BUDGET_MCAL_CAL_WID,
XX_ORG_HIER_WID,
XX_GAAP_EXCH_RATE_WID,
XX_FIXED_EXCH_RATE_WID,
XFQTD_DAILY_ACTIVITY_ACCT_AMT,
XFQTD_DAILY_ACTIVITY_LOC_AMT,
X_BALANCE_DT_DAY_D_WID,
XFPTD_DAILY_ACTIVITY_GAAP_AMT,
XFQTD_DAILY_ACTIVITY_GAAP_AMT,
XFYTD_DAILY_BALANCE_GAAP_AMT,
X_HFM_ADJ_FLG,
GL_ACCOUNT_WID,
MCAL_QTR_WID
,0,
0,
SYSDATE,
SYSDATE,
0
FROM (
select
GL_BALANCE_SQ_FIL.LEDGER_WID LEDGER_WID,
GL_BALANCE_SQ_FIL.BALANCING_SEGMENT_WID BALANCING_SEGMENT_WID,
GL_BALANCE_SQ_FIL.COMPANY_ORG_WID COMPANY_ORG_WID,
GL_BALANCE_SQ_FIL.BUSN_AREA_ORG_WID BUSN_AREA_ORG_WID,
GL_BALANCE_SQ_FIL.BALANCE_DT_WID BALANCE_DT_WID,
GL_BALANCE_SQ_FIL.BALANCE_TM_WID BALANCE_TM_WID,
GL_BALANCE_SQ_FIL.TREASURY_SYMBOL_WID TREASURY_SYMBOL_WID,
GL_BALANCE_SQ_FIL.GL_DATASET_SEC_WID GL_DATASET_SEC_WID,
GL_BALANCE_SQ_FIL.DB_CR_IND DB_CR_IND,
GL_BALANCE_SQ_FIL.TRANSLATED_FLAG TRANSLATED_FLAG,
GL_BALANCE_SQ_FIL.ACCT_CURR_CODE ACCT_CURR_CODE,
GL_BALANCE_SQ_FIL.LOC_CURR_CODE LOC_CURR_CODE,
GL_BALANCE_SQ_FIL.BALANCE_ACCT_AMT BALANCE_ACCT_AMT,
GL_BALANCE_SQ_FIL.BALANCE_LOC_AMT BALANCE_LOC_AMT,
GL_BALANCE_SQ_FIL.BALANCE_GLOBAL1_AMT BALANCE_GLOBAL1_AMT,
GL_BALANCE_SQ_FIL.BALANCE_GLOBAL2_AMT BALANCE_GLOBAL2_AMT,
GL_BALANCE_SQ_FIL.BALANCE_GLOBAL3_AMT BALANCE_GLOBAL3_AMT,
GL_BALANCE_SQ_FIL.ACTIVITY_ACCT_AMT ACTIVITY_ACCT_AMT,
GL_BALANCE_SQ_FIL.ACTIVITY_LOC_AMT ACTIVITY_LOC_AMT,
GL_BALANCE_SQ_FIL.ACTIVITY_GLOBAL1_AMT ACTIVITY_GLOBAL1_AMT,
GL_BALANCE_SQ_FIL.ACTIVITY_GLOBAL2_AMT ACTIVITY_GLOBAL2_AMT,
GL_BALANCE_SQ_FIL.ACTIVITY_GLOBAL3_AMT ACTIVITY_GLOBAL3_AMT,
GL_BALANCE_SQ_FIL.GL_SEGMENT2_WID SEGMENT2_WID,
GL_BALANCE_SQ_FIL.GL_SEGMENT4_WID SEGMENT4_WID,
GL_BALANCE_SQ_FIL.GL_SEGMENT5_WID SEGMENT5_WID,
GL_BALANCE_SQ_FIL.GL_SEGMENT6_WID SEGMENT6_WID,
GL_BALANCE_SQ_FIL.DATASOURCE_NUM_ID DATASOURCE_NUM_ID,
GL_BALANCE_SQ_FIL.TENANT_ID TENANT_ID,
GL_BALANCE_SQ_FIL.GROUP_ACCT_WID GROUP_ACCT_WID,
GL_BALANCE_SQ_FIL.MCAL_CAL_WID MCAL_CAL_WID,
GL_BALANCE_SQ_FIL.NATURAL_ACCOUNT_WID NATURAL_ACCOUNT_WID,
GL_BALANCE_SQ_FIL.COST_CENTER_WID COST_CENTER_WID,
GL_BALANCE_SQ_FIL.BUDGET_PERIOD_WID BUDGET_PERIOD_WID,
GL_BALANCE_SQ_FIL.BALANCE_TYPE_WID BALANCE_TYPE_WID,
GL_BALANCE_SQ_FIL.CARRY_FORWARD_ACCT_AMT CARRY_FORWARD_ACCT_AMT,
GL_BALANCE_SQ_FIL.CARRY_FORWARD_LOC_AMT CARRY_FORWARD_LOC_AMT,
GL_BALANCE_SQ_FIL.CARRY_FORWARD_GLOBAL1_AMT CARRY_FORWARD_GLOBAL1_AMT,
GL_BALANCE_SQ_FIL.CARRY_FORWARD_GLOBAL2_AMT CARRY_FORWARD_GLOBAL2_AMT,
GL_BALANCE_SQ_FIL.CARRY_FORWARD_GLOBAL3_AMT CARRY_FORWARD_GLOBAL3_AMT,
GL_BALANCE_SQ_FIL.FINANCIAL_GL_FLG FINANCIAL_GL_FLG,
GL_BALANCE_SQ_FIL.BUDGETARY_CONTROL_FLG BUDGETARY_CONTROL_FLG,
GL_BALANCE_SQ_FIL.SEG_PROJECT_WID SEG_PROJECT_WID,
GL_BALANCE_SQ_FIL.SEG_PROGRAM_WID SEG_PROGRAM_WID,
GL_BALANCE_SQ_FIL.BUDGET_WID BUDGET_WID,
GL_BALANCE_SQ_FIL.BUDGET_LEDGER_WID BUDGET_LEDGER_WID,
GL_BALANCE_SQ_FIL.BUDGET_MCAL_CAL_WID BUDGET_MCAL_CAL_WID,
nvl(GL_BALANCE_SQ_FIL.XX_ORG_HIER_WID,0) XX_ORG_HIER_WID,
GL_BALANCE_SQ_FIL.XX_GAAP_EXCH_RATE_WID XX_GAAP_EXCH_RATE_WID,
GL_BALANCE_SQ_FIL.XX_FIXED_EXCH_RATE_WID XX_FIXED_EXCH_RATE_WID,
GL_BALANCE_SQ_FIL.XFQTD_DAILY_ACTIVITY_ACCT_AMT XFQTD_DAILY_ACTIVITY_ACCT_AMT,
GL_BALANCE_SQ_FIL.XFQTD_DAILY_ACTIVITY_LOC_AMT XFQTD_DAILY_ACTIVITY_LOC_AMT,
substr(GL_BALANCE_SQ_FIL.BALANCE_DT_WID,length(GL_BALANCE_SQ_FIL.BALANCE_DT_WID)-10,8) X_BALANCE_DT_DAY_D_WID,
GL_BALANCE_SQ_FIL.XFPTD_DAILY_ACTIVITY_GAAP_AMT XFPTD_DAILY_ACTIVITY_GAAP_AMT,
GL_BALANCE_SQ_FIL.XFQTD_DAILY_ACTIVITY_GAAP_AMT XFQTD_DAILY_ACTIVITY_GAAP_AMT,
GL_BALANCE_SQ_FIL.XFYTD_DAILY_BALANCE_GAAP_AMT XFYTD_DAILY_BALANCE_GAAP_AMT,
'U' X_HFM_ADJ_FLG,
GL_BALANCE_SQ_FIL.GL_ACCOUNT_WID GL_ACCOUNT_WID,
GL_BALANCE_SQ_FIL.MCAL_QTR_WID MCAL_QTR_WID
from <$
//Print the hint based on options passed.
String semicolon = new Character((char)59).toString();
String space = new Character((char)32).toString();
String equalto = new Character((char)61).toString();
String rbrace = new Character((char)40).toString();
String comma = new Character((char)44).toString();
$>
( /* Subselect from PLP_GLBalanceAggrByAcctSegCodes.W_GL_BALANCE_A
*/
<$
String derhintOption="";
String derhintstr="";
String[] derDSHints;
boolean derhasHintPrefix=false;
boolean derhasDSHints=false;
String[] derhintList=derhintOption.split(semicolon);
for (int i=0; i<derhintList.length; i++) {
String dercurrhint =derhintList[i].replaceAll("\s+$|^\s+", ""); //replace all leading and ending whitespaces
String[] derhintwords=dercurrhint.split(equalto);
String derhintprefixNoTrim=derhintwords[0].toUpperCase();
String derhintprefix=derhintprefixNoTrim.replaceAll("\s+$|^\s+", ""); //replace all leading and ending whitespaces
if (derhintprefix.equals("INCR")) { derhasHintPrefix=true; }
else if (derhintprefix.equals("FULL")) { derhasHintPrefix=true;}
if (derhintprefix.equals("INCR")&&("#BIAPPS.IS_INCREMENTAL".equals("Y"))) {
derhintstr=dercurrhint.substring(derhintprefixNoTrim.toCharArray().length+1);//Remove the INCR prefix
} else if (derhintprefix.equals("FULL")&&(!("#BIAPPS.IS_INCREMENTAL".equals("Y")))) {
derhintstr=dercurrhint.substring(derhintprefixNoTrim.toCharArray().length+1);//Remove the FULL prefix
} else if ((i==0) && (!derhasHintPrefix)) { derhintstr=dercurrhint; }
//Check if we have Dataset Specific hints.
//If Hints start with Round Braces then you are using DS specific hints
//You should specify as many hints in the braces as number of Datasets
derhintstr=derhintstr.replaceAll("\s+$|^\s+", ""); //replace all leading and ending whitespaces
if (!derhintstr.equals("")) {
if (derhintstr.substring(0,1).equals(rbrace)){
derhintstr=derhintstr.substring(1).substring(0,derhintstr.toCharArray().length-2);//remove braces
derDSHints=derhintstr.split(comma);
derhasDSHints=true;
} //end check if hint starts with rbrace
} //end check hint length
}//end for loop hint strings
$>
select
<$ int dsnum;
dsnum=0;
if(derhasDSHints && (derDSHints.length>=dsnum+1)) {
//replace all below- remove all leading and trailing whitespaces
if (!derDSHints[dsnum].replaceAll("\s+$|^\s+", "").equals("NULL")) {
out.println(derDSHints[dsnum]);
}//end check if hint is null
}//check if dataset hints are present
else if (!derhasDSHints) { out.println(derhintstr); } $>
SQ_W_GL_BALANCE_F.BUSN_AREA_ORG_WID AS BUSN_AREA_ORG_WID,
SQ_W_GL_BALANCE_F.CARRY_FORWARD_GLOBAL1_AMT AS CARRY_FORWARD_GLOBAL1_AMT,
SQ_W_GL_BALANCE_F.LEDGER_WID AS LEDGER_WID,
SQ_W_GL_BALANCE_F.XFQTD_DAILY_ACTIVITY_LOC_AMT AS XFQTD_DAILY_ACTIVITY_LOC_AMT,
SQ_W_GL_BALANCE_F.BUDGET_PERIOD_WID AS BUDGET_PERIOD_WID,
SQ_W_GL_BALANCE_F.BUDGET_MCAL_CAL_WID AS BUDGET_MCAL_CAL_WID,
SQ_W_GL_BALANCE_F.BUDGETARY_CONTROL_FLG AS BUDGETARY_CONTROL_FLG,
SQ_W_GL_BALANCE_F.GL_DATASET_SEC_WID AS GL_DATASET_SEC_WID,
SQ_W_GL_BALANCE_F.GL_SEGMENT2_WID AS GL_SEGMENT2_WID,
SQ_W_GL_BALANCE_F.ACTIVITY_ACCT_AMT AS ACTIVITY_ACCT_AMT,
SQ_W_GL_BALANCE_F.CARRY_FORWARD_LOC_AMT AS CARRY_FORWARD_LOC_AMT,
SQ_W_GL_BALANCE_F.FINANCIAL_GL_FLG AS FINANCIAL_GL_FLG,
SQ_W_GL_BALANCE_F.SEG_PROGRAM_WID AS SEG_PROGRAM_WID,
SQ_W_GL_BALANCE_F.ACTIVITY_GLOBAL1_AMT AS ACTIVITY_GLOBAL1_AMT,
SQ_W_GL_BALANCE_F.XFQTD_DAILY_ACTIVITY_ACCT_AMT AS XFQTD_DAILY_ACTIVITY_ACCT_AMT,
SQ_W_GL_BALANCE_F.BALANCE_TM_WID AS BALANCE_TM_WID,
SQ_W_GL_BALANCE_F.TREASURY_SYMBOL_WID AS TREASURY_SYMBOL_WID,
SQ_W_GL_BALANCE_F.BALANCE_GLOBAL1_AMT AS BALANCE_GLOBAL1_AMT,
SQ_W_GL_BALANCE_F.MCAL_QTR_WID AS MCAL_QTR_WID,
SQ_W_GL_BALANCE_F.ACTIVITY_LOC_AMT AS ACTIVITY_LOC_AMT,
SQ_W_GL_BALANCE_F.TRANSLATED_FLAG AS TRANSLATED_FLAG,
SQ_W_GL_BALANCE_F.XX_FIXED_EXCH_RATE_WID AS XX_FIXED_EXCH_RATE_WID,
SQ_W_GL_BALANCE_F.ACCT_CURR_CODE AS ACCT_CURR_CODE,
SQ_W_GL_BALANCE_F.GL_SEGMENT4_WID AS GL_SEGMENT4_WID,
SQ_W_GL_BALANCE_F.BALANCE_ACCT_AMT AS BALANCE_ACCT_AMT,
SQ_W_GL_BALANCE_F.COST_CENTER_WID AS COST_CENTER_WID,
SQ_W_GL_BALANCE_F.BUDGET_LEDGER_WID AS BUDGET_LEDGER_WID,
SQ_W_GL_BALANCE_F.XX_PTD_GAAP_AMT AS XFPTD_DAILY_ACTIVITY_GAAP_AMT,
SQ_W_GL_BALANCE_F.GL_SEGMENT6_WID AS GL_SEGMENT6_WID,
SQ_W_GL_BALANCE_F.GROUP_ACCT_WID AS GROUP_ACCT_WID,
SQ_W_GL_BALANCE_F.GL_SEGMENT5_WID AS GL_SEGMENT5_WID,
SQ_W_GL_BALANCE_F.BALANCE_LOC_AMT AS BALANCE_LOC_AMT,
SUM (XX_PTD_GAAP_AMT
) OVER (PARTITION BY SQ_W_GL_BALANCE_F.LEDGER_WID,SQ_W_GL_BALANCE_F.BALANCE_TM_WID, SQ_W_GL_BALANCE_F.BUSN_AREA_ORG_WID,SQ_W_GL_BALANCE_F.TREASURY_SYMBOL_WID,
SQ_W_GL_BALANCE_F.COMPANY_ORG_WID, SQ_W_GL_BALANCE_F.BALANCING_SEGMENT_WID, SQ_W_GL_BALANCE_F.DB_CR_IND,SQ_W_GL_BALANCE_F.LOC_CURR_CODE, SQ_W_GL_BALANCE_F.ACCT_CURR_CODE,
SQ_W_GL_BALANCE_F.GL_SEGMENT5_WID,SQ_W_GL_BALANCE_F.GL_SEGMENT2_WID, SQ_W_GL_BALANCE_F.GL_SEGMENT6_WID,SQ_W_GL_BALANCE_F.NATURAL_ACCOUNT_WID, SQ_W_GL_BALANCE_F.COST_CENTER_WID,SQ_W_GL_BALANCE_F.MCAL_CAL_WID,
SQ_W_GL_BALANCE_F.GROUP_ACCT_WID,SQ_W_GL_BALANCE_F.XX_ORG_HIER_WID,SQ_W_GL_BALANCE_F.XX_FIXED_EXCH_RATE_WID, SQ_W_GL_BALANCE_F.DATASOURCE_NUM_ID, SQ_W_GL_BALANCE_F.GL_ACCOUNT_WID, SQ_W_GL_BALANCE_F.MCAL_QTR_WID
ORDER BY SQ_W_GL_BALANCE_F.BALANCE_DT_WID) AS XFQTD_DAILY_ACTIVITY_GAAP_AMT,
SQ_W_GL_BALANCE_F.BALANCE_GLOBAL3_AMT AS BALANCE_GLOBAL3_AMT,
SQ_W_GL_BALANCE_F.XX_ORG_HIER_WID AS XX_ORG_HIER_WID,
SQ_W_GL_BALANCE_F.BALANCE_TYPE_WID AS BALANCE_TYPE_WID,
SQ_W_GL_BALANCE_F.BALANCING_SEGMENT_WID AS BALANCING_SEGMENT_WID,
SQ_W_GL_BALANCE_F.NATURAL_ACCOUNT_WID AS NATURAL_ACCOUNT_WID,
SQ_W_GL_BALANCE_F.XX_GAAP_EXCH_RATE_WID AS XX_GAAP_EXCH_RATE_WID,
SQ_W_GL_BALANCE_F.BALANCE_GLOBAL2_AMT AS BALANCE_GLOBAL2_AMT,
SQ_W_GL_BALANCE_F.ACTIVITY_GLOBAL2_AMT AS ACTIVITY_GLOBAL2_AMT,
SQ_W_GL_BALANCE_F.BUDGET_WID AS BUDGET_WID,
SQ_W_GL_BALANCE_F.BALANCE_DT_WID AS BALANCE_DT_WID,
SQ_W_GL_BALANCE_F.CARRY_FORWARD_ACCT_AMT AS CARRY_FORWARD_ACCT_AMT,
SUM (XX_PTD_GAAP_AMT
) OVER (PARTITION BY SQ_W_GL_BALANCE_F.LEDGER_WID,SQ_W_GL_BALANCE_F.BALANCE_TM_WID, SQ_W_GL_BALANCE_F.BUSN_AREA_ORG_WID,SQ_W_GL_BALANCE_F.TREASURY_SYMBOL_WID,
SQ_W_GL_BALANCE_F.COMPANY_ORG_WID, SQ_W_GL_BALANCE_F.BALANCING_SEGMENT_WID, SQ_W_GL_BALANCE_F.DB_CR_IND,SQ_W_GL_BALANCE_F.LOC_CURR_CODE, SQ_W_GL_BALANCE_F.ACCT_CURR_CODE,
SQ_W_GL_BALANCE_F.GL_SEGMENT5_WID,SQ_W_GL_BALANCE_F.GL_SEGMENT2_WID, SQ_W_GL_BALANCE_F.GL_SEGMENT6_WID,SQ_W_GL_BALANCE_F.NATURAL_ACCOUNT_WID, SQ_W_GL_BALANCE_F.COST_CENTER_WID,SQ_W_GL_BALANCE_F.MCAL_CAL_WID,
SQ_W_GL_BALANCE_F.GROUP_ACCT_WID,SQ_W_GL_BALANCE_F.XX_ORG_HIER_WID,SQ_W_GL_BALANCE_F.XX_FIXED_EXCH_RATE_WID, SQ_W_GL_BALANCE_F.DATASOURCE_NUM_ID, SQ_W_GL_BALANCE_F.GL_ACCOUNT_WID, substr(SQ_W_GL_BALANCE_F.MCAL_QTR_WID,1,length(SQ_W_GL_BALANCE_F.MCAL_QTR_WID)-1)
ORDER BY SQ_W_GL_BALANCE_F.BALANCE_DT_WID) + nvl(YTD.XFYTD_DAILY_BALANCE_GAAP_AMT,0) AS XFYTD_DAILY_BALANCE_GAAP_AMT,
SQ_W_GL_BALANCE_F.CARRY_FORWARD_GLOBAL3_AMT AS CARRY_FORWARD_GLOBAL3_AMT,
SQ_W_GL_BALANCE_F.COMPANY_ORG_WID AS COMPANY_ORG_WID,
SQ_W_GL_BALANCE_F.SEG_PROJECT_WID AS SEG_PROJECT_WID,
SQ_W_GL_BALANCE_F.CARRY_FORWARD_GLOBAL2_AMT AS CARRY_FORWARD_GLOBAL2_AMT,
SQ_W_GL_BALANCE_F.MCAL_CAL_WID AS MCAL_CAL_WID,
SQ_W_GL_BALANCE_F.TENANT_ID AS TENANT_ID,
SQ_W_GL_BALANCE_F.GL_ACCOUNT_WID AS GL_ACCOUNT_WID,
SQ_W_GL_BALANCE_F.LOC_CURR_CODE AS LOC_CURR_CODE,
SQ_W_GL_BALANCE_F.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID,
SQ_W_GL_BALANCE_F.ACTIVITY_GLOBAL3_AMT AS ACTIVITY_GLOBAL3_AMT,
SQ_W_GL_BALANCE_F.DB_CR_IND AS DB_CR_IND
from ADWX4_DW.W_GL_BALANCE_A_YTD_LKP YTD RIGHT OUTER JOIN <$
//Print the hint based on options passed.
String semicolon = new Character((char)59).toString();
String space = new Character((char)32).toString();
String equalto = new Character((char)61).toString();
String rbrace = new Character((char)40).toString();
String comma = new Character((char)44).toString();
$>
( /* Subselect from PLP_GLBalanceAggrByAcctSegCodes.W_GL_BALANCE_A
*/
<$
String derhintOption="/*+ parallel(4) */";
String derhintstr="";
String[] derDSHints;
boolean derhasHintPrefix=false;
boolean derhasDSHints=false;
String[] derhintList=derhintOption.split(semicolon);
for (int i=0; i<derhintList.length; i++) {
String dercurrhint =derhintList[i].replaceAll("\s+$|^\s+", ""); //replace all leading and ending whitespaces
String[] derhintwords=dercurrhint.split(equalto);
String derhintprefixNoTrim=derhintwords[0].toUpperCase();
String derhintprefix=derhintprefixNoTrim.replaceAll("\s+$|^\s+", ""); //replace all leading and ending whitespaces
if (derhintprefix.equals("INCR")) { derhasHintPrefix=true; }
else if (derhintprefix.equals("FULL")) { derhasHintPrefix=true;}
if (derhintprefix.equals("INCR")&&("#BIAPPS.IS_INCREMENTAL".equals("Y"))) {
derhintstr=dercurrhint.substring(derhintprefixNoTrim.toCharArray().length+1);//Remove the INCR prefix
} else if (derhintprefix.equals("FULL")&&(!("#BIAPPS.IS_INCREMENTAL".equals("Y")))) {
derhintstr=dercurrhint.substring(derhintprefixNoTrim.toCharArray().length+1);//Remove the FULL prefix
} else if ((i==0) && (!derhasHintPrefix)) { derhintstr=dercurrhint; }
//Check if we have Dataset Specific hints.
//If Hints start with Round Braces then you are using DS specific hints
//You should specify as many hints in the braces as number of Datasets
derhintstr=derhintstr.replaceAll("\s+$|^\s+", ""); //replace all leading and ending whitespaces
if (!derhintstr.equals("")) {
if (derhintstr.substring(0,1).equals(rbrace)){
derhintstr=derhintstr.substring(1).substring(0,derhintstr.toCharArray().length-2);//remove braces
derDSHints=derhintstr.split(comma);
derhasDSHints=true;
} //end check if hint starts with rbrace
} //end check hint length
}//end for loop hint strings
$>
select
<$ int dsnum;
dsnum=0;
if(derhasDSHints && (derDSHints.length>=dsnum+1)) {
//replace all below- remove all leading and trailing whitespaces
if (!derDSHints[dsnum].replaceAll("\s+$|^\s+", "").equals("NULL")) {
out.println(derDSHints[dsnum]);
}//end check if hint is null
}//check if dataset hints are present
else if (!derhasDSHints) { out.println(derhintstr); } $>
W_GL_BALANCE_F.BUSN_AREA_ORG_WID AS BUSN_AREA_ORG_WID,
(SUM(W_GL_BALANCE_F.CARRY_FORWARD_GLOBAL1_AMT)) AS CARRY_FORWARD_GLOBAL1_AMT,
W_GL_BALANCE_F.LEDGER_WID AS LEDGER_WID,
W_GL_BALANCE_F.BUDGET_PERIOD_WID AS BUDGET_PERIOD_WID,
(sum(W_GL_BALANCE_F.XFQTD_DAILY_ACTIVITY_LOC_AMT)) AS XFQTD_DAILY_ACTIVITY_LOC_AMT,
W_GL_BALANCE_F.BUDGET_MCAL_CAL_WID AS BUDGET_MCAL_CAL_WID,
W_GL_BALANCE_F.BUDGETARY_CONTROL_FLG AS BUDGETARY_CONTROL_FLG,
W_GL_BALANCE_F.GL_DATASET_SEC_WID AS GL_DATASET_SEC_WID,
W_GL_BALANCE_F.GL_SEGMENT2_WID AS GL_SEGMENT2_WID,
(SUM(W_GL_BALANCE_F.ACTIVITY_ACCT_AMT)) AS ACTIVITY_ACCT_AMT,
(SUM(W_GL_BALANCE_F.CARRY_FORWARD_LOC_AMT)) AS CARRY_FORWARD_LOC_AMT,
W_GL_BALANCE_F.FINANCIAL_GL_FLG AS FINANCIAL_GL_FLG,
W_GL_BALANCE_F.SEG_PROGRAM_WID AS SEG_PROGRAM_WID,
(SUM(W_GL_BALANCE_F.ACTIVITY_GLOBAL1_AMT)) AS ACTIVITY_GLOBAL1_AMT,
(sum(W_GL_BALANCE_F.XFQTD_DAILY_ACTIVITY_ACCT_AMT)) AS XFQTD_DAILY_ACTIVITY_ACCT_AMT,
W_GL_BALANCE_F.BALANCE_TM_WID AS BALANCE_TM_WID,
W_GL_BALANCE_F.TREASURY_SYMBOL_WID AS TREASURY_SYMBOL_WID,
(SUM(W_GL_BALANCE_F.BALANCE_GLOBAL1_AMT)) AS BALANCE_GLOBAL1_AMT,
W_GL_BALANCE_F.MCAL_QTR_WID AS MCAL_QTR_WID,
(SUM(W_GL_BALANCE_F.ACTIVITY_LOC_AMT)) AS ACTIVITY_LOC_AMT,
W_GL_BALANCE_F.TRANSLATED_FLAG AS TRANSLATED_FLAG,
W_GL_BALANCE_F.XX_FIXED_EXCH_RATE_WID AS XX_FIXED_EXCH_RATE_WID,
W_GL_BALANCE_F.ACCT_CURR_CODE AS ACCT_CURR_CODE,
(SUM(W_GL_BALANCE_F.BALANCE_ACCT_AMT)) AS BALANCE_ACCT_AMT,
W_GL_BALANCE_F.GL_SEGMENT4_WID AS GL_SEGMENT4_WID,
W_GL_BALANCE_F.COST_CENTER_WID AS COST_CENTER_WID,
W_GL_BALANCE_F.BUDGET_LEDGER_WID AS BUDGET_LEDGER_WID,
SQ_W_GL_ACCOUNT_D.GROUP_ACCT_WID AS GROUP_ACCT_WID,
W_GL_BALANCE_F.GL_SEGMENT6_WID AS GL_SEGMENT6_WID,
W_GL_BALANCE_F.GL_SEGMENT5_WID AS GL_SEGMENT5_WID,
(SUM(W_GL_BALANCE_F.BALANCE_LOC_AMT)) AS BALANCE_LOC_AMT,
(SUM(W_GL_BALANCE_F.BALANCE_GLOBAL3_AMT)) AS BALANCE_GLOBAL3_AMT,
W_GL_BALANCE_F.XX_ORG_HIER_WID AS XX_ORG_HIER_WID,
W_GL_BALANCE_F.BALANCE_TYPE_WID AS BALANCE_TYPE_WID,
(sum(W_GL_BALANCE_F.ACTIVITY_LOC_AMT*WC_GAAP.EXCH_RATE)) AS XX_PTD_GAAP_AMT,
W_GL_BALANCE_F.BALANCING_SEGMENT_WID AS BALANCING_SEGMENT_WID,
W_GL_BALANCE_F.NATURAL_ACCOUNT_WID AS NATURAL_ACCOUNT_WID,
W_GL_BALANCE_F.XX_GAAP_EXCH_RATE_WID AS XX_GAAP_EXCH_RATE_WID,
(SUM(W_GL_BALANCE_F.BALANCE_GLOBAL2_AMT)) AS BALANCE_GLOBAL2_AMT,
(SUM(W_GL_BALANCE_F.ACTIVITY_GLOBAL2_AMT)) AS ACTIVITY_GLOBAL2_AMT,
W_GL_BALANCE_F.BUDGET_WID AS BUDGET_WID,
W_GL_BALANCE_F.BALANCE_DT_WID AS BALANCE_DT_WID,
(SUM(W_GL_BALANCE_F.CARRY_FORWARD_ACCT_AMT)) AS CARRY_FORWARD_ACCT_AMT,
(SUM(W_GL_BALANCE_F.CARRY_FORWARD_GLOBAL3_AMT)) AS CARRY_FORWARD_GLOBAL3_AMT,
W_GL_BALANCE_F.COMPANY_ORG_WID AS COMPANY_ORG_WID,
(SUM(W_GL_BALANCE_F.CARRY_FORWARD_GLOBAL2_AMT)) AS CARRY_FORWARD_GLOBAL2_AMT,
W_GL_BALANCE_F.SEG_PROJECT_WID AS SEG_PROJECT_WID,
W_GL_BALANCE_F.MCAL_CAL_WID AS MCAL_CAL_WID,
W_GL_BALANCE_F.TENANT_ID AS TENANT_ID,
W_GL_BALANCE_F.GL_ACCOUNT_WID AS GL_ACCOUNT_WID,
W_GL_BALANCE_F.LOC_CURR_CODE AS LOC_CURR_CODE,
W_GL_BALANCE_F.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID,
W_GL_BALANCE_F.DB_CR_IND AS DB_CR_IND,
(SUM(W_GL_BALANCE_F.ACTIVITY_GLOBAL3_AMT)) AS ACTIVITY_GLOBAL3_AMT
from (ADWX4_DW.W_GL_BALANCE_F W_GL_BALANCE_F INNER JOIN <$
//Print the hint based on options passed.
String semicolon = new Character((char)59).toString();
String space = new Character((char)32).toString();
String equalto = new Character((char)61).toString();
String rbrace = new Character((char)40).toString();
String comma = new Character((char)44).toString();
$>
( /* Subselect from PLP_GLBalanceAggrByAcctSegCodes.W_GL_BALANCE_A
*/
<$
String derhintOption="#BIAPPS.ETL_HINT_NESTED1";
String derhintstr="";
String[] derDSHints;
boolean derhasHintPrefix=false;
boolean derhasDSHints=false;
String[] derhintList=derhintOption.split(semicolon);
for (int i=0; i<derhintList.length; i++) {
String dercurrhint =derhintList[i].replaceAll("\s+$|^\s+", ""); //replace all leading and ending whitespaces
String[] derhintwords=dercurrhint.split(equalto);
String derhintprefixNoTrim=derhintwords[0].toUpperCase();
String derhintprefix=derhintprefixNoTrim.replaceAll("\s+$|^\s+", ""); //replace all leading and ending whitespaces
if (derhintprefix.equals("INCR")) { derhasHintPrefix=true; }
else if (derhintprefix.equals("FULL")) { derhasHintPrefix=true;}
if (derhintprefix.equals("INCR")&&("#BIAPPS.IS_INCREMENTAL".equals("Y"))) {
derhintstr=dercurrhint.substring(derhintprefixNoTrim.toCharArray().length+1);//Remove the INCR prefix
} else if (derhintprefix.equals("FULL")&&(!("#BIAPPS.IS_INCREMENTAL".equals("Y")))) {
derhintstr=dercurrhint.substring(derhintprefixNoTrim.toCharArray().length+1);//Remove the FULL prefix
} else if ((i==0) && (!derhasHintPrefix)) { derhintstr=dercurrhint; }
//Check if we have Dataset Specific hints.
//If Hints start with Round Braces then you are using DS specific hints
//You should specify as many hints in the braces as number of Datasets
derhintstr=derhintstr.replaceAll("\s+$|^\s+", ""); //replace all leading and ending whitespaces
if (!derhintstr.equals("")) {
if (derhintstr.substring(0,1).equals(rbrace)){
derhintstr=derhintstr.substring(1).substring(0,derhintstr.toCharArray().length-2);//remove braces
derDSHints=derhintstr.split(comma);
derhasDSHints=true;
} //end check if hint starts with rbrace
} //end check hint length
}//end for loop hint strings
$>
select
<$ int dsnum;
dsnum=0;
if(derhasDSHints && (derDSHints.length>=dsnum+1)) {
//replace all below- remove all leading and trailing whitespaces
if (!derDSHints[dsnum].replaceAll("\s+$|^\s+", "").equals("NULL")) {
out.println(derDSHints[dsnum]);
}//end check if hint is null
}//check if dataset hints are present
else if (!derhasDSHints) { out.println(derhintstr); } $>
W_GLACCT_GRPACCT_TMP.GROUP_ACCT_WID AS GROUP_ACCT_WID,
W_GLACCT_GRPACCT_TMP.GL_ACCOUNT_WID AS ROW_WID
from ADWX4_DW.W_GLACCT_GRPACCT_TMP W_GLACCT_GRPACCT_TMP
where (1=1)
) SQ_W_GL_ACCOUNT_D
ON W_GL_BALANCE_F.GL_ACCOUNT_WID=SQ_W_GL_ACCOUNT_D.ROW_WID
) LEFT OUTER JOIN ADWX4_DW.WC_GAAP_EXCH_RATE_G WC_GAAP
ON W_GL_BALANCE_F.XX_GAAP_EXCH_RATE_WID=WC_GAAP.ROW_WID
where (1=1)
and (substr(W_GL_BALANCE_F.BALANCE_DT_WID,length(W_GL_BALANCE_F.BALANCE_DT_WID)-2,3) <> '999') and (nvl(W_GL_BALANCE_F.ACTIVITY_ACCT_AMT,0)<>0
or nvl(W_GL_BALANCE_F.ACTIVITY_LOC_AMT,0)<>0
or nvl(W_GL_BALANCE_F.BALANCE_ACCT_AMT,0)<>0
or nvl(W_GL_BALANCE_F.BALANCE_LOC_AMT,0)<>0
or nvl(W_GL_BALANCE_F.CARRY_FORWARD_ACCT_AMT,0)<>0
or nvl(W_GL_BALANCE_F.CARRY_FORWARD_LOC_AMT,0)<>0
or nvl(W_GL_BALANCE_F.XFQTD_DAILY_ACTIVITY_ACCT_AMT,0)<>0
or nvl(W_GL_BALANCE_F.XFQTD_DAILY_ACTIVITY_LOC_AMT,0)<>0) and (<$$ if("#BIAPPS.IS_INCREMENTAL".toString().equalsIgnoreCase("Y")) {
/* Only run when job is incremental */ $$>
(W_GL_BALANCE_F.MCAL_QTR_WID IN (
SELECT DISTINCT prds.mcal_qtr_wid
FROM w_mcal_period_d prds, w_mcal_period_d curr
WHERE curr.w_current_mcal_period_code = 'Current'
AND curr.mcal_cal_wid = prds.mcal_cal_wid
AND prds.mcal_julian_period_num >=
curr.mcal_julian_period_num - #biapps.FSCL_PERIODS_TO_REFRESH))
<$$ } else {
/* Only run when job is full */ $$>
1=1
<$$ } $$>)
group by W_GL_BALANCE_F.BUSN_AREA_ORG_WID,W_GL_BALANCE_F.LEDGER_WID,W_GL_BALANCE_F.BUDGET_PERIOD_WID,W_GL_BALANCE_F.BUDGET_MCAL_CAL_WID,W_GL_BALANCE_F.BUDGETARY_CONTROL_FLG,W_GL_BALANCE_F.GL_DATASET_SEC_WID,W_GL_BALANCE_F.GL_SEGMENT2_WID,W_GL_BALANCE_F.FINANCIAL_GL_FLG,W_GL_BALANCE_F.SEG_PROGRAM_WID,W_GL_BALANCE_F.BALANCE_TM_WID,W_GL_BALANCE_F.TREASURY_SYMBOL_WID,W_GL_BALANCE_F.MCAL_QTR_WID,W_GL_BALANCE_F.TRANSLATED_FLAG,W_GL_BALANCE_F.XX_FIXED_EXCH_RATE_WID,W_GL_BALANCE_F.ACCT_CURR_CODE,W_GL_BALANCE_F.GL_SEGMENT4_WID,W_GL_BALANCE_F.COST_CENTER_WID,W_GL_BALANCE_F.BUDGET_LEDGER_WID,SQ_W_GL_ACCOUNT_D.GROUP_ACCT_WID,W_GL_BALANCE_F.GL_SEGMENT6_WID,W_GL_BALANCE_F.GL_SEGMENT5_WID,W_GL_BALANCE_F.XX_ORG_HIER_WID,W_GL_BALANCE_F.BALANCE_TYPE_WID,W_GL_BALANCE_F.BALANCING_SEGMENT_WID,W_GL_BALANCE_F.NATURAL_ACCOUNT_WID,W_GL_BALANCE_F.XX_GAAP_EXCH_RATE_WID,W_GL_BALANCE_F.BUDGET_WID,W_GL_BALANCE_F.BALANCE_DT_WID,W_GL_BALANCE_F.COMPANY_ORG_WID,W_GL_BALANCE_F.SEG_PROJECT_WID,W_GL_BALANCE_F.MCAL_CAL_WID,W_GL_BALANCE_F.TENANT_ID,W_GL_BALANCE_F.GL_ACCOUNT_WID,W_GL_BALANCE_F.LOC_CURR_CODE,W_GL_BALANCE_F.DATASOURCE_NUM_ID,W_GL_BALANCE_F.DB_CR_IND
) SQ_W_GL_BALANCE_F
ON SQ_W_GL_BALANCE_F.LEDGER_WID=YTD.LEDGER_WID
AND SQ_W_GL_BALANCE_F.BALANCING_SEGMENT_WID=YTD.BALANCING_SEGMENT_WID
AND SQ_W_GL_BALANCE_F.COMPANY_ORG_WID=YTD.COMPANY_ORG_WID
AND SQ_W_GL_BALANCE_F.BUSN_AREA_ORG_WID=YTD.BUSN_AREA_ORG_WID
AND SQ_W_GL_BALANCE_F.BALANCE_TM_WID=YTD.BALANCE_TM_WID
AND SQ_W_GL_BALANCE_F.TREASURY_SYMBOL_WID=YTD.TREASURY_SYMBOL_WID
AND SQ_W_GL_BALANCE_F.DB_CR_IND=YTD.DB_CR_IND
AND SQ_W_GL_BALANCE_F.LOC_CURR_CODE=YTD.LOC_CURR_CODE
AND SQ_W_GL_BALANCE_F.GL_SEGMENT2_WID=YTD.SEGMENT2_WID
AND SQ_W_GL_BALANCE_F.GL_SEGMENT4_WID=YTD.SEGMENT4_WID
AND SQ_W_GL_BALANCE_F.GL_SEGMENT5_WID=YTD.SEGMENT5_WID
AND SQ_W_GL_BALANCE_F.GL_SEGMENT6_WID=YTD.SEGMENT6_WID
AND SQ_W_GL_BALANCE_F.GROUP_ACCT_WID=YTD.GROUP_ACCT_WID
AND SQ_W_GL_BALANCE_F.MCAL_CAL_WID=YTD.MCAL_CAL_WID
AND SQ_W_GL_BALANCE_F.NATURAL_ACCOUNT_WID=YTD.NATURAL_ACCOUNT_WID
AND SQ_W_GL_BALANCE_F.COST_CENTER_WID=YTD.COST_CENTER_WID
AND SQ_W_GL_BALANCE_F.XX_ORG_HIER_WID=YTD.XX_ORG_HIER_WID
AND SQ_W_GL_BALANCE_F.XX_FIXED_EXCH_RATE_WID=YTD.XX_FIXED_EXCH_RATE_WID
AND SQ_W_GL_BALANCE_F.DATASOURCE_NUM_ID=YTD.DATASOURCE_NUM_ID
AND 'U'=YTD.X_HFM_ADJ_FLG
AND substr(SQ_W_GL_BALANCE_F.MCAL_QTR_WID,1,length(SQ_W_GL_BALANCE_F.MCAL_QTR_WID)-1)
=YTD.MCAL_YEAR_WID AND YTD.ACCT_CURR_CODE=SQ_W_GL_BALANCE_F.ACCT_CURR_CODE
where (1=1)
) GL_BALANCE_SQ_FIL
where (1=1)
and ((nvl(GL_BALANCE_SQ_FIL.ACTIVITY_ACCT_AMT,0)<>0
or nvl(GL_BALANCE_SQ_FIL.ACTIVITY_LOC_AMT,0)<>0
or nvl(GL_BALANCE_SQ_FIL.BALANCE_ACCT_AMT,0)<>0
or nvl(GL_BALANCE_SQ_FIL.BALANCE_LOC_AMT,0)<>0
or nvl(GL_BALANCE_SQ_FIL.CARRY_FORWARD_ACCT_AMT,0)<>0
or nvl(GL_BALANCE_SQ_FIL.CARRY_FORWARD_LOC_AMT,0)<>0
or nvl(GL_BALANCE_SQ_FIL.XFQTD_DAILY_ACTIVITY_ACCT_AMT,0)<>0
or nvl(GL_BALANCE_SQ_FIL.XFQTD_DAILY_ACTIVITY_LOC_AMT,0)<>0
or nvl(GL_BALANCE_SQ_FIL.XFYTD_DAILY_BALANCE_GAAP_AMT,0)<>0
or nvl(GL_BALANCE_SQ_FIL.XFPTD_DAILY_ACTIVITY_GAAP_AMT,0)<>0
or nvl(GL_BALANCE_SQ_FIL.XFQTD_DAILY_ACTIVITY_GAAP_AMT,0)<>0
or nvl(GL_BALANCE_SQ_FIL.XFQTD_DAILY_ACTIVITY_GAAP_AMT,0)<>0
or nvl(GL_BALANCE_SQ_FIL.XFYTD_DAILY_BALANCE_GAAP_AMT,0)<>0))
) ODI_GET_FROM
.
at oracle.odi.runtime.agent.execution.interpreter.SessionTaskCodeInterpreter.codeInterpretation(SessionTaskCodeInterpreter.java:205)
at oracle.odi.runtime.agent.execution.interpreter.SessionTaskCodeInterpreter.codeInterpretation(SessionTaskCodeInterpreter.java:80)
at oracle.odi.runtime.agent.execution.SessionTask.createTaskLog(SessionTask.java:359)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:843)
at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225)
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)