Thursday, 31 March 2016

Oracle Apps R12/11g Technical online training with Real time Server

SITC India providing professional Oracle Apps R12 Technical Training in Bangalore,Hyderabad location by experienced Oracle Technical consultants working in reputed companies / MNC’. Our training strategies are Class room training / Online live classes. Trainers are Experienced Oracle working professionals as technical consultant. Faculty will provide real time scenario along with practical hands on.

Individual training with one to one focus would be given along with focus on projectscenario, more focus provided on practical’s, examples, assignments etc. Our Oracle trained candidates are well posted in Projects for Companies like TCS, Wipro, Hexaware, Accenture, Price Waterhouse Coopers, Infosys and CTS.

Prerequisite: Oracle SQL, PL SQL, Reports and forms knowledge is must

ORACLE APPS Technical Course Content

Introduction to ERP

1. Definition of ERP
2. Overview of popular ERP’S
3. Comparison of Oracle Apps with other ERP’S
4. AIM documentation standards
5. Oracle Application Architecture.
6. Database structure of OA Using TOAD
7. Introduction to SQL and PL/SQL.

8. Application Object Library
System Administration and Application Object Library (AOL)
Defining an Applications User and Assigning the Responsibilities.
Understanding AOL and its Components
WHO columns
Creating Responsibilities
Request group creation
Menu Creation.

9. Application development 
Defining concurrent program
Concurrent programs with parameters
Working with multiple concurrent program
Concurrent Program incompatibilities
Creating Request Set
Default Types
1. Value sets.

10. Registration of Custom Objects
Report registration
Registration of a Table.

11. Interfaces and Conversions
Introduction to Interfaces
Difference Between Interfaces and Conversions
Outbound Interfaces
1. Using UTL_FILE package
Inbound Interfaces
1.Using SQL * Loader tool SQL * Loader Concepts o Data File.
2. Control File.
3. Bad File.
4. Discard File.
5. Log File.
Working with staging table script
Developing validations package
Standards to be followed in conversions
Using oracle API’s in Interfaces and Conversions
Interface Tables and Error Tables.

12. Flex Fields
Overview of flex fields
Types of Flex Fields
1. Descriptive Flex Fields
2. Key Flex Fields
Steps in creation of DFF
Flex fields tables and relations.

13. Profiles
Overview of profile options
Different levels in Setting profiles
Steps in setting a profile option
Some important profile options
Some important API’s of profiles.

14. Value sets
Overview of value sets
Options in value sets
Types of value sets
Creation of value set
Overview of value set tables
Usage of $FLEX and $PROFILE.

15. Multi Org Concepts
What is Multi Org and why we need.
Multi Org Tables.
Multi Org Views.

16. Functional Modules Overview
Overview of Procure to Pay Flow (P2P Cycle)
Overview of Order to Cash Flow (O2C Cycle)
Major setups and transactions
Overview of important tables in HRMS,PO,INV,OM,AP,AP,GL.

17. Reports in Oracle Applications
Introduction and Usage of USER_EXITS.
Developing a Report from scratch as per Client Requirement.
Developing a Report based on MD 50 Document.
Customization of Oracle Standard Reports.
Reports Registration Steps in Oracle Applications
Standards to develop a report in Oracle Apps.

18. Forms in Oracle Applications
New Form Development Process
Form Registration in Oracle Applications.
Calling one Form to another Form by using Button
Master-Detailed Forms
Form Personalization in Oracle Applications
Form Personalization v/s Form Customization.

19. Development of XML Publisher Reports.


At the end of session CV preparation, Interview questions, Placement Guidance will be provided. As SITC India is manpower sourcing company providing manpower fresher to experienced in Oracle and other technology across india we can support our students well for Placements in Reputed IT companies and MNC’s.



Oracle Apps Training institutes in Singapore |Best online training provider in Singapore

SITC Singapore is one of the Best Oracle Apps (SCM,TECHNICAL,FINANCIALS) online Training in SINGAPORE. Since Oracle is one of the most demanding technology in the Job Market, because Oracle applications are found in Database design, Applications, DBA, ERP, Complicated operations of Business Intelligence, data warehousing etc and it can be comfortably handled by Oracle Software. We aim at providing training that fulfills the need of Oracle professionals in the IT field.

