Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FDMEE Cloud Log file unable to understand

Venkat ChowdaryAug 18 2015 — edited Aug 20 2015

Hi,

I am working on cloud environment, for integration from Fusion GL to PBCS(Planning).

For data load option I have created source and target configuration in FDMEE,

Source system I have given as Fusion GL.

And created import format, and data load rule, mappings, but when I run the rule I am getting an error as below,

I am not able to understand what the error is, can anyone help me in this regard.

2015-08-18 09:45:58,976 INFO [AIF]: FDMEE Process Start, Process ID: 362

2015-08-18 09:45:58,977 INFO [AIF]: FDMEE Logging Level: 5

2015-08-18 09:45:58,977 INFO [AIF]: User:msiraj@exsab.com.sa

2015-08-18 09:45:58,977 INFO [AIF]: Location:GL2PBCS (Partitionkey:67)

2015-08-18 09:45:58,977 INFO [AIF]: Period Name:Jul-15 (Period Key:7/31/15 12:00 AM)

2015-08-18 09:45:58,977 INFO [AIF]: Category Name:Actual (Category key:4)

2015-08-18 09:45:58,977 INFO [AIF]: Rule Name:GL2PBCS (Rule ID:34)

2015-08-18 09:46:00,592 INFO [AIF]: FDM Version: 11.1.2.4.000

2015-08-18 09:46:00,592 INFO [AIF]: Log File Encoding: UTF-8

2015-08-18 09:46:01,809 INFO [AIF]: -------START IMPORT STEP-------

2015-08-18 09:46:01,875 DEBUG [AIF]: CommData.preImportData - START

2015-08-18 09:46:01,875 DEBUG [AIF]: CommData.getRuleInfo - START

2015-08-18 09:46:01,875 DEBUG [AIF]:

SELECT brl.RULE_ID, br.RULE_NAME, brl.PARTITIONKEY, brl.CATKEY, part.PARTVALGROUP, br.SOURCE_SYSTEM_ID, ss.SOURCE_SYSTEM_TYPE

,CASE

WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'EBS%' THEN 'N'

WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'PS%' THEN 'N'

WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FUSION%' THEN 'N'

WHEN ss.SOURCE_SYSTEM_TYPE = 'FILE' THEN 'N'

WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'N'

ELSE 'Y'

END SOURCE_ADAPTER_FLAG

,app.APPLICATION_ID, app.TARGET_APPLICATION_NAME, app.TARGET_APPLICATION_TYPE, app.DATA_LOAD_METHOD, brl.PLAN_TYPE

,CASE brl.PLAN_TYPE

WHEN 'PLAN1' THEN 1 WHEN 'PLAN2' THEN 2 WHEN 'PLAN3' THEN 3 WHEN 'PLAN4' THEN 4 WHEN 'PLAN5' THEN 5 WHEN 'PLAN6' THEN 6 ELSE 0

END PLAN_NUMBER

,br.INCL_ZERO_BALANCE_FLAG, br.PERIOD_MAPPING_TYPE, br.INCLUDE_ADJ_PERIODS_FLAG, br.BALANCE_TYPE ACTUAL_FLAG

,br.AMOUNT_TYPE, br.BALANCE_SELECTION, br.BALANCE_METHOD_CODE

,COALESCE(br.SIGNAGE_METHOD, 'ABSOLUTE') SIGNAGE_METHOD

,br.CURRENCY_CODE, br.BAL_SEG_VALUE_OPTION_CODE, brl.EXECUTION_MODE

,COALESCE(brl.IMPORT_FROM_SOURCE_FLAG, 'Y') IMPORT_FROM_SOURCE_FLAG

,COALESCE(brl.RECALCULATE_FLAG, 'N') RECALCULATE_FLAG

,COALESCE(brl.EXPORT_TO_TARGET_FLAG, 'N') EXPORT_TO_TARGET_FLAG

,COALESCE(brl.CHECK_FLAG, 'N') CHECK_FLAG

,CASE

WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'NONE'

WHEN (br.LEDGER_GROUP_ID IS NOT NULL) THEN 'MULTI'

WHEN (br.SOURCE_LEDGER_ID IS NOT NULL) THEN 'SINGLE'

ELSE 'NONE'

END LEDGER_GROUP_CODE

,COALESCE(br.BALANCE_AMOUNT_BS, 'YTD') BALANCE_AMOUNT_BS

,COALESCE(br.BALANCE_AMOUNT_IS, 'PERIODIC') BALANCE_AMOUNT_IS

,br.LEDGER_GROUP

,(SELECT brd.DETAIL_CODE FROM AIF_BAL_RULE_DETAILS brd WHERE brd.RULE_ID = br.RULE_ID AND brd.DETAIL_TYPE = 'LEDGER') PS_LEDGER

,CASE lg.LEDGER_TEMPLATE WHEN 'COMMITMENT' THEN 'Y' ELSE 'N' END KK_FLAG

