Modifying NACHA ACH report to accomodate record 7 addenda on a CCD format.
We are trying to modify the ACH report to insert record 7 addenda on a CCD format as in CTX format but we are having problem with the customized output that is creating a space between end of record 1 position 94 and the next record. Record number 5 is now starting from position 96 instead of 95. Please advise if you have any idea what could be the problem.
We are running Oracle EBS 11.5.10.2 .
select '1'||'01'||' '||
substr(abb.bank_num, 1, 9) ||'1'||
lpad(substr(:p_tax_id,1,9),9,'0')||
to_char(sysdate, 'YYMMDD')||
to_char(sysdate, 'HHMM')||
substr(:p_file_count,1,1)||'094'||'10'||'1'||
select '1'||'01'||' '||
substr(abb.bank_num, 1, 9) ||'1'||
lpad(substr(:p_tax_id,1,9),9,'0')||
to_char(sysdate, 'YYMMDD')||
to_char(sysdate, 'HHMM')||
substr(:p_file_count,1,1)||'094'||'10'||'1'||
Tagged:
0