Mode of Training:
» Online Training
» Real Time Training
» Class Room
» Fast Track
» Weekend Batches 
» Placement Assistance

Oracle Apps Technical Course

As Oracle Apps is pre developed software, client may not be satisfied with the standard objects. They always expect changes. Here comes the role of a technical consultant.
He plays a very important role in customizing the standard software and satisfy the client.

Training Will Focus On
» Interfaces
» Oracle Forms 
» Conversions
» Workflows
» BI Publisher
» Discoverer
» Oracle Reports.

Oracle Supply Chain Management Oversight

The R12 Oracle EBS/ERP Supply Chain Management (SCM) integration of modules type of supply chain management performance, commencing plan, forecast, and procurement to manufacturing and fulfilment. Whether you need to update and computerize the entire sales order process, recommend guided selling to your customers, prepare and devise worldwide supply chains more successfully, enter into high-class project information, or implement modules in Oracle Application, we have the suitable plan for you. Oracle Supply Chain Management, management on Oracle technology, gives you industry-leading presentation and innovation . Once you are trained on the fundamentals of Oracle R12 EBS/ERP, you can build up higher knowledge in any of the following focal point areas:

» Pricing
» Service
» Planning
» Inventory
» Purchasing 
» Order to Cash 
» Procure to Pay
» Manufacturing
» Order Processing.

Oracle Functional Financial Applications Oversight

Oracle Functional Financial Applications, includes General Ledger(GL), Accounts Payables(AP), Fixed Assets(FA), Accounts Receivables(AR) and Cash Management(CE). As a part of the training we are going to learn about two major business cycles 1.P2P(PROCURE TO PAY) & 2.O2C(ORDER TO CASH). Also students will be trained, concepts that are built-in crosswise these applications such as Suppliers, Customers, Bank , Employees, Job, Position & Employee Hierarchy and Items. In totting up to learning about these concepts, you learn how they work together in diverse work flows to suit your business requirements. You will also be able to attempt many of these concepts in class using a cycle of hands on practices, which allow you to understand both the tools and the workflows which are integration of modules .Once you learn the fundamentals of Oracle R12 ERP Application , you can develop knowledge in any of the following focus areas: 

» Order to Cash 
» Procure to Pay
» Accounts Payable 
» Cash Management 
» Asset Management
» Accounts Receivable 
» General Ledger Management.





Wednesday, 30 March 2016

Oracle Apps SCM Functional online training |Best Oracle e-learning center in Canada



Specto IT Services distinguished itself as the leading Oracle Apps SCM online Training Institute in Canada. Our Oracle Apps SCM Training Consultants or Trainers are highly qualified and Experienced to deliver high-quality Oracle Apps SCM Training across Canada. 

Specto IT Services is considered pioneer in the filed of IT/Non-IT Training in Bangalore. We are mainly focused on revolutionizing learning by making it interesting and motivating. we provide range of career oriented courses for different segments like students, job seekers and corporate citizens. 

Our team of certified experts have designed our Oracle Apps SCM Training course content and syllabus based on current requirements from the industry. This enables them to be an Industry-Ready Professional, capable of handling majority of the real-world scenarios. Specto IT Services also offer tailored made Oracle Apps SCM Training courses for Corporates. 

Oracle Apps SCM trainer Profile & Placement

Our Oracle Apps SCM online Trainers
More than 10 Years of experience in Oracle® Apps SCM Technologies
Has worked on multiple realtime Oracle Apps SCM projects
Working in a top MNC company in Bangalore
Trained 2000+ Students so far.
Strong Theoretical & Practical Knowledge
certified Professionals
Oracle Apps SCM Placement Training in Bangalore
More than 2000+ students Trained
92% percent Placement Record
1000+ Interviews Organized
Oracle Apps SCM training Locations in Canada
Our Oracle Apps SCM Training centers

Oracle Apps SCM training batch size in Canada
Regular Batch ( Morning, Day time & Evening)
Seats Available : 4 (maximum)
Weekend Training Batch( Saturday, Sunday & Holidays).

Seats Available : 4(maximum)
Fast Track batch

Seats Available : 5 (maximum).


Oracle Apps Financials training | Online&Corporate|Hyderabad USA UK