,p.LAST_UPDATED_BY, p.AIF_WEB_SERVICE_URL WEB_SERVICE_URL, p.EPM_ORACLE_INSTANCE

,brl.JOURNAL_FLAG, br.MULTI_PERIOD_FILE_FLAG, br.IMPGROUPKEY, imp.IMPSOURCELEDGERID

,imp.IMPGROUPFILETYPE, imp.IMPTARGETSOURCESYSTEMID, imp.IMPSOURCECOAID, part.PARTTARGETAPPLICATIONID

FROM AIF_PROCESSES p

INNER JOIN AIF_BAL_RULE_LOADS brl

ON brl.LOADID = p.PROCESS_ID

INNER JOIN AIF_BALANCE_RULES br

ON br.RULE_ID = brl.RULE_ID

INNER JOIN AIF_SOURCE_SYSTEMS ss

ON ss.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID

INNER JOIN AIF_TARGET_APPLICATIONS app

ON app.APPLICATION_ID = brl.APPLICATION_ID

INNER JOIN TPOVPARTITION part

ON part.PARTITIONKEY = br.PARTITIONKEY

INNER JOIN TBHVIMPGROUP imp

ON imp.IMPGROUPKEY = part.PARTIMPGROUP

LEFT OUTER JOIN AIF_COA_LEDGERS l

ON l.SOURCE_SYSTEM_ID = p.SOURCE_SYSTEM_ID

AND l.SOURCE_LEDGER_ID = COALESCE(br.SOURCE_LEDGER_ID,imp.IMPSOURCELEDGERID)

LEFT OUTER JOIN AIF_PS_SET_CNTRL_REC_STG scr

ON scr.SOURCE_SYSTEM_ID = l.SOURCE_SYSTEM_ID

AND scr.SETCNTRLVALUE = l.SOURCE_LEDGER_NAME

AND scr.RECNAME = 'LED_GRP_TBL'

LEFT OUTER JOIN AIF_PS_LED_GRP_TBL_STG lg

ON lg.SOURCE_SYSTEM_ID = scr.SOURCE_SYSTEM_ID

AND lg.SETID = scr.SETID

AND lg.LEDGER_GROUP = br.LEDGER_GROUP

WHERE p.PROCESS_ID = 362

2015-08-18 09:46:01,878 DEBUG [AIF]:

SELECT adim.BALANCE_COLUMN_NAME DIMNAME

,adim.DIMENSION_ID

,dim.TARGET_DIMENSION_CLASS_NAME

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1) COA_SEGMENT_NAME1

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID2) COA_SEGMENT_NAME2

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID3) COA_SEGMENT_NAME3

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID4) COA_SEGMENT_NAME4

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID5) COA_SEGMENT_NAME5

,(SELECT DISTINCT CASE mdd.ORPHAN_OPTION_CODE

WHEN 'CHILD' THEN 'N'

WHEN 'ROOT' THEN 'N'

ELSE 'Y'

END DIMENSION_FILTER_FLAG

FROM AIF_MAP_DIM_DETAILS_V mdd

,AIF_MAPPING_RULES mr

WHERE mr.PARTITIONKEY = tpp.PARTITIONKEY

AND mdd.RULE_ID = mr.RULE_ID

AND mdd.DIMENSION_ID = adim.DIMENSION_ID

) DIMENSION_FILTER_FLAG

,tiie.IMPCONCATCHAR

FROM TPOVPARTITION tpp

INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

ON adim.APPLICATION_ID = 13

INNER JOIN AIF_DIMENSIONS dim

ON dim.DIMENSION_ID = adim.DIMENSION_ID

LEFT OUTER JOIN TBHVIMPITEMERPI tiie

ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP

AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME

AND tiie.IMPMAPTYPE = 'ERP'

WHERE tpp.PARTITIONKEY = 67

AND adim.BALANCE_COLUMN_NAME IS NOT NULL

AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

AND (adim.VALID_FOR_PLAN1 = 1 OR dim.TARGET_DIMENSION_CLASS_NAME = 'LOOKUP')

ORDER BY adim.BALANCE_COLUMN_NAME

2015-08-18 09:46:01,881 DEBUG [AIF]: {'APPLICATION_ID': 13L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': u'PLAN1', 'RULE_NAME': u'GL2PBCS', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'/u02/user_projects/instance0', 'CATKEY': 4L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'PBCS', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 27L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'GL2PBCS', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5', u'UD6'], 'FCI_FLAG': 'Y', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'msiraj@exsab.com.sa', 'DIMNAME_MAP': {u'UD6': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Period', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD6', 'DIMENSION_ID': 32L}, u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Version', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 37L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 71L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 70L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Year', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD5', 'DIMENSION_ID': 36L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Scenario', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 33L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 35L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 34L}}, 'TARGET_APPLICATION_TYPE': u'HPL', 'PARTITIONKEY': 67L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 1L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'DELIMITED', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 34L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://em2pbcs006.nldc1.oraclecloud.com:9000/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 13L, 'IMPTARGETSOURCESYSTEMID': 0L}

