1 Reply Latest reply: Oct 16, 2012 2:51 PM by JeffJon RSS

    ERPI Error during Export data to GL for period 2012

    cwlau
      Hi, experts

      When I write back data from Planning to EBS, I encounter the following error during Export data to GL for period 2012. I have confirmed that Planning data has been upload to ERPI.
      Do you have any hints on this error for me? Thanks a lot.

      Log:

      ,COALESCE(ppa.YEARTARGET, pp.YEARTARGET) YEARTARGET
      ,CASE
      WHEN (INSTR(UPPER(wld.TEMP_COLUMN_NAME),'AMOUNT',1) = 1) THEN
      CAST(SUBSTR(wld.TEMP_COLUMN_NAME,7,LENGTH(wld.TEMP_COLUMN_NAME)) AS NUMERIC(15,0))
      ELSE 0
      END ENTITY_NAME_ORDER
      FROM (
      AIF_WRITEBACK_LOAD_DTLS wld
      LEFT OUTER JOIN TPOVPERIODADAPTOR_FLAT_V ppa
      ON ppa.INTSYSTEMKEY = 'JC2PLN'
      AND ppa.PERIODTARGET = wld.DIMENSION_NAME
      AND ppa.YEARTARGET = 'FY12'
      ) LEFT OUTER JOIN TPOVPERIOD_FLAT_V pp
      ON pp.PERIODTARGET = wld.DIMENSION_NAME
      AND pp.YEARTARGET = 'FY12'
      WHERE wld.LOADID = 176
      AND wld.COLUMN_TYPE = 'DATA'
      ) query
      GROUP BY PERIODTARGET
      ,YEARTARGET
      ,ENTITY_NAME_ORDER

      ) q
      ,TPOVPERIOD p
      ,AIF_GL_PERIODS_STG prd
      WHERE p.PERIODKEY = q.PERIODKEY
      AND NOT EXISTS (
      SELECT 1
      FROM AIF_PROCESS_DETAILS pd
      WHERE pd.PROCESS_ID = 176
      AND pd.ENTITY_TYPE = 'PROCESS_WB_EXP'
      AND pd.ENTITY_ID = prd.YEAR
      )
      AND prd.SOURCE_SYSTEM_ID = 3
      AND prd.SETID = '0'
      AND prd.CALENDAR_ID = '10000'
      AND prd.PERIOD_TYPE = 'Month'
      AND prd.START_DATE > p.PRIORPERIODKEY
      AND prd.START_DATE <= p.PERIODKEY
      AND prd.ADJUSTMENT_PERIOD_FLAG = 'N'
      ORDER BY prd.YEAR

      2012-10-12 11:05:10,078 INFO [AIF]: COMM Writeback Period Processing - Insert Periods into Process Details - END
      2012-10-12 11:05:10,516 INFO [AIF]: COMM End Process Detail - Update Process Detail - START
      2012-10-12 11:05:10,594 DEBUG [AIF]:
      UPDATE AIF_PROCESS_DETAILS
      SET STATUS = 'FAILED'
      ,RECORDS_PROCESSED = CASE
      WHEN RECORDS_PROCESSED IS NULL THEN 0
      ELSE RECORDS_PROCESSED
      END + 0
      ,EXECUTION_END_TIME = CURRENT_TIMESTAMP
      ,LAST_UPDATED_BY = CASE
      WHEN ('native://DN=cn=911,ou=People,dc=css,dc=hyperion,dc=com?USER' IS NULL) THEN LAST_UPDATED_BY
      ELSE 'native://DN=cn=911,ou=People,dc=css,dc=hyperion,dc=com?USER'
      END
      ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP
      WHERE PROCESS_ID = 176
      AND ENTITY_TYPE = 'PROCESS_WB_EXP'
      AND ENTITY_NAME = '2012'

      2012-10-12 11:05:10,594 INFO [AIF]: COMM End Process Detail - Update Process Detail - END
      2012-10-12 11:05:10,719 INFO [AIF]: ERPI Process End, Process ID: 176