Send your profile with the details of similar trainings facilitated to jobs@compassclock.in
56 day training program Rs.500 ~ 1,500/ hr for training. Total of (70 hours softskill & Technical of 300 hours (upto Rs. 4,50.000) in 56 working days.
The hourly fee is based on trainer's experience and subject knowledge
(Program start date End of August 2025)
Trainer from Mumbai & Bengaluru are preferred (Good Communication in English & regional language is a must)
| DAYS | Duration(Min) | Duration (In Hours) | Subject | Topics |
DAY 1 | 180 | 3 | Power skills ( Behavioural) & Language proficiency -Foundation – session 1 | # Ice breaking, Objective setting # Learning values (Capgemini Values & compliance) # Metamorphosis (video) # Attitude and Behaviour (KASH concept knowledge, attitude, Skill, Habit) # Hybrid model of work # Communication skills (Modes and overview) # Introduction to written communication (dos and don’ts of emails) # Grooming (Hygiene Squad) |
| 60 | 1 | Programming Fundamentals | Introduction to program development with Pseudocode | |
| 60 | 1 | Models/Analyze the requirement | ||
| 60 | 1 | Introduction to Pseudocode_Usage of variables and operators | ||
DAY 2 | 60 | 1 | Programming Fundamentals | Introduction to control constructs and arrays |
| 60 | 1 | Good Programming Practices | ||
| 60 | 1 | Software Reviews and Testing | ||
| 60 | 1 | Exhaustive Testing_Economics | ||
| 60 | 1 | Static Testing | ||
| 60 | 1 | Dynamic Testing | ||
DAY 3 | 90 | 1.5 | Introduction to software Engineering | Introduction to Software Engineering |
| 90 | 1.5 | Common life cycle models | ||
| 120 | 2 | Phases in SE | ||
| 60 | 1 | Review and Configuration Management Process | ||
DAY 4 | 60 | 1 | ERP Overview | ERP Fundamentals |
| 60 | 1 | ERP Evolution and Industry Growth | ||
| 60 | 1 | ERP benefits and options overview | ||
| 60 | 1 | ERP Product Selection, Preparation Phase, and Gap Analysis | ||
| 60 | 1 | Production and Implementation Phase | ||
| 60 | 1 | Different Methods in implementing ERP | ||
DAY 5 | 60 | 1 | ERP Overview | Infrastructure of Data Centre |
| 90 | 1.5 | UNIX | Introduction to UNIX | |
| 60 | 1 | UNIX File System | ||
| 60 | 1 | Basic UNIX commands, tools and utilities | ||
| 60 | 1 | Processes in UNIX | ||
DAY 6 | 60 | 1 | UNIX | Overview of the ‘vi’ editor |
| 90 | 1.5 | Advanced Filters | ||
| 60 | 1 | Shell Programming Part 1 | ||
| 60 | 1 | Shell Programming Part 2 | ||
DAY 7 | 180 | 3 | Power skills ( Behavioural ) & Language proficiency -Foundation – session 2 | # Introduction to parts of speech & Subject verb agreement and Articles # Content videos # Activity bases learnings (role play activity) # Application of Email Writing skills |
| 120 | 2 | Oracle | Introduction to Database Part 1 | |
| 120 | 2 | Introduction to Database Part 2 | ||
DAY 8 | 120 | 2 | Oracle | Basics of SQL Part 1 |
| 120 | 2 | Basics of SQL Part 2 | ||
| 60 | 1 | Data Query Language Part 1 | ||
| 60 | 1 | Data Query Language Part 2 | ||
DAY 9 | 60 | 1 | Oracle | Data Query Language Part 3 |
| 120 | 2 | Aggregate (Group) Functions | ||
| 120 | 2 | Aggregate (Single row) Functions | ||
DAY 10 | 120 | 2 | Oracle | Joins |
| 60 | 1 | Subquery | ||
| 120 | 2 | Introduction to Data Modeling, ER Modeling and Normalization | ||
DAY 11 | 120 | 2 | Oracle | Database objects |
| 120 | 2 | Set operators | ||
| 90 | 1.5 | Data Manipulation Language | ||
DAY 12 | 120 | 2 | Oracle | Transaction Control Language Part 1 |
| 120 | 2 | Transaction Control Language Part 2 | ||
| 60 | 1 | Data Control language | ||
DAY 13 | 120 | 2 | Power skills ( Behavioural ) & Language proficiency -Foundation – session 3 | # Tenses # Art of pronunciation (verbal’s skills) |
| 120 | 2 | Oracle | Introduction to Oracle Architecture | |
| 90 | 1.5 | Oracle Multitenant Architecture | ||
DAY 14 | 90 | 1.5 | Oracle | Oracle User and Role Management |
| 120 | 2 | Database administration Part 1 | ||
| 120 | 2 | Database administration Part 2 | ||
DAY 15 | 60 | 1 | Oracle | Oracle Data Pump and Export/Import Utilities |
| 120 | 2 | Oracle Performance Tuning Basics | ||
| 120 | 2 | Introduction to Data Dictionary | ||
DAY 16 | 120 | 2 | Oracle | PL/SQL Basics Part 1 |
| PL/SQL Basics Part 2 | ||||
| 120 | 2 | Introduction to Cursors | ||
| 120 | 2 | Exception Handling Part 1 | ||
DAY 17 | 60 | 1 | Oracle | Exception Handling Part 2 |
| 60 | 1 | Procedures, Functions, and Packages Part 1 | ||
| 60 | 1 | Procedures, Functions, and Packages Part 2 | ||
| 60 | 1 | Procedures, Functions, and Packages Part 3 | ||
| 120 | 2 | Database Triggers | ||
DAY 18 | 120 | 2 | Oracle | Locks |
| 120 | 2 | Built-in Packages in Oracle | ||
| 90 | 1.5 | SQL * Plus Reports | ||
DAY 19 | 240 | 4 | Power skills ( Behavioural ) & Language proficiency -Foundation – session 4 | # Introduction to Presentation skills (setting objective) # Albert Mehrabian rule and communication styles # Rules of presentation (3 T’s) # Dos and Don’ts of presentation # Activity on presentation skills by YP’s |
| 90 | 1.5 | Oracle | SQL * Plus Reports | |
DAY 20 | 60 | 1 | Oracle | Oracle Tools Part 1 |
| 60 | 1 | Oracle Tools Part 2 | ||
| 120 | 2 | Bulk Collect & Bulk Bind Part 1 | ||
| 120 | 2 | Bulk Collect & Bulk Bind Part 2 | ||
DAY 21 | 120 | 2 | Oracle | Basic of Coding Standards |
| 120 | 2 | Handlers | ||
| 120 | 2 | Triggers | ||
DAY 22 | 60 | 1 | Oracle | SQL |
| 60 | 1 | PL/SQL Code | ||
| 60 | 1 | EBS Foundations | Oracle Applications Part 1 | |
| 60 | 1 | Oracle Applications Part 2 | ||
| 120 | 2 | Database structure and 3 Tier Architecture | ||
DAY 23 | 90 | 1.5 | EBS Foundations | Application Object Library (AOL) Introduction |
| 60 | 1 | Levels of Oracle Application | ||
| 60 | 1 | Create Users | ||
| 60 | 1 | WHO Columns | ||
| 60 | 1 | Create Responsibility | ||
DAY 24 | 60 | 1 | EBS Foundations | Menu Construction |
| 60 | 1 | Define Concurrent Program | ||
| 60 | 1 | Concurrent Program executables | ||
| 60 | 1 | Concurrent Program with Parameter | ||
| 60 | 1 | Creating Value Set | ||
| 60 | 1 | Scheduling Concurrent Programs | ||
DAY 25 | 180 | 3 | Power skills ( Behavioural ) & Language proficiency -Foundation – session 5 | # Objective setting on written communication C’s (Email etiquette) # Email writing and activities Toxic Positivity |
| 60 | 1 | EBS Foundations | Submitting a Request | |
| 60 | 1 | Understanding the phases | ||
| 60 | 1 | View: Output, Log details - Debugging when error | ||
DAY 26 | 60 | 1 | EBS Foundations | Creating Request Group |
| 60 | 1 | Creating Request Set | ||
| 60 | 1 | Concurrent Program creation using API | ||
| 90 | 1.5 | FLEX Fields | ||
| 60 | 1 | Introduction to Oracle Reports Developer | ||
DAY 27 | 60 | 1 | EBS Foundations | Creating & using Report Parameters |
| 60 | 1 | Formula and Summary Columns | ||
| 60 | 1 | Creating Manual Report | ||
| 60 | 1 | Various features of Paper Layout | ||
| 60 | 1 | Enhancing a basic paper Report | ||
| 60 | 1 | Data conversion & Interfaces | ||
DAY 28 | 60 | 1 | EBS Foundations | Form Personalization |
| 60 | 1 | Overview of API & Interfaces | ||
| 60 | 1 | Inbound / Outbound Interface | ||
| 60 | 1 | Data Conversion | ||
| 60 | 1 | Oracle Forms / OAF forms | ||
| 60 | 1 | Creating Master - Detail relationship between blocks and Running the Form | ||
DAY 29 | 60 | 1 | EBS Foundations | Creating Master - Detail relationship between blocks and Running the Form |
| 60 | 1 | Form Triggers | ||
| 60 | 1 | Oracle Workflow | ||
| 60 | 1 | Developing Workflow process | ||
| 60 | 1 | Defining Item Type Attributes | ||
| 60 | 1 | Messages | ||
DAY 30 | 60 | 1 | EBS Foundations | Notifications |
| 60 | 1 | Defining Function activities | ||
| 60 | 1 | Event Activity | ||
| 60 | 1 | Business Event System | ||
| 120 | 2 | Sysadmin & AOL | ERP / Apps Terminology | |
DAY 31 | 210 | 3.5 | Power skills ( Behavioural ) & Language proficiency -Foundation – session 6 | # Preparing for career success (Interview skills) # Meeting etiquette # Email writing test /Grammar test Listening, questioning and probing |
| 90 | 1.5 | Sysadmin & AOL | Navigating R12 User Interface | |
| 60 | 1 | Shared Entities and Integration | ||
DAY 32 | 120 | 2 | Sysadmin & AOL | Oracle ERP Architecture |
| 90 | 1.5 | ERP Module Overview | ||
| 60 | 1 | Layers of Access Control | ||
| 60 | 1 | Self Service Approvals | ||
DAY 33 | 90 | 1.5 | Sysadmin & AOL | Function Security |
| 60 | 1 | Defining Application | ||
| 60 | 1 | Defining Data Groups | ||
| 60 | 1 | Use of Menu and Function Security to Modify Responsibilities | ||
| 90 | 1.5 | Components of Responsibilities | ||
DAY 34 | 60 | 1 | Sysadmin & AOL | Defining a New Responsibility |
| 60 | 1 | Defining new application user | ||
| 60 | 1 | Assigning responsibilities to users | ||
| 60 | 1 | Managing Function Security | ||
| 90 | 1.5 | Menu display in the navigator | ||
DAY 35 | 120 | 2 | Sysadmin & AOL | Excluding functions and menus |
| 90 | 1.5 | Setting Profile Options | ||
| 60 | 1 | Profile Hierarchy Types | ||
| 90 | 1.5 | Profile Hierarchy Levels : Security | ||
DAY 36 | 60 | 1 | Sysadmin & AOL | Profile Hierarchy Levels : Organization |
| 90 | 1.5 | Profile Hierarchy Levels : Server | ||
| 120 | 2 | Personal Profile Values | ||
| 120 | 2 | System Profile Options | ||
DAY 37 | 240 | 4 | Power skills ( Behavioural ) & Language proficiency -Foundation – session 7 | Post assessment |
| 120 | 2 | Sysadmin & AOL | Profile Categories | |
DAY 38 | 60 | 1 | Interfaces & API | Interface Types |
| 60 | 1 | Oracle Interface Strategy&Examples | ||
| 60 | 1 | Order Import Interface | ||
| 60 | 1 | Names of Standard Interface | ||
| 60 | 1 | Interface Tables In Oracle Apps | ||
| 60 | 1 | Components of Open Interface | ||
DAY 39 | 60 | 1 | Interfaces & API | Source Application |
| 60 | 1 | Destination Application | ||
| 60 | 1 | Interface Table | ||
| 120 | 2 | Identifier Columns | ||
| Control Columns | ||||
| Data Columns | ||||
| Required Columns | ||||
| Derived Columns | ||||
| Optional Columns | ||||
| 60 | 1 | Errors Table | ||
DAY 40 | 60 | 1 | Interfaces & API | Database View |
| 60 | 1 | Load Function (SQL*Loader) | ||
| 120 | 2 | Validate Function (Validating data from source application) | ||
| Process Function (Interface table to destination table) | ||||
| Maintain Function (Query, Update and re-submit interface records) | ||||
| 60 | 1 | Difference Between API and Interface | ||
| 60 | 1 | Standard APIs & How to Call APIs through plsql | ||
DAY 41 | 60 | 1 | Interfaces & API | Exception handling in APIs |
| 60 | 1 | Write extract programs | ||
| 60 | 1 | SQL*Loader scripts | ||
| 60 | 1 | Writing translation, validation and import programs | ||
| 60 | 1 | Writing verification scripts and extract format data | ||
| 60 | 1 | Create temporary interface tables adn upload data to interface tables | ||
DAY 42 | 60 | 1 | Interfaces & API | Run translation programs and Run validation programs |
| 60 | 1 | Migrate data into production tables | ||
| 60 | 1 | Run verification scripts, Run application report to verify converted data | ||
| 60 | 1 | XML BI Publisher & Oracle RDF | Creating First Report with Concurrent Program ,Data Template and Data Definition | |
| 60 | 1 | BIND AND LEXICAL | ||
| 60 | 1 | Formula column and place holder column | ||
DAY 43 | 60 | 1 | XML BI Publisher & Oracle RDF | Summary column |
| 60 | 1 | Foreach section ,split by page break | ||
| 60 | 1 | conditional statement IF | ||
| 60 | 1 | Sql and xslt functions in RTF layout | ||
| 60 | 1 | Create Multi layout | ||
| 60 | 1 | Grouping Condition & Master detail report | ||
DAY 44 | 60 | 1 | XML BI Publisher & Oracle RDF | datatemplate method before,after report triggers |
| 60 | 1 | Identify at which stage ML report Fails | ||
| 60 | 1 | Obtain OPP debug log files | ||
| 60 | 1 | Common Errors found in OPP Log | ||
| 60 | 1 | RDF Report Overview | ||
DAY 45 | 120 | 2 | XML BI Publisher & Oracle RDF | Report Types |
| 60 | 1 | Introduction of Triggers,Data Model | ||
| 60 | 1 | Steps to develop an Interface | ||
| 60 | 1 | Layout Model (Text,Frame,Repeating Frame,Field,Summary Column | ||
| 60 | 1 | [Group level, Report Level ],Formula Columns [Group level, Report Level ] | ||
DAY 46 | 60 | 1 | XML BI Publisher & Oracle RDF | Place Holder Columns ) |
| 60 | 1 | Triggers part 1 | ||
| 60 | 1 | Triggers part 2 | ||
| 60 | 1 | Simple RDF report development | ||
| 60 | 1 | Report Development with parameters and Triggers | ||
| 60 | 1 | Report Registration and execution from application | ||
DAY 47 | 60 | 1 | XML BI Publisher & Oracle RDF | Few example of day to day working environment |
| 60 | 1 | How to customize seeded and custom report | ||
| 60 | 1 | Oracle Workflow | Overview About Oracle Workflows. | |
| 60 | 1 | Familiarizing with Workflow Builder | ||
| 60 | 1 | First Sample Workflow Creation | ||
| 60 | 1 | Seeded WFSTD or Standard Workflow Itemtype and Usage | ||
DAY 48 | 60 | 1 | Oracle Workflow | Introduction to WFSTD Item type |
| 60 | 1 | Create Process,Create Functions including START and END | ||
| 60 | 1 | Create Attributes, Notifications, Messages | ||
| 60 | 1 | Deploy WF and Run from Status Monitor | ||
| 60 | 1 | Adding Action Buttons to Notification and Responding With Comments | ||
| 60 | 1 | Routing Transition Flow - Approved Rejected FYI Messages | ||
DAY 49 | 60 | 1 | Oracle Workflow | Wait,Loop, Loop, Noop, Wait, compare number, compare text, compare date, And, Or |
| 60 | 1 | Time Out Feature | ||
| 60 | 1 | Document Type | ||
| 90 | 1.5 | Lookup | ||
| 60 | 1 | Different Ways Of Triggering Workflows | ||
DAY 50 | 60 | 1 | Oracle Workflow | Calling a PL-SQL Procedure from Oracle Workflow |
| 60 | 1 | Workflow Tables and Workflow background process | ||
| 60 | 1 | Approach to change an Existing WF | ||
| 60 | 1 | Order To Cash Biz, Flow | Discuss Order To Cash Process Overview | |
| 60 | 1 | Create Sales Order, Header | ||
| 60 | 1 | Discuss on defaulting rules | ||
DAY 51 | 60 | 1 | Order To Cash Biz, Flow | Create Sales Order Line, Discuss Line types |
| 60 | 1 | Discuss workflow associated with order Line and Book the Order | ||
| 60 | 1 | Check, discuss workflow status for the order line | ||
| 60 | 1 | Shipping transaction form - Action - Launch Pick Release | ||
| 60 | 1 | Check pick release process completion | ||
| Perform Ship Confirm | ||||
| 60 | 1 | Check Interface Trip Stop - Process Delivery - Conc. Interface Trip Stop | ||
DAY 52 | 60 | 1 | Order To Cash Biz, Flow | Interface Trip Stop - Update Shipping Quantity of Order Line |
| 60 | 1 | Check order line status (shipped), workflow, status(closed) | ||
| 60 | 1 | Run Auto Invoice Concurrent Program | ||
| 60 | 1 | Query, Discuss Auto Invoice Master Program Parameters | ||
| 60 | 1 | Submit Auto Invoice Concurrent Program | ||
| 60 | 1 | Check Invoice in Receibables Module | ||
DAY 53 | 60 | 1 | Order To Cash Biz, Flow | AR Invoice, Reciept, Seed Tables |
| 60 | 1 | Interface Tables and respective Seeded Concurrent programs | ||
| 60 | 1 | APIs/TCA architecture | ||
| 60 | 1 | Procure To Pay Biz, Flow | Inventory | |
| Requistion | ||||
| Request For Quotation (RFQ) | ||||
| Quotations | ||||
| Quotation Analysis | ||||
| 60 | 1 | Purchase Order | ||
| Invoicing | ||||
| Invoice Validation | ||||
| Payment | ||||
| Transfter to GL | ||||
| GL Journals - Unposted | ||||
| GL Journals - Posted | ||||
| 60 | 1 | Navigate to PO Responsibility - Create Requisition | ||
| Query Table : PO_REQUISITION_HEADERS ALL | ||||
| Query Table : PO REQUISITION LINES ALLL | ||||
DAY 54 | 60 | 1 | Procure To Pay Biz, Flow | Approve Requisition |
| 60 | 1 | Create Purchase Order For Requisition Created | ||
| Discuss manual PO creation | ||||
| Discuss auto create PO | ||||
| Approve Purchase Order | ||||
| 60 | 1 | Query Table: PO_HEADERS_ALL for header details | ||
| Query Table: PO_LINES_ALL for PO line details | ||||
| Query Table: PO_LINE_LOCATIONS_ALL for PO shipment details | ||||
| Query Table: PO_DISTRIBUTIONS_ALL for PO distribution details | ||||
| 120 | 2 | Purchasing Responsiility - Query Purchase Order created | ||
| PO Responsibility > Receiving > Receipt | ||||
| Enter PO - Find | ||||
| Receive the goods against PO | ||||
DAY 55 | 120 | 2 | Procure To Pay Biz, Flow | Query Table: RCV_SHIPMENT_HEADERS (Receipts Header Information) |
| Query Table: RCV_SHIPMENT_LINES (Receipts Lines Information) | ||||
| Query Table: PO_HEADERS_ALL for header details | ||||
| Query Table: PO_HEADERS_ALL for header details | ||||
| Query Table: PO_HEADERS_ALL for header details | ||||
| Query Table : RCV_TRANSACTIONS (Receipt Transaction Information) | ||||
| 120 | 2 | Payables Responsibility > Invoice > Invoices | ||
| Enter details in Invoice Workbench | ||||
| Invoice Matching with PO/Receipt Number | ||||
| Validate Invoice | ||||
| Approve | ||||
| Create Accounting | ||||
| Invoice ready for Payment | ||||
| 120 | 2 | Query Table: AP_INVOICES_ALL for Invoice Header Information | ||
| Query Table: AP_INVOICE)LINES_ALL for Invoice Line Information | ||||
| Query Table: AP_INVOICE_DISTRIBUTIONS_ALL for Invoice Distribution Information | ||||
| Responsibility Payables > Payments > Payments | ||||
DAY 56 | 120 | 2 | Procure To Pay Biz, Flow | Query Table: AP_PAYMENTS_SCHEDULES_ALL for Payment Details |
| Query Table: AP_CHECKS_ALL for checks Information | ||||
| Query Table: AP_INVOICES_ALL for Invoice Header Information | ||||
| Query Table: AP_INVOICES_ALL for Invoice Header Information | ||||
| Query Table: AP_INVOICES_ALL for Invoice Header Information | ||||
| 120 | 2 | Responsibility Run Payables Transfer to GL program | ||
| Query Table: GL_JE_HEADERS for Journal Header information | ||||
| Query Table: GL_JE_LINES for Journal Lines information | ||||
| Query Table: GL_JE_BATCHES for Journal Batch information |
No comments:
Post a Comment