2015-08-18 09:46:01,881 DEBUG [AIF]: CommData.getRuleInfo - END

2015-08-18 09:46:01,882 DEBUG [AIF]: Comm.doScriptInit - START

2015-08-18 09:46:01,958 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=/u02/user_projects/instance0/FinancialDataQuality, INBOXDIR=/u03/inbox/inbox, LOCNAME=GL2PBCS, SOURCENAME=GL2PBCS, APPID=13, SOURCEID=27, APPROOTDIR=/u03/inbox, IMPORTFORMAT=GL2PBCS, SCRIPTSDIR=/u03/inbox/data/scripts, EPMORACLEHOME=/u02/Oracle/Middleware/EPMSystem11R1, TARGETAPPTYPE=HPL, RULEID=34, CATNAME=Actual, EPMORACLEINSTANCEHOME=/u02/user_projects/instance0, LOADID=362, PERIODNAME=Jul-15, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2015-07-31, EXPORTFLAG=N, TARGETAPPDB=PLAN1, TARGETAPPNAME=PBCS, FILENAME=null, LOCKEY=67, RULENAME=GL2PBCS, OUTBOXDIR=/u03/inbox/outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=4, FILEDIR=Inbox, USERNAME=msiraj@exsab.com.sa, IMPORTFLAG=Y, USERLOCALE=en}

2015-08-18 09:46:01,961 DEBUG [AIF]: The executeEventScript is set to: YES

2015-08-18 09:46:01,961 DEBUG [AIF]: The AppRootFolder is set to: /u03/inbox

2015-08-18 09:46:01,961 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

2015-08-18 09:46:01,961 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE

2015-08-18 09:46:01,961 DEBUG [AIF]: Comm.doScriptInit - END

2015-08-18 09:46:01,961 DEBUG [AIF]: Comm.executeJythonScript - START

2015-08-18 09:46:01,963 INFO [AIF]: Executing the following script: /u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py

2015-08-18 09:46:01,977 DEBUG [AIF]: FusionCloudAdapter.importDataFromFusion - START

2015-08-18 09:46:01,977 DEBUG [AIF]: processId: 362

2015-08-18 09:46:01,977 DEBUG [AIF]: /u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.sh "/u02/Oracle/Middleware/EPMSystem11R1" "/u02/user_projects/instance0" "importDataFromFusion" "362"

2015-08-18 09:46:34,800 DEBUG [AIF]: stdOutData: INFO: Starting script FusionCloudAdapter ...

PBCS Production Deployment setup proxy

Starting FusionAdapter main program...

prod mode: importDataFromFusion, pid: 362

Initializing FusionAdapter initialized ...

fusionGlWebServiceWsdl: https://ebgw-test.fin.em2.oraclecloud.com/publicFinancialCommonErpIntegration/ErpIntegrationService?WSDL

fusionGlWebServiceUser: TM_FINADMIN

fusionProductType: GL

FusionAdapter initialized fine.

From getBalRuleLoadEssRequestId() - essRequestId: 51282

Calling getESSJobStatus for essRequestId: 51282

Status for job 51282 is: SUCCEEDED

Document Details Returned : 1

***********************************************

Document Author : TM_FINADMIN

Document Name : 51282.zip

Document Security Group : Attachments

Document Title : ESS_O_51282_BIP1

************************************************

currentDownloadFileName: /tmp/ESS_O_51282_BIP1.csv

currentDownloadFileName: /tmp/ESS_O_51282_BIP0.xml

currentDownloadFileName: /tmp/51282.log

downloadedDataFileName: /tmp/ESS_O_51282_BIP1.csv

Updated downloaded file name in bal rule loads table: /tmp/ESS_O_51282_BIP1.csv

The FusionAdapter main program has completed.

INFO: The script FusionCloudAdapter has completed.

2015-08-18 09:46:34,800 DEBUG [AIF]: stdErrData:

2015-08-18 09:46:34,812 DEBUG [AIF]: Updated data file name in bal rule loads table: 362.dat

2015-08-18 09:46:34,812 DEBUG [AIF]: FusionCloudAdapter.importDataFromFusion - END

2015-08-18 09:46:34,812 DEBUG [AIF]: Comm.executeJythonScript - END

2015-08-18 09:46:34,812 DEBUG [AIF]: CommData.insertFilePeriods - START

2015-08-18 09:46:34,813 DEBUG [AIF]: doAppPeriodMappingsExist - PBCS: N

2015-08-18 09:46:34,814 DEBUG [AIF]:

select PERIODKEY,PERIODDESC,YEARTARGET,PERIODTARGET,FILE_NAME_STATIC,FILE_NAME_SUFFIX_TYPE,FILE_NAME_DATE_FORMAT,GL_EFFECTIVE_PERIOD_NUM

