6 Replies Latest reply on Jun 21, 2012 9:34 PM by 944384

    FDM bulk insert error

    D.Perego
      Hello,
      i'm trying to bulk insert data into planning and i get an error. As i can understand it seems related to some bad settings regarding decimal separator. I'm from italy where default decimal separator is ",". As far as i can check everything is set on english including Oracle Client (... sqlldr).
      As you can see in datafile.log i get oracle ORA-01722 error.

      Any ideas?

      Thank you in advance,
      Daniele

      S.O: windows2008
      FDM Version: 11.1.2.1
      REPOSITORY: Oracle 11.2.0.1.0 - 64bit

      Here are log files:

      admin.log:
      ** Begin FDM Runtime Error Log Entry [2011-09-07 16:50:18] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. 4003
      Description...................................... Oracle (SQL-Loader) data load failed, please see processing log for details!
      Procedure........................................ clsImpProcessMgr.fLoadAndProcessFile
      Component........................................ upsWObjectsDM
      Version.......................................... 1112
      Thread........................................... 4040

      IDENTIFICATION:
      User............................................. admin
      Computer Name.................................... IPEREPMA00
      App Name......................................... FDMAuchan
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... ORAOLEDB.ORACLE
      Data Server......................................
      Database Name.................................... HYPTEST
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... LOADACTSAP
      Location ID...................................... 750
      Location Seg..................................... 4
      Category......................................... SAP
      Category ID...................................... 13
      Period........................................... Jan - 2011
      Period ID........................................ 1/31/2011
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False

      datafile.log
      +2011-09-07 16:50:16+

      User ID...........     admin
      Location..........     LOADACTSAP
      Source File.......     D:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\SharedComponents\APPS\FDMAuchan\Inbox\LOADACTSAP\SAP_1101_Prova.txt

      Processing Codes:
      ------------------------------------------------------------------------------------------------
      BLANK............. Line is blank or empty.
      ESD............... Excluded String Detected, SKIP Field value was found.
      NN................ Non-Numeric, Amount field contains non numeric characters.
      RFM............... Required Field Missing.
      TC................ Type Conversion, Amount field could be converted to a number.
      ZP................ Zero Suppress, Amount field contains a 0 value and zero suppress is ON.

      Create Output File Start: [2011-09-07 16:50:16]

      +[Blank] -      +

      Excluded Record Count..............0
      Blank Record Count.................1
      ------------------------------------------------------------------------------------------------
      Total Records Bypassed.............1
      Valid Records......................477
      Total Records Processed............478

      Begin Oracle (SQL-Loader) Process (477): [2011-09-07 16:50:16]

      Oracle (SQL-Loader) Log File Contents:


      SQL*Loader: Release 11.2.0.1.0 - Production on Mer Set 7 16:50:16 2011

      Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

      Control File:   C:\Users\INSTAL~1\AppData\Local\Temp\tWadmin154840402517.ctl
      Character Set UTF16 specified for all input.
      Using character length semantics.
      First primary datafile C:\Users\INSTAL~1\AppData\Local\Temp\tWadmin154840402517.tmp has a
      little endian byte order mark in it.

      Data File:      C:\Users\INSTAL~1\AppData\Local\Temp\tWadmin154840402517.tmp
      Bad File:     C:\Users\INSTAL~1\AppData\Local\Temp\tWadmin154840402517.bad
      Discard File:  none specified

      +(Allow all discards)+

      Number to load: ALL
      Number to skip: 0
      Errors allowed: 50
      Continuation:    none specified
      Path used:      Direct

      Load is UNRECOVERABLE; invalidation redo is produced.

      Table TWADMIN154840402517, loaded from every logical record.
      Insert option in effect for this table: APPEND
      TRAILING NULLCOLS option in effect

      Column Name                  Position   Len  Term Encl Datatype
      ------------------------------ ---------- ----- ---- ---- ---------------------
      DATAKEY                                                   SEQUENCE (1, 1)
      PARTITIONKEY                        FIRST     *           CHARACTER
      Terminator string : '~|'
      CATKEY                               NEXT     *           CHARACTER
      Terminator string : '~|'
      PERIODKEY                            NEXT     *           DATE YYYYMMDD
      Terminator string : '~|'
      DATAVIEW                             NEXT     *           CHARACTER
      Terminator string : '~|'
      ACCOUNT                              NEXT     *           CHARACTER
      Terminator string : '~|'
      ENTITY                               NEXT     *           CHARACTER
      Terminator string : '~|'
      ICP                                  NEXT     *           CHARACTER
      Terminator string : '~|'
      UD1                                  NEXT     *           CHARACTER
      Terminator string : '~|'
      UD2                                  NEXT     *           CHARACTER
      Terminator string : '~|'
      UD3                                  NEXT     *           CHARACTER
      Terminator string : '~|'
      UD4                                  NEXT     *           CHARACTER
      Terminator string : '~|'
      UD5                                  NEXT     *           CHARACTER
      Terminator string : '~|'
      UD6                                  NEXT     *           CHARACTER
      Terminator string : '~|'
      UD7                                  NEXT     *           CHARACTER
      Terminator string : '~|'
      UD8                                  NEXT     *           CHARACTER
      Terminator string : '~|'
      UD9                                  NEXT     *           CHARACTER
      Terminator string : '~|'
      UD10                                 NEXT     *           CHARACTER
      Terminator string : '~|'
      UD11                                 NEXT     *           CHARACTER
      Terminator string : '~|'
      UD12                                 NEXT     *           CHARACTER
      Terminator string : '~|'
      UD13                                 NEXT     *           CHARACTER
      Terminator string : '~|'
      UD14                                 NEXT     *           CHARACTER
      Terminator string : '~|'
      UD15                                 NEXT     *           CHARACTER
      Terminator string : '~|'
      UD16                                 NEXT     *           CHARACTER
      Terminator string : '~|'
      UD17                                 NEXT     *           CHARACTER
      Terminator string : '~|'
      UD18                                 NEXT     *           CHARACTER
      Terminator string : '~|'
      UD19                                 NEXT     *           CHARACTER
      Terminator string : '~|'
      UD20                                 NEXT     *           CHARACTER
      Terminator string : '~|'
      DESC1                                NEXT     *           CHARACTER
      Terminator string : '~|'
      DESC2                                NEXT     *           CHARACTER
      Terminator string : '~|'
      ATTR1                                NEXT     *           CHARACTER
      Terminator string : '~|'
      ATTR2                                NEXT     *           CHARACTER
      Terminator string : '~|'
      ATTR3                                NEXT     *           CHARACTER
      Terminator string : '~|'
      ATTR4                                NEXT     *           CHARACTER
      Terminator string : '~|'
      ATTR5                                NEXT     *           CHARACTER
      Terminator string : '~|'
      ATTR6                                NEXT     *           CHARACTER
      Terminator string : '~|'
      ATTR7                                NEXT     *           CHARACTER
      Terminator string : '~|'
      ATTR8                                NEXT     *           CHARACTER
      Terminator string : '~|'
      ATTR9                                NEXT     *           CHARACTER
      Terminator string : '~|'
      ATTR10                               NEXT     *           CHARACTER
      Terminator string : '~|'
      ATTR11                               NEXT     *           CHARACTER
      Terminator string : '~|'
      ATTR12                               NEXT     *           CHARACTER
      Terminator string : '~|'
      ATTR13                               NEXT     *           CHARACTER
      Terminator string : '~|'
      ATTR14                               NEXT     *           CHARACTER
      Terminator string : '~|'
      MEMOKEY                              NEXT     *           CHARACTER
      Terminator string : '~|'
      AMOUNT                               NEXT     *           CHARACTER
      Terminator string : '~|'
      CALCACCTTYPE                                              CONSTANT
      Value is '9'
      CHANGESIGN                                                CONSTANT
      Value is '0'
      AMOUNTX                                                   CONSTANT
      Value is '0'
      ACCOUNTR                                                  CONSTANT
      Value is '0'
      ACCOUNTF                                                  CONSTANT
      Value is '0'
      ENTITYR                                                   CONSTANT
      Value is '0'
      ENTITYF                                                   CONSTANT
      Value is '0'
      ICPR                                                      CONSTANT
      Value is '0'
      ICPF                                                      CONSTANT
      Value is '0'
      UD1R                                                      CONSTANT
      Value is '0'
      UD1F                                                      CONSTANT
      Value is '0'
      UD2R                                                      CONSTANT
      Value is '0'
      UD2F                                                      CONSTANT
      Value is '0'
      UD3R                                                      CONSTANT
      Value is '0'
      UD3F                                                      CONSTANT
      Value is '0'
      UD4R                                                      CONSTANT
      Value is '0'
      UD4F                                                      CONSTANT
      Value is '0'
      UD5R                                                      CONSTANT
      Value is '0'
      UD5F                                                      CONSTANT
      Value is '0'
      UD6R                                                      CONSTANT
      Value is '0'
      UD6F                                                      CONSTANT
      Value is '0'
      UD7R                                                      CONSTANT
      Value is '0'
      UD7F                                                      CONSTANT
      Value is '0'
      UD8R                                                      CONSTANT
      Value is '0'
      UD8F                                                      CONSTANT
      Value is '0'
      UD9R                                                      CONSTANT
      Value is '0'
      UD9F                                                      CONSTANT
      Value is '0'
      UD10R                                                     CONSTANT
      Value is '0'
      UD10F                                                     CONSTANT
      Value is '0'
      UD11R                                                     CONSTANT
      Value is '0'
      UD11F                                                     CONSTANT
      Value is '0'
      UD12R                                                     CONSTANT
      Value is '0'
      UD12F                                                     CONSTANT
      Value is '0'
      UD13R                                                     CONSTANT
      Value is '0'
      UD13F                                                     CONSTANT
      Value is '0'
      UD14R                                                     CONSTANT
      Value is '0'
      UD14F                                                     CONSTANT
      Value is '0'
      UD15R                                                     CONSTANT
      Value is '0'
      UD15F                                                     CONSTANT
      Value is '0'
      UD16R                                                     CONSTANT
      Value is '0'
      UD16F                                                     CONSTANT
      Value is '0'
      UD17R                                                     CONSTANT
      Value is '0'
      UD17F                                                     CONSTANT
      Value is '0'
      UD18R                                                     CONSTANT
      Value is '0'
      UD18F                                                     CONSTANT
      Value is '0'
      UD19R                                                     CONSTANT
      Value is '0'
      UD19F                                                     CONSTANT
      Value is '0'
      UD20R                                                     CONSTANT
      Value is '0'
      UD20F                                                     CONSTANT
      Value is '0'
      ARCHIVEID                                                 CONSTANT
      Value is '774'
      HASMEMOITEM                                               CONSTANT
      Value is '0'
      STATICDATAKEY                                             CONSTANT
      Value is '0'


      Referential Integrity Constraint/Trigger Information:
      NULL, UNIQUE, and PRIMARY KEY constraints are unaffected.

      Trigger FDMAUCHAN."TWADMIN154840402517_AK" was disabled before the load.
      Record 1: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 2: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 3: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 4: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 5: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 6: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 7: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 8: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 9: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 10: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 11: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 12: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 13: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 14: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 15: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 16: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 17: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 18: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 19: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 20: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 21: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 22: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 23: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 24: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 25: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 26: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 27: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 28: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 29: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 30: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 31: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 32: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 33: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 34: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 35: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 36: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 37: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 38: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 39: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 40: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 41: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 42: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 43: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 44: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 45: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 46: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 47: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 48: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 49: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 50: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      Record 51: Rejected - Error on table TWADMIN154840402517, column AMOUNT.
      ORA-01722: numero non valido

      FDMAUCHAN."TWADMIN154840402517_AK" was re-enabled.

      MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.

      Table TWADMIN154840402517:
      +0 Rows successfully loaded.+
      +51 Rows not loaded due to data errors.+
      +0 Rows not loaded because all WHEN clauses were failed.+
      +0 Rows not loaded because all fields were null.+

      Bind array size not used in direct path.
      Column array  rows :    3000
      Stream buffer bytes:  256000
      Read   buffer bytes:18576000

      Total logical records skipped:          0
      Total logical records rejected:        51
      Total logical records discarded:        0
      Total stream buffers loaded by SQL*Loader main thread:        1
      Total stream buffers loaded by SQL*Loader load thread:        0

      Run began on Mer Set 07 16:50:16 2011
      Run ended on Mer Set 07 16:50:17 2011

      Elapsed time was:     00:00:00.56
      CPU time was:         00:00:00.24


      Oracle (SQL-Loader) Bad File Contents:

      +750~|13~|20110131~|YTD~|701306~|1854~|~|153~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711200~|0355~|~|190~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711260~|1822~|~|119~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711260~|1858~|~|142~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711261~|3601~|~|160~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711302~|5308~|~|999~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711383~|1748~|~|010~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711383~|1857~|~|010~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711458~|1608~|~|191~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711468~|0355~|~|181~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711468~|0392~|~|181~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711468~|1565~|~|181~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711468~|1784~|~|181~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711468~|1823~|~|181~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711468~|1848~|~|181~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711468~|1853~|~|181~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711605~|2644~|~|555~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711606~|3601~|~|555~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711641~|2389~|~|999~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|711655~|2649~|~|116~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|721330~|1161~|~|155~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|721330~|1852~|~|010~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|721330~|3539~|~|999~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|721330~|5158~|~|999~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|721340~|3473~|~|190~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|721341~|4263~|~|999~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|721341~|5617~|~|999~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|730001~|3898~|~|010~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|730003~|0355~|~|192~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|730003~|0392~|~|140~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|730003~|1565~|~|142~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|730003~|1795~|~|134~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|730003~|1848~|~|126~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|732000~|1823~|~|130~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|734001~|3601~|~|151~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|761202~|1748~|~|180~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|761205~|5309~|~|181~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|761206~|1608~|~|181~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|761206~|1823~|~|181~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|761210~|1857~|~|181~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|761210~|7347~|~|181~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|H11468~|1854~|~|181~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|H11468~|2644~|~|181~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|H11468~|5309~|~|181~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|H11473~|1784~|~|191~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|H11605~|2644~|~|151~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|H21330~|1161~|~|123~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|H21330~|1161~|~|156~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|H21340~|3898~|~|154~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|H30000~|1854~|~|177~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+
      +750~|13~|20110131~|YTD~|H30000~|1854~|~|188~|SAP~|DEF_ATT~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|~|0~|100.00+


      +[RDMS Bulk Load Error Begin]+
      +     Message:      (4003) - Oracle (SQL-Loader) data load failed, please see processing log for details!+
      +     See Bulk Load File:      C:\Users\INSTAL~1\AppData\Local\Temp\tWadmin154840402517.tmp+
      +[RDMS Bulk Load Error End]+