Services

Services

  • Consulting services with access to Oracle consultants.
  • Helping our clients with employees who complement our commitment to quality, integrity and hard work.
  • Ability to locate and qualify Oracle Applications Talent matching client requirements.
  • Interacting with client on time-to-time with updated requirements and matching our resource pool.

AC has specialized consulting professionals to deliver custom forms using various technologies Oracle Forms/OAF/ADF that are integrated to Oracle Applications. We have developed custom applications for financial module and integrated process with oracle application.

Implementations:

An effective implementation is the key to unlocking the power of Oracle applications. Clear understanding and documentation of business requirements, thorough Super User and End User training, extensive testing, thoughtful long-term planning, and skillful data migration will ensure a stable application that delivers the expected ROI.

Experienced AC Consulting professionals will bring your Oracle applications to life to leverage all of the power of Oracle.

AC Consulting professionals have experience in dozens of industries, including Financial Services, Oil and Gas, Education, Health Services, Public Sector, High Tech, and more. Our team understands the complexities of personalized reporting, interfacing to vendors with requirements, conforming to current legal regulations and using industry best practices to ensure that your team extracts the most value from your Oracle applications.

Reports:

Provide professional, real-time reports for your entire organization for all financial/HRMS/CRM/MFG Modules.

AC has developed an extensive suite of Financial/HRMS/CRM/MFG Module reports based in BI/XML/NOETIX/Oracle Reports/Discoverer.BI/XML reports can be quickly adapted to your company’s specific requirements, with personalized fields, logos, and colors. Custom reports can also be created with minimal effort. BI/XML reports are accurate, easy-to-read, and offer the professional appearance that you demand when presenting reports to top executives, clients, and most importantly your own employees.Once your reports are complete, AC can simplify the process of running, reviewing, and distributing your reports in Oracle.

Interfacing:

  • AC has extensive experience building interfaces between Oracle and numerous 3rd party vendors.
  • AC can develop an interface with any vendor that will accept data electronically.
  • Our specialization and experience on automating interface process which benefits clients on return for investments.
  • Our experience includes all of the top Benefits vendors, Payroll vendors, and Recruiting job boards.
  • Our team can leverage this experience to quickly connect your database to your vendors, automating data transfer and freeing your team to concentrate on more value-added tasks.

Integration:

We are specialized integrating 3rd party technology products to Oracle Applications using SOA Architecture as one of the tools. Other integration for Oracle application products includes:

  • Integration with Google Chart and Map
  • XML publisher OAF integration
  • Integrating OAF notifications, OAF regions in oracle workflow
  • Invoke Discoverer Reports from OAF Page
  • BI publisher BI discoverer integration
  • BI publisher OBIEE integration
  • XML publisher and concurrent manager integration
  • Integrating Oracle Workflow with Oracle Reports 10g
  • Integrate Custom Report Into the E-Business Intelligence (BIS) Portal
  • Integrate Discoverer 10g with Oracle Applications
  • Integrating Oracle Forms Into ADF
  • Integrating BI Publisher with Oracle form
  • Launching a custom oracle EBS workflow from oaf page
  • Integrate Apex with Oracle Applications

Oracle Application Techno-Functional Training Outline

General Concepts

  • Business Terminology
  • Oracle Apps Architecture
  • Multi Org Structure
  • MOAC in R12
  • SQL Loader

Interface, Conversion & API

  • Interface, Conversion & API
  • Real Time example
  • Item / Order Import interface hands on
  • API’s Concept & hands on
  • SQL Loader

Order Management

  • Sales Order Header and Line level Status
  • Sales Order Types
  • Price Lists, Modifiers & Qualifiers
  • Defaulting Rules
  • Tables & OM Interfaces
  • Available to Promise

Inventory

  • Master Org vs Child Org
  • Important Item Attributes
  • Item On-hand Quantities
  • Inventory Receipts
  • Lot Numbers, Serial Number, Locators
  • Inventory Miscellaneous Transactions
  • Sub Inventory Transfers
  • Inter Org Transfers
  • Item Categories
  • Item Templates

Receivables

  • TCA Architecture
  • Customer creation
  • Invoices, Credit Memos, Debit Memos
  • Chargeback, Write off
  • Cash Receipts

Payables

  • Types of Invoices in AP
  • Single Payment
  • Payment Manager Concept
  • Matching Rules

Workflow

  • Create new Workflow
  • Workflow components
  • Workflow administrator
  • Customize workflow

Forms Personalization

  • Personalization vs Customization
  • Personalization Triggers
  • Actions, Property types

Reports

  • XML Publisher Report
  • Report registration and deployment
  • Report Triggers
  • Upgrade and Migration

SLA & GL

  • Importance of SLA
  • Understanding Accounting KFF
  • Transfer Accounting entries to GL
  • Create Manual Journal Entries
  • GL Period Status meanings
  • Checking Account balance

Oracle APEX Training Outline

  • Understand the Oracle APEX architecture
  • Use SQL Workshop to interface with and manipulate your data
  • Build database-centric Web applications using Application Builder
  • Create web-based forms and reports
  • Secure your web applications
  • Deploy your web applications
  • Build a web sheet application
  • Explore the new features in the latest release of Oracle APEX

Oracle HCM Training Outline

  • OA Framework MVC Architecture
  • Setup of Jdeveloper with OAF Extension
  • Overview of JDeveloper
  • Build Hello World and Sample login page
  • Overview of OA Framework files
  • OA Framework Page Basics
  • OA Framework Coding Standards
  • Simple Search Page
  • Example on 1 Real-time Search page
  • Covers CO,VO,AM,EO,VL,AO
  • Simple Create page Example
  • Real-time Example on Create page
  • One assignment on Create page.
  • List of Values(LOV)

     

  • Poplist, Radio buttons, check box with examples
  • Real-time Example on Create page
  • One assignment on Create page.
  • List of Values(LOV)
  • Poplist, Radio buttons, check box with examples
  • Demo of Page Content Layout
  • Different type of Regions
  • Tokens & URL Parameters
  • Side Navigator Search
  • Quick Links

Oracle SOA Training Outline

  • SOA Concepts And Oracle SOA 12c Product Stack Architecture
  • Concept of Web Services, WSDL, XSD, XML and XSLT
  • SCA( Service Component Architecture )
  • BPEL
  • Mediator
  • Human Task
  • Business Rules
  • Oracle Service Bus(OSB)
  • Business Activity Monitoring(BAM)

Mobile Applications ADF Training Outline

  • Develop ADF applications
  • Use ADF Faces
  • Create entity and view objects
  • Understand transactions, validation, and conversion
  • Work with ADF tables
  • Handle forms
  • Create task flows
  • Create ADF regions and bounded task flows
  • Set up ADF navigation
  • Secure ADF
  • Consume web services from ADF
  • Customize ADF programmatically
  • Troubleshoot ADF applications
  • Deploy ADF applications

QA Training Outline

  • Software development and Testing Phases
  • Types of Testing, Agile Methodology and Live Project Overview
  • STLC and Test Scenarios
  • ROI, Cost of Quality, FSD, Writing Test Cases
  • Test Plan Complete Walkthrough
  • Test case writing process, Test Data
  • OA Framework Coding Standards
  • Test Execution, Traceability matrix, reviews, Status reporting
  • Defect management, Quality tools, Change management, version control
  • Automation overview, HP QTP overview