from (

SELECT pp.PERIODKEY

,pp.PERIODDESC

,pp.YEARTARGET YEARTARGET

,pp.PERIODTARGET PERIODTARGET

,brl.FILE_NAME_STATIC

,brl.FILE_NAME_SUFFIX_TYPE

,brl.FILE_NAME_DATE_FORMAT

,coalesce(brp.parameter_id,0) GL_EFFECTIVE_PERIOD_NUM

FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

INNER JOIN TPOVCATEGORY pc

ON pc.CATKEY = brl.CATKEY

INNER JOIN TPOVPERIOD_FLAT_V pp

ON pp.PERIODFREQ = pc.CATFREQ

INNER JOIN AIF_BAL_RULE_LOAD_PARAMS brp

ON brp.loadid = brl.loadid

AND to_date(brp.parameter_value,'yyyy/MM/dd') = pp.periodkey

WHERE brl.LOADID = 362

AND br.rule_id = brl.rule_id

AND br.MULTI_PERIOD_FILE_FLAG in ('T','H')

AND brp.parameter_name like 'AMOUNT%'

UNION

SELECT pp.PERIODKEY

,pp.PERIODDESC

,pp.YEARTARGET YEARTARGET

,pp.PERIODTARGET PERIODTARGET

,brl.FILE_NAME_STATIC

,brl.FILE_NAME_SUFFIX_TYPE

,brl.FILE_NAME_DATE_FORMAT

,0 GL_EFFECTIVE_PERIOD_NUM

FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

INNER JOIN TPOVCATEGORY pc

ON pc.CATKEY = brl.CATKEY

INNER JOIN TPOVPERIOD_FLAT_V pp

ON pp.PERIODFREQ = pc.CATFREQ

AND pp.PERIODKEY >= brl.START_PERIODKEY

AND pp.PERIODKEY <= brl.END_PERIODKEY

WHERE brl.LOADID = 362

AND br.rule_id = brl.rule_id

AND br.MULTI_PERIOD_FILE_FLAG in( 'Y', 'X','E')

) qrslt

UNION

SELECT pp.PERIODKEY

,pp.PERIODDESC

,pp.YEARTARGET YEARTARGET

,pp.PERIODTARGET PERIODTARGET

,brl.FILE_NAME_STATIC

,brl.FILE_NAME_SUFFIX_TYPE

,brl.FILE_NAME_DATE_FORMAT

, 0 GL_EFFECTIVE_PERIOD_NUM

FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

INNER JOIN TPOVCATEGORY pc

ON pc.CATKEY = brl.CATKEY

INNER JOIN TPOVPERIOD_FLAT_V pp

ON pp.PERIODFREQ = pc.CATFREQ

AND pp.PERIODKEY >= brl.START_PERIODKEY

AND pp.PERIODKEY <= brl.END_PERIODKEY

WHERE brl.LOADID = 362

AND (br.MULTI_PERIOD_FILE_FLAG is null or br.MULTI_PERIOD_FILE_FLAG = 'N' )

AND br.rule_id = brl.rule_id

ORDER BY PERIODKEY

2015-08-18 09:46:34,815 INFO [AIF]: File Name: 362.dat

2015-08-18 09:46:34,816 DEBUG [AIF]:

INSERT INTO AIF_PROCESS_PERIODS (

PROCESS_ID

,PERIODKEY

,ADJUSTMENT_PERIOD_FLAG

,GL_PERIOD_YEAR

,GL_PERIOD_CODE

,GL_PERIOD_NAME

,GL_PERIOD_NUM

,GL_EFFECTIVE_PERIOD_NUM

,YEARTARGET

,PERIODTARGET

,IMP_ENTITY_TYPE

,IMP_ENTITY_NAME

,TRANS_ENTITY_TYPE

,TRANS_ENTITY_NAME

,PRIOR_PERIOD_FLAG

) VALUES (362,'2015-07-31','N',0,'0' ,'0',0,1,'FY15','Jul', 'PROCESS_BAL_IMP_FILE','362.dat','PROCESS_BAL_TRANS','Jul-15','N' )

2015-08-18 09:46:34,818 DEBUG [AIF]: CommData.insertFilePeriods - END

2015-08-18 09:46:34,818 DEBUG [AIF]: CommData.getPovList - START

2015-08-18 09:46:34,819 DEBUG [AIF]:

SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY

,COALESCE(pp.PERIODDESC, TO_CHAR(pprd.PERIODKEY,'YYYY-MM-DD HH24:MI:SS')) PERIODDESC

,brl.RULE_ID, br.RULE_NAME, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG

FROM AIF_BAL_RULE_LOADS brl

INNER JOIN AIF_BALANCE_RULES br

ON br.RULE_ID = brl.RULE_ID

INNER JOIN TPOVPARTITION part