Oracle Apps Financials training | Online&Corporate|Hyderabad USA UK

Oracle APPS Financials Information:

Oracle Apps Financials is a tightly integrated with set of financial management solutions that enable companies to manage their business globally, lower administration costs,  improve cash management, close books faster and make better decisions. This module gives complete overview of Oracle Financial applications how they easily integrates with other Oracle Applications modules. It presents an overview of using and navigating through Oracle Application forms and some Oracle power features.

Training of Oracle Apps Financials:

Oracle Financials is an industrial strength accounting software package from Oracle Corporation. Modules which are included in it are General Ledger, Payroll, Accounts Receivable and Payable and so on. Actually Financials is used especially by larger corporations.


Students must have awareness in Concepts of Oracle PL/SQL and D2K. Some basic Java Programming knowledge is required.


Introduction to Oracle Financials

Integration among Financials

System Administration

Define Users and assign Responsibilities

Concept of Concurrent Programs / Reports

Concept of Profile Options and their significance

Journal Entry

Recurring / Tax / STAT / Suspense / Reverse

Mass Allocation / Conversion / Inter company

Genera ledger

Configuration / Setup

Define (Non-ISO) or Enable (ISO) Currencies

Design Accounting Calendar

Concept of Flex fields in Oracle Applications

Difference between Key and Descriptive Flex fields

Design Value Sets and Define Values

Design Chart of Accounts and Considerations

Design Set of Books

Assign Set of Books to Responsibilities

Journal Processing

Enter Manual Journals

Post individual and multiple

Journals Automate Journal posting

View Account Balances online

Run reports to view account balances

Reverse Journals after posting

Automate Journal Reversals

Inter-company Journals: Processing and Issues

Inter-company Journals: Processing and Issues

Design Suspense Accounts

Design Suspense Accounts

Journal Approvals

Journal Approvals

Journal Entry Tax and its relevance

Journal Entry Tax and its relevance

Roll up Groups and Summary Templates

Roll up Groups and Summary Templates

Document Sequence for journals

Document Sequence for journals

Import Journals from other applications, Legacy Systems

Import Journals from other applications, Legacy Systems


Enter Budgets Manually

Post Budgets

View Budget or Fund Balances



Need for Revaluation

Design the template


Business Consideration

View Balances


Business Needs

Map Subsidiaries to Parent

View Results

Multiple Reporting Currencies

Business Needs

Advantages and Limitations

Accounts Receivables

Accounts Receivables

Configuration / Setup

System Options

Auto accounting

Grouping rules

Other setup steps

Define Customers

Define Customers

Invoice Processing

Standard Invoices

Credit Memo/ Debit Memo

Customer Advance

Recurring Invoices

Import Invoice using AutoInvoic Import

Adjustments to Invoices



Receipts Processing

Individual/ Batches

Open Receipts

Apply against invoices

Supplier/ Customer knockoff

Adjustments to Receipts: Editing/ Cancellation

Adjustments to Receipts: Editing/ Cancellation

Accounting Events: Introduction/ Transfer to GL

Accounting Events: Introduction/ Transfer to GL

Bills Receivables

Bills Receivables

Cash Management

Enter Bank Statements

Manual Entry

Import Statements from bank (Concept)




Cash Forecasting

Cash Forecasting

Cash Positioning

Data Migration/ Conversion

Open Interfaces


Multiple Organizations

Need for multiple organizations

Business Group

Legal Entity

Operating Unit

Inventory Organization

Configuration / Setup

Map Set of Books

Design Financials Options

Design Payable Options

Create Bank Accounts

Payment Terms/ Distribution Sets

Taxes (Input, Offset, Recoverable, Withholding)

Special Calendars

Control Accounting Periods

Create Suppliers and Employees

Create Suppliers and Employees

Invoice Processing

Standard Invoices

Credit Memo/ Debit Memo

Expense Reports (Employee Reimbursements)

Prepayments (Supplier Advances)

Recurring or Regular Invoices

Quick Data Entry

Create A/c entries and transfer to GL

Adjustments to Invoices

Edit Invoices


Hold Invoices

Hold Invoices

Import invoices from other applications

Import invoices from other applications

Payment Processing

Individual Payments

Batch Payments

Void/ Cancellation

