Take from server host of https://freedomma-portals.ikaenterprise.com
GTPA_AFN_LOCKBOX_140227104226_T.TXT
Code:
1000000000 140227LOCKBOX US
700300013 80740 720015
600300113350 13350 6070 MN00008815 NO
600300213350 13350 6070 MN00008852 NO
60030036100 6100 477 MN00006732 NO
60030046100 6100 478 MN00006733 NO
60030057140 7140 4072 MN00012007 NO
60030063270 3270 2255 MN00002958 NO
60030076100 6100 3515 MN00014346 NO
60030083270 3270 1223 MN00011454 NO
60030091370 1370 7084 MN00017014 NO
60030104270 4270 1703 MN00015898 NO
60030116100 6100 1017 MN00012048 NO
60030126100 6100 5172 MN00010305 NO
600301312200 12200 9902 MN00008771 NO
60030145370 5370 1009 MN00012002 NO
814 80740
GTPA_AFN_LOCKBOX_140227104226_T.TXT-Load.log
Code:
SQL*Loader: Release 11.2.0.1.0 - Production on Wed Mar 26 20:00:56 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Control File: D:\Billings\Freedom\AFCNC\Lockbox\Control_Scripts\Lockbox.ctl
Data File: D:\Billings\Freedom\AFCNC\Lockbox\Inbound\GTPA_AFN_LOCKBOX_140227104226_T.TXT
Bad File: lockbox.bad
Discard File: lockbox.dsc
(Allow 999 discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 999999
Bind array: 64 rows, maximum of 1000000 bytes
Continuation: none specified
Path used: Conventional
Table BNC_LOCKBOX_FILE_HEADER_M, loaded when 1:1 = 0X31(character '1')
Insert option in effect for this table: TRUNCATE
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
RECORD_TYPE 1:1 1 CHARACTER
DESTINATION 2:10 9 CHARACTER
FILLER1 11:15 5 CHARACTER
DEPOSIT_DATE 16:21 6 CHARACTER
LOCKBOX 22:28 7 CHARACTER
ACCOUNT_NUMBER 29:40 12 CHARACTER
ROUTING 41:48 8 CHARACTER
CURRENCY 49:52 4 CHARACTER
FILLER2 53:120 68 CHARACTER
Table BNC_LOCKBOX_BATCH_HEADER_M, loaded when 1:1 = 0X37(character '7')
Insert option in effect for this table: TRUNCATE
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
RECORD_TYPE 1:1 1 CHARACTER
BATCH_NUMBER 2:4 3 CHARACTER
ITEM_SEQUENCE_NO 5:7 3 CHARACTER
NUMBER_OF_CHECKS 8:11 4 CHARACTER
BATCH_TOTAL_CHECK_AMOUNT 12:29 18 CHARACTER
FILLER 30:120 91 CHARACTER
Table BNC_LOCKBOX_DETAIL_MG, loaded when 1:1 = 0X36(character '6')
Insert option in effect for this table: TRUNCATE
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
RECORD_TYPE 1:1 1 CHARACTER
BATCH_NUMBER 2:4 3 CHARACTER
ITEM_SEQUENCE_NO 5:7 3 CHARACTER
CHECK_AMOUNT 8:25 18 CHARACTER
AMOUNT_DUE 26:43 18 CHARACTER
STATEMENT_NUMBER 44:59 16 CHARACTER
STATEMENT_AMOUNT 60:77 18 CHARACTER
CHECK_NUMBER 78:85 8 CHARACTER
ACCOUNT_IDENTIFIER 86:86 1 CHARACTER
ACCOUNT_NUMBER 87:102 16 CHARACTER
GROUP_ID 103:118 16 CHARACTER
FILLER 119:120 2 CHARACTER
Table BNC_LOCKBOX_DETAIL_OVERFLOW_M, loaded when 1:1 = 0X34(character '4')
Insert option in effect for this table: TRUNCATE
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
RECORD_TYPE 1:1 1 CHARACTER
BATCH_NUMBER 2:4 3 CHARACTER
ITEM_SEQUENCE_NO 5:7 3 CHARACTER
STATEMENT_NUMBER1 8:23 16 CHARACTER
APPLIED_AMOUNT1 24:41 18 CHARACTER
STATEMENT_NUMBER2 42:57 16 CHARACTER
APPLIED_AMOUNT2 58:75 18 CHARACTER
STATEMENT_NUMBER3 76:91 16 CHARACTER
APPLIED_AMOUNT3 91:109 19 CHARACTER
FILLER 110:120 11 CHARACTER
Table BNC_LOCKBOX_FILE_TRAILER_M, loaded when 1:1 = 0X38(character '8')
Insert option in effect for this table: TRUNCATE
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
RECORD_TYPE 1:1 1 CHARACTER
TOTAL_RECORD_COUNT 2:7 6 CHARACTER
TOTAL_DEPOSIT_AMOUNT 8:25 18 CHARACTER
APPLY_TO_COUNT 26:31 6 CHARACTER
FILLER 32:120 89 CHARACTER
Table BNC_LOCKBOX_FILE_HEADER_M:
1 Row successfully loaded.
0 Rows not loaded due to data errors.
16 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Table BNC_LOCKBOX_BATCH_HEADER_M:
1 Row successfully loaded.
0 Rows not loaded due to data errors.
16 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Table BNC_LOCKBOX_DETAIL_MG:
14 Rows successfully loaded.
0 Rows not loaded due to data errors.
3 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Table BNC_LOCKBOX_DETAIL_OVERFLOW_M:
0 Rows successfully loaded.
0 Rows not loaded due to data errors.
17 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Table BNC_LOCKBOX_FILE_TRAILER_M:
1 Row successfully loaded.
0 Rows not loaded due to data errors.
16 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Space allocated for bind array: 45056 bytes(64 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 17
Total logical records rejected: 0
Total logical records discarded: 0
Run began on Wed Mar 26 20:00:56 2014
Run ended on Wed Mar 26 20:00:56 2014
Elapsed time was: 00:00:00.69
CPU time was: 00:00:00.08
GTPA_AFN_LOCKBOX_140227104226_T.TXT-SQL.log
Code:
old 4: V_SQL:= 'BEGIN BNC_LOCKBOX_MGMT.GROUP_LOCKBOX_MAIN(''&1''); END;' ;
new 4: V_SQL:= 'BEGIN BNC_LOCKBOX_MGMT.GROUP_LOCKBOX_MAIN(''GTPA_AFN_LOCKBOX_140227104226_T.TXT''); END;' ;
TOTAL AMOUNT SENT : 940.9
IKA BATCH NUMBER: LB140227A IKA BATCH TOTAL AMOUNT: 940.9 /APPLIED: 940.9 /NOT
APPLIED (EXCEPTION TOTAL): 0
I AM IN SEND_MAIL BLOCK
PL/SQL procedure successfully completed.