ON part.PARTITIONKEY = brl.PARTITIONKEY

INNER JOIN TPOVCATEGORY cat

ON cat.CATKEY = brl.CATKEY

INNER JOIN AIF_PROCESS_PERIODS pprd

ON pprd.PROCESS_ID = brl.LOADID

LEFT OUTER JOIN TPOVPERIOD pp

ON pp.PERIODKEY = pprd.PERIODKEY

LEFT OUTER JOIN TLOGPROCESS tlp

ON tlp.PARTITIONKEY = brl.PARTITIONKEY

AND tlp.CATKEY = brl.CATKEY

AND tlp.PERIODKEY = pprd.PERIODKEY

AND tlp.RULE_ID = brl.RULE_ID

WHERE brl.LOADID = 362

ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID

2015-08-18 09:46:34,820 DEBUG [AIF]: CommData.getPovList - END

2015-08-18 09:46:34,820 DEBUG [AIF]: CommData.insertImportProcessDetails - START

2015-08-18 09:46:34,820 DEBUG [AIF]:

INSERT INTO AIF_PROCESS_DETAILS (

PROCESS_ID

,ENTITY_TYPE

,ENTITY_ID

,ENTITY_NAME

,ENTITY_NAME_ORDER

,TARGET_TABLE_NAME

,EXECUTION_START_TIME

,EXECUTION_END_TIME

,RECORDS_PROCESSED

,STATUS

,LAST_UPDATED_BY

,LAST_UPDATE_DATE

)

SELECT PROCESS_ID

,ENTITY_TYPE

,ENTITY_ID

,ENTITY_NAME

,ENTITY_NAME_ORDER

,'TDATASEG' TARGET_TABLE_NAME

,CURRENT_TIMESTAMP EXECUTION_START_TIME

,NULL EXECUTION_END_TIME

,0 RECORDS_PROCESSED

,'PENDING' STATUS

,'msiraj@exsab.com.sa' LAST_UPDATED_BY

,CURRENT_TIMESTAMP LAST_UPDATE_DATE

FROM (

SELECT DISTINCT PROCESS_ID

,IMP_ENTITY_TYPE ENTITY_TYPE

,IMP_ENTITY_ID ENTITY_ID

,IMP_ENTITY_NAME ENTITY_NAME

,(COALESCE(SOURCE_LEDGER_ID,0) * 100000000 + GL_EFFECTIVE_PERIOD_NUM) ENTITY_NAME_ORDER

FROM AIF_PROCESS_PERIODS

WHERE PROCESS_ID = 362

) q

ORDER BY ENTITY_NAME_ORDER

2015-08-18 09:46:34,822 DEBUG [AIF]: CommData.insertImportProcessDetails - END

2015-08-18 09:46:34,822 DEBUG [AIF]: Comm.executeScript - START

2015-08-18 09:46:34,824 DEBUG [AIF]: The following script does not exist: /u03/inbox/data/scripts/event/BefImport.py

2015-08-18 09:46:34,824 DEBUG [AIF]: Comm.executeVBScript - START

2015-08-18 09:46:34,824 DEBUG [AIF]: The WindowsTempFolder is set to: /u02/user_projects/instance0/tmp

2015-08-18 09:46:34,824 DEBUG [AIF]: The following script does not exist: \u03\inbox\data\scripts\event\BefImport.vbs

2015-08-18 09:46:34,825 DEBUG [AIF]: Comm.executeVBScript - END

2015-08-18 09:46:34,825 DEBUG [AIF]: Comm.executeScript - END

2015-08-18 09:46:34,825 DEBUG [AIF]: CommData.preImportData - END

2015-08-18 09:46:37,924 DEBUG [AIF]: FileData.importData - START

2015-08-18 09:46:37,924 DEBUG [AIF]: Importing data for load id: 362

2015-08-18 09:46:37,925 DEBUG [AIF]: SELECT a.partitionkey,

a.catkey,

a.start_periodkey,

b.perioddesc,

coalesce(a.journal_flag,'N') JOURNAL_FLAG,

c.last_updated_by,

coalesce(a.FILE_NAME_STATIC,'') FILE_NAME_STATIC,

a.FILE_PATH,

a.RULE_ID,

a.application_id,

coalesce(br.MULTI_PERIOD_FILE_FLAG, 'N') MULTI_PERIOD_FILE_FLAG

FROM aif_bal_rule_loads a,

aif_balance_rules br,

tpovperiod b,

aif_processes c

WHERE a.loadid = 362

AND a.start_periodkey=b.periodkey

AND a.loadid =c.process_id

AND br.rule_id = a.rule_id

2015-08-18 09:46:37,927 DEBUG [AIF]: FileData.py: Importing Text data for load id: 362

2015-08-18 09:46:37,993 INFO [AIF]: EPMFDM-140274:Message - Log File Name :/u03/inbox/outbox/logs/PBCS_362.log

