Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Wendy Ware
    How to Process CCD+ ACH PaymentsAnswered
    Topic posted September 23, 2019 by Wendy WareBronze Crown: 15,000+ Points, tagged Configuration, Financials, Payables, Setup / Administration 
    45 Views, 7 Comments
    Title:
    How to Process CCD+ ACH Payments
    Summary:
    CCD+ payments in Oracle?
    Content:

    We have a requirement to make an ACH payment which includes CCD+ (addenda record.)  Can anyone provide information about doing this?  Thanks, Wendy

    Version:
    19B (11.13.19.04.0)

    Best Comment

    Glen Ryen

    Hi Wendy,

    Have you done any BI Publisher development or report customization before?  If so, https://docs.oracle.com/cd/E10091_01/doc/bip.1013/b40017/T421739T481436.htm is the doc for eText layout template coding.  Get into the BI Catalog and download one for the seeded ACH layouts, like for CCD NACHA.  View that template with the dev guide open and you can understand the structure of the eText template, what each section does.  That seeded eText would be the baseline that you could make a custom copy of, modifying it to include your TXP addenda records and testing it with your bank. 

    That's the high level, but that does presume some BI Publisher report development skill.  It's not something to tackle if you (or or your team) don't have at least some of that background, plus familiarity with Payments module configuration - so it's usually something that handled as part of an implementation.  And often that's two resources covering the functional and technical.

    So I'm not sure if that's what you were hoping to hear, but does that help?

    Glen

    Comment

     

    • Karthikeyan Sukumar

      Hi Wendy- Do you need to pass the CCD code in the payment file ?

      Thanks!

      Karthik

      • Wendy Ware

        Hi Karthik, I think so, yes.  Attached is the addenda record we need to attach to the payment.  Is this something we configure in Oracle?  Thanks, Wendy

    • Logan Wacker

      The issue is what free form text field are you going to repurpose to map to the payment file? We've run into this issue many times recently and haven't found a viable solution. The issue also persists over to Cash Management. Interested to see what path you take.

    • Glen Ryen

      Hi Wendy,

      Not something you can just configure, but something you can code a layout template to produce.  Are you only making tax payments via CCD+, or vendor payments as well?  I.e., only TXP addenda?

      Glen

      • Wendy Ware

        Hi Glen, just tax payments to one state, possibly a second state.  Can you direct me to guidance for creating a layout template?  Thanks, Wendy

    • Glen Ryen

      Hi Wendy,

      Have you done any BI Publisher development or report customization before?  If so, https://docs.oracle.com/cd/E10091_01/doc/bip.1013/b40017/T421739T481436.htm is the doc for eText layout template coding.  Get into the BI Catalog and download one for the seeded ACH layouts, like for CCD NACHA.  View that template with the dev guide open and you can understand the structure of the eText template, what each section does.  That seeded eText would be the baseline that you could make a custom copy of, modifying it to include your TXP addenda records and testing it with your bank. 

      That's the high level, but that does presume some BI Publisher report development skill.  It's not something to tackle if you (or or your team) don't have at least some of that background, plus familiarity with Payments module configuration - so it's usually something that handled as part of an implementation.  And often that's two resources covering the functional and technical.

      So I'm not sure if that's what you were hoping to hear, but does that help?

      Glen

    • Bhanu G

      Hi,

       

      We have a requirement to display a new records within Entry-Details -Dr(Debit) records region within NACHA-CCD file format . And we have to default this default line with our Disbursement Bank a/c always along with the equal amount of Credit line/s . Meaning our new Debit line amount is always equal to the corresponding Beneficiary credit line amount . In short we want display both Debit & Credit lines from NACHA-CCD file format. Can anyone provide some insights to customize our BI templates/layouts accordingly ..

      Thanks,

      Bhanu