Payment Reconciliation

Integration with Cash Management

Accounting Events

Transfer Assets to Fixed Assets

Editing Cancellation

Fixed Assets

Setup Calendar

Setup category

Setup Asset Book Asset Addition

Asset Retirement

Asset Revaluation

Mass Additions

Lease Asset.



Microsoft dynamics ax 2012 r3 training | Trade and Logistics online training institute

Microsoft Dynamics AX 2012 Financials and Trade & Logistics course explores some of the basic financial functionality available in Microsoft Dynamics AX. Students will be introduced to set up processes in General Ledger, Accounts Payable, Accounts Receivable, and the Bank module, as well as how to enter transactions in each. The course goes on to explore topics such as the setup and usage of budgeting, cash flow management, multicurrency, intercompany, and consolidated accounting. Additionally, students learn about the multiple advanced payment options, how to produce customer account statements, collection letters, complete year-end close functionality, and produce financial statements. 

General knowledge of Microsoft Windows
The ability to use Microsoft Dynamics AX 2012 for basic processing.
Completed the Supply Chain Foundation in Microsoft Dynamics AX 2012 course.

General knowledge of Microsoft Windows
The ability to use Microsoft Dynamics AX 2012 for basic processing.
Completed the Supply Chain Foundation in Microsoft Dynamics AX 2012 course.

Module 1: Overview
Distribution and Trade

Module 2: Over/Under Delivery and Charges
Over/Under Delivery
Price Charges
Charges Codes
Manual Charges
Automatic Charges.

Module 3: Customer and Vendor Agreements
Activate Trade Agreements
Set Up Trade Agreements
Trade Agreements Parameters
Supplementary Items
Purchase and Sales Agreements.

Module 5: Quarantine Management
Quarantine Warehouse Setup Parameters
Quarantine Item Management
Inventory Transactions on Quarantine Items.

Module 6: Vendor Returns
Create Vendor Returns
Create Vendor Returns for Serialized Items
Module 7: Sales Quotations
Sales Quotation Setup
Working with Quotations
Additional Sales Quotation Features.

Module 8: Item Reservations
Why Perform Reservations and What You Can Reserve?
Manual Reservations
Automatic Reservations
Automatic Reservations and Selection of Batch
Explosion Reservations
View Reservations
Lock Reservations
Cancel Reservations
Batch Reservation
Picking Reserved Items.

Module 9: Sales Order Picking
Enable Sales Order Picking and Setup
Release Sales Order Picking
Automatic Registration of a Pick
Manual Registration of a Pick
Item Pick Registration of a Serial and Batch Inventory
Edit, Reverse and Split a Pick.

Module 10: Customer Returns
Set up Customer Returns
Create a Return Order
Item Arrival and Receipt Registration
Quarantine Orders
Replacement Orders.

Module 11: Commissions
Set Up a Commission
View Commission Transactions
Commission Transactions For Return Items.

Module 12: Transfer Orders
Set Up of Transfer Orders
Using the Transfer order Form
Picking Items For a Transfer Order
Shipping and Receiving a Transfer Order.

Module 13: Reports
ABC Inventory Classification
Inventory Reports
Forecasting Reports.



Tuesday, 29 March 2016

Live online training classes in USA |Oracle Apps R12 Financials training


Oracle Application Functional Training Institutes & Training Centers in USA, Oracle Application Functional Course in USA

All topics are covered in extreme detail with practical examples for all. Theoretical Classes will be accompanied by practical sessions at our computer lab. Some of the topics may have been missed from the displayed syllabus below, which nonetheless will be covered during training session. To know more, contact us via the Phone or the Form below.

R12 Summary Course Content

1.Payables (AP)
2.Receivables (AR)
3.General Ledger (GL)
4.Fixed Assets (FA)
5.Cash Management (CE)
6.Multi Org Access Control (MOAC)
7.Sub Ledger Accounting (SLA)
R12 Detailed Course Content,Basic Concepts of R12

1.Architectural Overview รข€“ System Administration
2.UI Navigation changes in R12 Vs 11i
3.Flex fields
4.Access and Controls
5.Functional overview of Products
6.Concepts of LE/OU/Chart of Accounts
7.Differences between R11 Vs 11i-sneek peek review
8.Creation of Users and assignment of Responsibilities
9.Profile Options and security controls