2015-08-18 09:46:37,993 DEBUG [AIF]: EPMFDM-140274:Message - SELECT COALESCE(p.partitionkey,0) PARTITIONKEY,

COALESCE(brl.catkey,0) CATKEY,

COALESCE(p.rule_id,0) RULE_ID,

part.PARTCURRENCYKEY PARTCURRENCYKEY,

dir.FILE_PATH,

p.CLUSTER_NAME,

p.APPLICATION_ID

FROM aif_processes p,

aif_bal_rule_loads brl,

tpovpartition part,

(SELECT COALESCE(

(SELECT PROFILE_OPTION_VALUE

|| '/'

FROM AIF_PROFILE_OPTION_VALUES

WHERE PROFILE_OPTION_NAME = 'PROFILE_APP_ROOT_DIRECTORY'

AND LEVEL_ID = 1005

AND LEVEL_VALUE = brl.APPLICATION_ID

) ,COALESCE(

(SELECT PROFILE_OPTION_VALUE

|| '/'

FROM AIF_PROFILE_OPTION_VALUES

WHERE PROFILE_OPTION_NAME = 'PROFILE_APP_ROOT_DIRECTORY'

AND LEVEL_ID = 1000

) ,'' ) ,'' )

|| COALESCE(brl.FILE_PATH, '') FILE_PATH,

brl.LOADID

FROM AIF_BAL_RULE_LOADS brl

) dir

WHERE p.process_id = ?

AND p.process_id = dir.loadid

AND brl.loadid = p.process_id

AND part.partitionkey = p.partitionkey

2015-08-18 09:46:37,994 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH::362;67:4:34:[NONE]:/u03/inbox/Inbox

2015-08-18 09:46:37,998 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start

2015-08-18 09:46:37,998 DEBUG [AIF]: EPMFDM-140274:Message - SELECT pp.PERIODKEY,

pp.PERIODTARGET,

pp.GL_PERIOD_NAME,

en.FILE_ENTITY_NAME,

en.ENTITY_NAME_ORDER,

br.MULTI_PERIOD_FILE_FLAG,

pp.TRANS_ENTITY_NAME,

pp.GL_PERIOD_YEAR_CHAR

FROM AIF_PROCESS_PERIODS pp,

AIF_BALANCE_RULES br,

AIF_PROCESSES p,

(SELECT DISTINCT entity_name FILE_ENTITY_NAME,

pd.process_id,

pd.entity_name_order

FROM aif_process_details pd

WHERE pd.entity_type = 'PROCESS_BAL_IMP_FILE'

AND pd.target_table_name = 'TDATASEG'

AND pd.status = 'PENDING'

) en

WHERE pp.PROCESS_ID = ?

AND p.process_id = pp.process_id

AND en.process_id = pp.process_id

AND pp.IMP_ENTITY_NAME = en.file_entity_name

AND br.rule_id = p.rule_id

AND en.entity_name_order = pp.GL_EFFECTIVE_PERIOD_NUM

AND ((br.MULTI_PERIOD_FILE_FLAG in ( 'Y','T','X','E','H') )

(br.MULTI_PERIOD_FILE_FLAG is null OR br.MULTI_PERIOD_FILE_FLAG = 'N')

)

ORDER BY en.entity_name_order

2015-08-18 09:46:37,999 DEBUG [AIF]: EPMFDM-140274:Message - update aif_process_details set status = ? , records_processed = ?, EXECUTION_END_TIME = CURRENT_TIMESTAMP where process_id = ? and entity_type = ? and entity_name = ?

2015-08-18 09:46:38,002 DEBUG [AIF]: EPMFDM-140274:Message - update aif_process_details set status = ? , records_processed = ?, EXECUTION_END_TIME = CURRENT_TIMESTAMP where process_id = ? and entity_type = ? and entity_name = ?

2015-08-18 09:46:38,003 ERROR [AIF]: EPMFDM-140274:Message - /u03/inbox/Inbox/362.dat (No such file or directory)

2015-08-18 09:46:38,006 FATAL [AIF]: Error in FileData.importData

Traceback (most recent call last):

File "<string>", line 84, in importData

RuntimeException: java.lang.RuntimeException: EPMFDM-140274:Message - {0}

2015-08-18 09:46:38,101 DEBUG [AIF]: CommData.postImportData - START

2015-08-18 09:46:38,102 DEBUG [AIF]: CommData.getRuleInfo - START

2015-08-18 09:46:38,102 DEBUG [AIF]:

SELECT brl.RULE_ID, br.RULE_NAME, brl.PARTITIONKEY, brl.CATKEY, part.PARTVALGROUP, br.SOURCE_SYSTEM_ID, ss.SOURCE_SYSTEM_TYPE

,CASE

WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'EBS%' THEN 'N'

WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'PS%' THEN 'N'

WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FUSION%' THEN 'N'

WHEN ss.SOURCE_SYSTEM_TYPE = 'FILE' THEN 'N'

WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'N'

ELSE 'Y'

END SOURCE_ADAPTER_FLAG

,app.APPLICATION_ID, app.TARGET_APPLICATION_NAME, app.TARGET_APPLICATION_TYPE, app.DATA_LOAD_METHOD, brl.PLAN_TYPE

,CASE brl.PLAN_TYPE

WHEN 'PLAN1' THEN 1 WHEN 'PLAN2' THEN 2 WHEN 'PLAN3' THEN 3 WHEN 'PLAN4' THEN 4 WHEN 'PLAN5' THEN 5 WHEN 'PLAN6' THEN 6 ELSE 0

END PLAN_NUMBER

,br.INCL_ZERO_BALANCE_FLAG, br.PERIOD_MAPPING_TYPE, br.INCLUDE_ADJ_PERIODS_FLAG, br.BALANCE_TYPE ACTUAL_FLAG

,br.AMOUNT_TYPE, br.BALANCE_SELECTION, br.BALANCE_METHOD_CODE

,COALESCE(br.SIGNAGE_METHOD, 'ABSOLUTE') SIGNAGE_METHOD

,br.CURRENCY_CODE, br.BAL_SEG_VALUE_OPTION_CODE, brl.EXECUTION_MODE

,COALESCE(brl.IMPORT_FROM_SOURCE_FLAG, 'Y') IMPORT_FROM_SOURCE_FLAG

,COALESCE(brl.RECALCULATE_FLAG, 'N') RECALCULATE_FLAG

,COALESCE(brl.EXPORT_TO_TARGET_FLAG, 'N') EXPORT_TO_TARGET_FLAG

,COALESCE(brl.CHECK_FLAG, 'N') CHECK_FLAG

,CASE

WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'NONE'

WHEN (br.LEDGER_GROUP_ID IS NOT NULL) THEN 'MULTI'

WHEN (br.SOURCE_LEDGER_ID IS NOT NULL) THEN 'SINGLE'

ELSE 'NONE'

END LEDGER_GROUP_CODE

,COALESCE(br.BALANCE_AMOUNT_BS, 'YTD') BALANCE_AMOUNT_BS

,COALESCE(br.BALANCE_AMOUNT_IS, 'PERIODIC') BALANCE_AMOUNT_IS

,br.LEDGER_GROUP

,(SELECT brd.DETAIL_CODE FROM AIF_BAL_RULE_DETAILS brd WHERE brd.RULE_ID = br.RULE_ID AND brd.DETAIL_TYPE = 'LEDGER') PS_LEDGER

,CASE lg.LEDGER_TEMPLATE WHEN 'COMMITMENT' THEN 'Y' ELSE 'N' END KK_FLAG

,p.LAST_UPDATED_BY, p.AIF_WEB_SERVICE_URL WEB_SERVICE_URL, p.EPM_ORACLE_INSTANCE

,brl.JOURNAL_FLAG, br.MULTI_PERIOD_FILE_FLAG, br.IMPGROUPKEY, imp.IMPSOURCELEDGERID

,imp.IMPGROUPFILETYPE, imp.IMPTARGETSOURCESYSTEMID, imp.IMPSOURCECOAID, part.PARTTARGETAPPLICATIONID

FROM AIF_PROCESSES p

INNER JOIN AIF_BAL_RULE_LOADS brl

ON brl.LOADID = p.PROCESS_ID

INNER JOIN AIF_BALANCE_RULES br

ON br.RULE_ID = brl.RULE_ID

INNER JOIN AIF_SOURCE_SYSTEMS ss

ON ss.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID

INNER JOIN AIF_TARGET_APPLICATIONS app

ON app.APPLICATION_ID = brl.APPLICATION_ID

INNER JOIN TPOVPARTITION part

ON part.PARTITIONKEY = br.PARTITIONKEY

INNER JOIN TBHVIMPGROUP imp

ON imp.IMPGROUPKEY = part.PARTIMPGROUP

LEFT OUTER JOIN AIF_COA_LEDGERS l

ON l.SOURCE_SYSTEM_ID = p.SOURCE_SYSTEM_ID

AND l.SOURCE_LEDGER_ID = COALESCE(br.SOURCE_LEDGER_ID,imp.IMPSOURCELEDGERID)

LEFT OUTER JOIN AIF_PS_SET_CNTRL_REC_STG scr

ON scr.SOURCE_SYSTEM_ID = l.SOURCE_SYSTEM_ID

AND scr.SETCNTRLVALUE = l.SOURCE_LEDGER_NAME

AND scr.RECNAME = 'LED_GRP_TBL'

LEFT OUTER JOIN AIF_PS_LED_GRP_TBL_STG lg

ON lg.SOURCE_SYSTEM_ID = scr.SOURCE_SYSTEM_ID

AND lg.SETID = scr.SETID

AND lg.LEDGER_GROUP = br.LEDGER_GROUP

