Oracle EBS Receivables Consultant - Remote

arlington, Virginia

Our client is seeking an expert consultant with Oracle EBS Receivables to join their team. 

This is a remote position. 

Project Description:

  • Implement a fully integrated ACH payment system that  members can use to pay their Retirement Security and Admin plan invoices; 401(k) Pension Plan loans & contributions and Employer Expense invoices
  • Manage multiple bank accounts agnostic of product line(s) on  Employee Benefits website

Developer Description:

  • Familiarity with Oracle EBS 12.1.3 Receivables functionality specifically in the following areas:
    • Cash receipt creation and application business process
    • Cash receipt creation and application using standard APIs
    • Adjustment receipt creation using standard APIs
    • Cash receipt reversal using standard APIs
    • Automated bank settlement (creation of ACH files using Oracle Payments)
    • Creation of bank settlement reports and ACH templates using BI Publisher
    • Reconciliation of cash receipts via Cash Management

Responsibilities

  • Document and perform necessary setup in Receivables to facilitate the creation of automatic receipts
  • Develops PL/SQL packages and procedures
    • To retrieve a list of open invoices for a customer
    • To create and apply a receipt to an invoice using standard APIs
    • To create adjustments using standard APIs
    • To reverse a receipt using standard APIs
  • Document and perform necessary setup to integrate with Oracle Payments to generate bank settlement ACH files
  • Create ACH templates using BI Publisher
  • Create bank settlement reports using BI Publisher with outputs in PDF and CSV
  • Perform necessary setup to integrate with Cash Management to enable automatic clearing and reconciliation of receipts
  • Will work on the applications development & support team working closely with other developers and business partners;
  • Identify/resolve technical issues
  • Maintain technical documentation
  • Attend project status meetings as requested 

Qualifications

  • 5+ years of demonstrated experience with Oracle SQL Development for Oracle EBS 12.1.3 Receivables
  • Extensive experience working with open interfaces in EBS
  • Expertise with Oracle RICE components (Reports, Interfaces, Conversions, and Enhancements or Extensions)
  • Extensive experience in SQL/PLSQL and data modelling for extensions in EBS
  • Experience creating templates using Oracle BIPublisher
  • Experience writing functional requirements and/or functional designs documents
  • Demonstrated proficiency and experience with source control and deployment automation GitHub and TeamCity
  • Strong problem-solving and analytical skills
  • Able to work independently as well as collaboratively with internal and external stakeholders
  • Possess positive, enthusiastic attitude and excellent oral and written communication skills
  • Able to hold customer discussions in professional manner

Job keywords:

Address
Files must be less than 2 MB.
Allowed file types: doc docx pdf.

Vertical Tabs