1.Invoice Vs Inv Batch
2.Creation of Invoices (All types of Invoices)
3.Prepayment Application and Unapplication
4.Payment of Invoices- Full and Partial
5.Invoice Accounting
6.Payables Options
7.Financials Options
8.System Hold and Manual Holds
9.Distribution Set Vs Distribution Accounts
10.Retainage Release Calculation
11.WH Taxes
12.Recurring Invoices
13.Supplier Setup
14.Multi Currency payments
Payables Intergration Areas

1.Procure to Pay (end to end flow)
2.Creation of PO
5.Invoice Matching and Payment for the same
6.2/3/4 way matching with PO
7.Auto Invoice from PO
8.Automatic Offset
9.Creation of isupplier portal
10.Supplier PO Management
11.Data Model Analysis
12.AP Backend data model
13.Tables impacted on updation
14.Retainage Release
15.Fixed Assets Integration
Funds Capture

1.Process flow for funds capture
2.Auths Vs Settlements
3.Credit Card Creation
4.Brand activation Vs Inactivation
5.Assignment of credit card and Bank accounts to customer
6.Encryption Vs Masking
7.Creation of Funds Capture Process Profile
8.Creation of Payee
9.Mapping FCPP, PSA and Payees with OU
10.Transaction testing auths & settlements
11.Auth Capture
12.Credit Card refund
13.Invoking FC from AR/OM and collections
Multi Org Access Control(MOAC)

1.Changes in 11i Vs R12
2.Security Profile Options
3.Security list maintenance
4.Assigning security to users and responsibilities
Fixed Assets

1.Asset Books vs Finance Book
2.Asset Creation
3.Calculation of Depreciation
4.Paying a capital asset PO via AP
5.Mass Addition
7.Transfer of Asset
8.Group Vs Member Assets
Cash Management

1.Changes in R12 Vs 11i
2.Creation of Banks/Branches/Accounts
3.Distinction between Internal bank accounts and external bank accounts
4.Controls in Cash Management
5.Reconciliation Manual and Auto Reconciliation
6.UMX Security Controls
7.Back end SQL data model for internal and external bank accounts
8.Cash Clearing
9.Bank Account Transfers
10.Cash Positioning and Forecasting
Accounts Receivable

1.Creation of Transaction
2.Receivable Options
3.Receipt Manual Vs Automatic
4.Receipt Application Vs Unapplication
6.Refund Manual Vs Credit Card
7.Charge Back
8.Customer setups
9.Auto Cash Rule set
10.Balance Forward Billing
11.Type of Transactions and set off with Credit Memo
12.Accounts Overview
Sale Order Management integration with Financial Modules(AR)

1.Auto Import Orders
2.Creation of Invoices in AR using import from OM
3.Payment of Sales Order using Credit card

1.Data Model Analysis for Funds Disbursement
2.Data Model Analysis for Funds Capture

1.I Receivables
2.I Supplier Portal
Financial Statement Generator

1.Prepare Income statement
2.Balance Sheet
Sublegder Accounting Methods (SLAM)

1.Architectural Overview
2.Even Model in R12 Vs 11i
3.Accounting Events Definition
4.Accounting Events in Payables
5.Accounting Events in Receivables
6.Modifying seeded AAD, JLT and JLD
Oracle General Ledger

1.Creation of Ledger
2.Accounting Setup Manager
3.Open and Close periods
4.Mapping of 4 =Currency, Calendar, COA and Convention
5.Primary and Secondary Ledger
6.Reporting Currency Ledger
7.Transfer/Post Accounting entries to GL
8.Creation of recurring journals
9.Data Conversion Levels
10.COA Mapping
11.Ledger Vs Ledger Sets
13.Data Access Set Vs Definition Access Set
Oracle Payments(IBY):