WHERE p.PROCESS_ID = 362

2015-08-18 09:46:38,106 DEBUG [AIF]:

SELECT adim.BALANCE_COLUMN_NAME DIMNAME

,adim.DIMENSION_ID

,dim.TARGET_DIMENSION_CLASS_NAME

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1) COA_SEGMENT_NAME1

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID2) COA_SEGMENT_NAME2

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID3) COA_SEGMENT_NAME3

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID4) COA_SEGMENT_NAME4

,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID5) COA_SEGMENT_NAME5

,(SELECT DISTINCT CASE mdd.ORPHAN_OPTION_CODE

WHEN 'CHILD' THEN 'N'

WHEN 'ROOT' THEN 'N'

ELSE 'Y'

END DIMENSION_FILTER_FLAG

FROM AIF_MAP_DIM_DETAILS_V mdd

,AIF_MAPPING_RULES mr

WHERE mr.PARTITIONKEY = tpp.PARTITIONKEY

AND mdd.RULE_ID = mr.RULE_ID

AND mdd.DIMENSION_ID = adim.DIMENSION_ID

) DIMENSION_FILTER_FLAG

,tiie.IMPCONCATCHAR

FROM TPOVPARTITION tpp

INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

ON adim.APPLICATION_ID = 13

INNER JOIN AIF_DIMENSIONS dim

ON dim.DIMENSION_ID = adim.DIMENSION_ID

LEFT OUTER JOIN TBHVIMPITEMERPI tiie

ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP

AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME

AND tiie.IMPMAPTYPE = 'ERP'

WHERE tpp.PARTITIONKEY = 67

AND adim.BALANCE_COLUMN_NAME IS NOT NULL

AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

AND (adim.VALID_FOR_PLAN1 = 1 OR dim.TARGET_DIMENSION_CLASS_NAME = 'LOOKUP')

ORDER BY adim.BALANCE_COLUMN_NAME

2015-08-18 09:46:38,109 DEBUG [AIF]: {'APPLICATION_ID': 13L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': u'PLAN1', 'RULE_NAME': u'GL2PBCS', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'/u02/user_projects/instance0', 'CATKEY': 4L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'PBCS', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 27L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'GL2PBCS', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5', u'UD6'], 'FCI_FLAG': 'Y', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'msiraj@exsab.com.sa', 'DIMNAME_MAP': {u'UD6': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Period', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD6', 'DIMENSION_ID': 32L}, u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Version', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 37L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 71L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 70L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Year', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD5', 'DIMENSION_ID': 36L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Scenario', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 33L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 35L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 34L}}, 'TARGET_APPLICATION_TYPE': u'HPL', 'PARTITIONKEY': 67L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 1L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'DELIMITED', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 34L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://em2pbcs006.nldc1.oraclecloud.com:9000/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 13L, 'IMPTARGETSOURCESYSTEMID': 0L}

2015-08-18 09:46:38,109 DEBUG [AIF]: CommData.getRuleInfo - END

2015-08-18 09:46:38,109 DEBUG [AIF]: CommData.updateTDATASEG_T - START

2015-08-18 09:46:38,109 DEBUG [AIF]: CommData.getLedgerListAndMap - START

2015-08-18 09:46:38,109 DEBUG [AIF]: CommData.getLedgerSQL - START

2015-08-18 09:46:38,109 DEBUG [AIF]: CommData.getLedgerSQL - END

2015-08-18 09:46:38,109 DEBUG [AIF]:

SELECT COALESCE(br.SOURCE_LEDGER_ID,0) SOURCE_LEDGER_ID

,NULL SOURCE_LEDGER_NAME

,NULL SOURCE_COA_ID

,br.CALENDAR_ID

,NULL SETID

,NULL PERIOD_TYPE

,NULL LEDGER_TABLE_NAME

FROM AIF_BALANCE_RULES br

WHERE br.RULE_ID = 34

2015-08-18 09:46:38,110 DEBUG [AIF]: CommData.getLedgerListAndMap - END

2015-08-18 09:46:38,110 DEBUG [AIF]: CommData.getPovList - START

2015-08-18 09:46:38,112 DEBUG [AIF]: doAppPeriodMappingsExist - PBCS: N

2015-08-18 09:46:38,112 DEBUG [AIF]:

SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY

,COALESCE(pp.PERIODDESC, TO_CHAR(pprd.PERIODKEY,'YYYY-MM-DD HH24:MI:SS')) PERIODDESC

,brl.RULE_ID, br.RULE_NAME, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG

FROM AIF_BAL_RULE_LOADS brl

INNER JOIN AIF_BALANCE_RULES br

ON br.RULE_ID = brl.RULE_ID

INNER JOIN TPOVPA

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 17 2015

Added on Aug 18 2015

#business-intelligence-applications, #financial-data-management, #performance-management-applications

4 comments

1,092 views