Payables and Cash Management - EBS (MOSC)

MOSC Banner

Modifying NACHA ACH report to accomodate record 7 addenda on a CCD format.

edited Sep 25, 2009 3:47AM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered
 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'||

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center