1.Funds Disbursement
2.Changes in R12 Vs 11i
3.Role of New Payment Set up Administrator
4.Creation of Payment Process Profile
5.Creation of Payment methods
6.Mapping PPP and Payment Documents with Internal bank Accounts
7.Payment Process Request Templated and Submission
8.Manual Vs Automatic completion
9.Overview of Federal formats
10.Scheduling Requests in Real time
11.Assignment of Bank Accounts and PPP
12.Paying different supplier and in single pay run
13.Review proposed payments
14.Add & Remove invoices during payments
15.Electronic and Printed Payments
16.Multi Currency Payments
17.Validations during payment
18.Resolve document & payment validation errors
19.Payment Limits
20.MOAC Payments
21.Decentralised AP and Payments
22.Centralized AP and Payments
24.Void and Stop Payments
25.Void by overflow
26.Skipped documents.



Monday, 28 March 2016

Microsoft dynamics ax 2012 R3 Technical online training & Certifications

Specto’s training courses are aimed at a wide audience of people, including technical staff responsible for the installation, configuration and administration of the Dynamics AX and CRM technology as well as the end users that will actually use Dynamics AX 2012 R3 and CRM on a day-to-day basis. Our Microsoft CRM and AX training programs are oriented toward hands-on practical experience to reinforce formal classroom instruction.
Specto’s Microsoft Dynamics AX and CRM Training Courses provide your team members with the knowledge they need to take full advantage of Dynamics AX 2012 and Dynamics CRM capabilities, and use them to meet your organization’s business requirements. Our Dynamics AX and CRM courses can be customized for various roles within your organization such as Business Managers, Accountants, Sales, Purchasing, Planning, Production, Developers, and Administrators to ensure that you have all the expertise you need to get the most out of your Dynamics AX and CRM investment. The earlier your team begins gaining that expertise, the more successful your AX and CRM solution will be.
Module 1: Architecture
This module describes the architecture of Microsoft Dynamics AX 2012. Microsoft Dynamics AX is a completely integrated solution and is web-enabled and supports Microsoft SQL Server. With customizable source code, the solution can be modified however and whenever it is necessary.
  • Introduction
  • Features of Microsoft Dynamics AX
  • Architecture
  • Development Environment
  • Model Driven Architecture
  • Licensing and Configuration
Lab : Create a New Model and a Development Project
After completing this module, delegates will be able to:
  • Describe the basic features of Microsoft Dynamics AX 2012.
  • Review basic form navigation.
  • Review the architecture of Microsoft Dynamics AX 2012.
  • Describe the options for making development changes in Microsoft Dynamics AX 2012.
  • Describe the theory of Model Driven Architecture in Microsoft Dynamics AX 2012.
  • Review licensing and configuration.
Module 2: Data Dictionary
This chapter introduces the tools and procedures used to create tables, data types, and relations that are required in Microsoft Dynamics AX.
  • Introduction
  • MorphX and the Application Object Tree
  • Tables
  • Data Types: Primitive and Extended
  • Creating Tables
  • Indexes
  • Relations
  • Base Enumerations
  • Views
Lab : Create a New EDT
Lab : Create a New Table
Lab : Create a Primary Key
Lab : Create a Relation
Lab : Add an Enum
After completing this module, delegates will be able to:
  • Explain the MorphX development environment and the Application Object Tree
  • Design tables using MorphX
  • Describe the different data types within Microsoft Dynamics AX
  • Create a new table
  • Learn how to create and modify indexes using MorphX
  • Describe relations on Microsoft Dynamics AX tables
  • Learn how to create and modify Enumerated data types
  • Learn how to create and modify views.
Module 3: User Interfaces
This module discusses how to develop the user interface without having to write any code.
Forms are created so that the end-user can enter and view data. To make navigation easier for the end-user, menus and menu items will be created.
  • Introduction
  • Forms
  • Joining Data Sources
  • Menus Items
  • Form Templates
  • List Pages
  • FactBoxes
Lab : Create a Form
Lab : Create a Form from a Template
After completing this module, delegates will be able to:
  • Design and build Forms in Microsoft Dynamics AX.
  • Join two data sources on a form.
  • Create customized menus and menu items.
  • Create a form using form templates.
  • Know the components of a list page.
  • Create a new FactBox.
Module 4: Security
This module describes the elements of Role Based Security in Microsoft Dynamics AX 2012.
  • Introduction
  • Definitions
  • Set Up a New User
  • Assign a User to a Role
  • Change Duties on a Role
  • Change Privileges on a Duty
  • Assign a Permission to a Privilege
  • Investigate Access
Lab : Create a New Security Role.