Course Contents:Day1 R12 EssentialsNavigating in R12 Oracle ApplicationsLogon and off of Oracle ApplicationsUsing forms & menusEntering data using formsSearching formsIntroduction to R12 Oracle ApplicationsR-12 E-Business Suite OverviewUnderstanding the R-12 ArchitectureShared Entities and IntegrationShared entities and Non-key shared entitiesSuppliers and CustomersOverview of E-Business Suite business flows and IntegrationFundamentals of System AdministrationApplication Security OverviewFunction SecurityData SecurityProfile OptionsStandard request submission (SRS)Fundamentals of FlexfieldsBasics of FlexfieldsDefine Value setsDefine Key FlexfieldsDefine Descriptive FlexfieldsFundamentals of Multiple-OrganizationWhat Is Multi-Org?Types of organizations supported in the Multi-Org modelMultiple-Organization Access Control Setup and ProcessReporting across entitiesFundamentals of Oracle Work-flow & AlertsOverview of Work-flowOracle Work-flow Home PagesWork-flow Monitor WebPagesOverview of Alerts

Day 2 Overview of Oracle InventoryDescribe overall inventory from receipt to issueDescribe the key integration points between Oracle Inventory and other Oracle ApplicationsInventory StructureDescribe Inventory OrganizationDescribe the structure of an Inventory OrganizationDescribe the multi-organization structure in Oracle ApplicationsSet up Inventory parameters, sub inventories, and locatorsSet up the organization profile optionsUnits of MeasureDefine units of measureUse units of measure reportsUse units of measure setup optionsDefining and Maintaining ItemsDefine, setup and maintain items,Use item templatesUse item control levelsUse item categories and catalogsImplement item profile optionsLot and Serial ControlDescribe lotsDescribe parent and child lotsDescribe shelf life and lot actionsDescribe grade controlDescribe serial controlDescribe lot and serial genealogyImplement the lot and serial profile options

Day 3Inventory contunuationTransaction Setup

Describe transactions and move ordersDefine transaction managers, transaction types, and transaction reasonsDefine inventory picking rulesDefine inventory account aliasesSet up move ordersDescribe Period Close Process within InventoryIssuing and Transferring MaterialPerform TransactionsManage ReceiptsPerform Move OrdersOn-hand and AvailabilityExplain availabilityView on-hand quantitiesDescribe the uses of the material workbenchCreate ATP rules, time fences and supply/demand sourcesManage ReservationMaterial Status ControlExplain material statusSet up material status propertiesDescribe key material status implementation considerationsInventory ReplenishmentExplain reorder-point planningPerform min-max planningPerform replenishment countingInventory AccuracyCreate an ABC compileDefine and maintain a cycle countDefine a physical inventoryDemonstrate count adjustments and approvals

Day 4Order managementOverview of Oracle Order ManagementDescribe Oracle Order Management and its main componentsExplain the capabilities of Oracle Order ManagementIdentify the other products that Oracle Order Management integrates withOrder Entities and Order FlowsManage QuotesManage Order to Cash Lifecycle with Standard ItemsManage Order to Cash Lifecycle with PTO, and ATO ItemsManage Drop ShipmentsManage Back-to-Back OrdersManage Sales AgreementsManage Order to Cash Lifecycle with Customer AcceptanceMultiple Organization Access Control SetupExplain the necessity for multiple organization access control (MOAC)Identify the Order Management windows (setup and transaction) that use the Operating Unit field and 12i specific MOAC additional featuresPerform the various setups involved in implementing MOACOracle Inventory Setup for Oracle Order ManagementExplain the structure of an inventory organizationDefine subinventoriesUse units of measureUse the item master organizationDefine itemsOracle Receivables Setup for Oracle Order ManagementDefine TCA ConceptsDefine Customer Information and Payment TermsDefine Invoicing, Accounting Rules and Deferred RevenueExplain Customer Acceptance and Billing SetupsDefining Invoicing Sources (Batch Source)Explain Online Transaction Security and Tax-Related Setup StepsDefine Credit CheckingOracle Order Management Setup StepsView and Update Profile OptionsCreate QuickCodes or LookupsManage Document SequencingDefine Transaction TypesExplain Order Header and line Workflows in Transaction TypesSet up Processing Constraints

Define Validation TemplatesDefine Defaulting ConditionsDefine Defaulting RulesSet up Versioning and Audit HistorySetup Available to PromiseDefine SchedulingCreate Credit Check RulesHolds, Order Purge, and Exception Management SetupCreate,Apply and Release Holds - Seeded, Generic 

Day 5Basic Pricing SetupDescribe Pricing Process and Basic Pricing ConceptsMaintain Price ListsDefine Pricing SecurityUse Qualifiers with various Types of ModifiersApply Freight and Special Charges ModifierOverview of Shipping ExecutionExplain the Oracle Order Management to Oracle Shipping Execution FlowDescribe Shipping EntitiesIdentify User Interfaces in Oracle Shipping ExecutionIdentify Key Reports and ProcessesShipping Execution SetupDefine Roles and UsersShipping Execution DocumentsManage Shipping ExceptionsDefine Pick Release RulesDefine Ship Confirm RulesContainers/LPNs 

Day 6 PurchasingProcure To Pay Lifecycle OverviewUnderstanding Procure to Pay LifecycleUnderstanding Oracle Procure to Pay ProcessOracle Purchasing OverviewUnderstanding Purchasing ProcessRequisition to Purchase OrderOverview of the Ordering ProcessThe Receiving ProcessPurchasing IntegrationEnterprise Structure – Locations, Organizations, and ItemsUnderstanding the Enterprise StructureDefining LocationsDefining Inventory OrganizationsEstablishing Inventory ParametersCreating Units of MeasureCreating a Purchasing CategoryItem Attributes Defining and Maintaining ItemsDescribing and Using Category SetsSuppliersOverview of SuppliersEntering Supplier InformationDefining Supplier Site InformationManaging SuppliersRunning Supplier ReportsUnderstanding Financial OptionsDefining Supplier Profile OptionsApproved Supplier Lists and Sourcing RulesCreating Approved Supplier ListsUnderstanding Supplier StatusesUnderstanding ASL PrecedenceDefining Sourcing Profile Options for ApprovalsRequisitionsUnderstanding the Requisition LifecycleNotificationsRequisition StructureCreating and Maintaining RequisitionsCreating Requisition TemplatesRunning Requisition Reports

Defining Requisition Profile Options

Day 7 Continuation of POPurchase OrdersUnderstanding Purchase Order TypesPurchase Order Components and Record StructureCreating Standard Purchase OrdersCreating Contract Purchase AgreementsRevising Purchase OrdersMaintaining Purchase OrdersIdentifying Key ReportsCreating Global AgreementsAutomatic Document CreationUnderstanding AutoCreateCreating Purchase Documents from RequisitionsModifying Requisition LinesRunning the Create Releases ProgramUnderstanding the PO Create Documents workflowReceivingReceiving LocationsReceipt RoutingReceipt Processing MethodsReceiving TolerancesEntering Returns and CorrectionsOverview of Pay on ReceiptRunning ReportsDefining Profile OptionsDocument Security, Routing and ApprovalDocument Security and Access LevelsDocument Approval - Jobs and PositionsCreating Position Approval HierarchiesDefining Document Security LevelsCreating Approval GroupsDefining Document Access LevelsUsing Oracle Workflow for Requisitions and Purchase Order ApprovalsRunning the Fill Employee Hierarchy ProcessPurchasing AccountingOverview of Purchasing AccountingClosing the PO PeriodUsing foreign currencyPurchasing Accounting Implementation ConsiderationsSetup options  Week 1-2Identity Confirmation• Activate your computer• Setting Up the User Interface• Set up the UI & search options• Organization Administration• Set your organization’s language & locale • Manage currency• Customization• Create custom profiles & custom fields• Define dependent picklists• Customize lookup fields & formula fields• Customize page layouts• Customize standard related lists• Learn about record types & business processes• Use field-level security• Security & Access• Create & manage your users• Set organization-wide defaults• Learn about record access• Create the role hierarchy

• Learn about the sharing model• Manually share records• Set up opportunity team selling & account teams • Learn about folder accessWeek 2• Workflow• Define workflow• Set up workflow rules• Set up workflow tasks & alerts• Workflow Approvals• Plan approvals using workflow• Use the approval wizard – standard vs. jump-start • Create workflow approvals• Data Validation• Learn about Salesforce CRM data validation• Create data validation rules• Learn about custom fields & unique properties Data Utilities• Import records using the import wizards• Use mass delete• Use mass transfer• Learn about storage utilizationWeek 3• Analytics• Create custom reports• Use advanced filters• Use conditional highlighting• Use custom summary formulas• Create dashboards• The AppExchange• Learn about the AppExchange• Install an app• Uninstall an app• Marketing Administration• Use the integrated campaign builder• Learn about lead queue & lead assignment setup • Learn Web-to-lead & auto-response rules• Service & Support Administration• Learn about cases & solutions• Set up case escalation rules• Identify solution categories & suggested solutions Salesforce Console• Navigate the Salesforce Console• Create a Salesforce Console• Extending Salesforce CRM• Learn about custom objects• Learn about custom tabs• Learn about custom Web tabs• Build a custom app Week 4TRACK II :Designing Applications on Force.com•  Learn about factors to consider when building a data model•  Develop custom objects and fields, encrypted fields, field help, and field history tracking•  Use master detail, lookup, and many-to-many relationships•  Create a user interface for custom applications using the Custom Object tab, Page Layout, and•  Customization options•  Set field attributes on the page layout•  Use the Custom Object queue and event-based workflow rules with field update actions•  Develop custom formulas and validation rules 

•  Designing Applications for Multiple Users•  Learn about factors to consider when designing applications for multiple users•  Create profiles, understand what a profile controls (including data access), and customize profiles to manage the user experience•  Customize the user experience with record types and page layouts•  Control access to records

Week 5•  Employ OWD, sharing rules and levels, roles, public groups, and manual share•  Apply profiles, OWDs, role hierarchy, and sharing to restrict access to sensitive data•  Apply OWDs, public groups, and manual sharing to create conditional access to data•  Analyze suitability of FLS, page layouts, and record types to satisfy business requirements •  Implementing Business Processes •  Use the vlookup, regex, ischanged, isnew, and priorvalue functions to build business processes•  Use validation rules to enforce conditional required behavior•  Use functions to enforce data format and data consistency•  Implement multistep approval workflows and escalations to automate business processes•  Create parallel approval workflows and workflow approvals with dynamic approval routing•  Use outbound messages as part of an approval workflow•  Establish approval workflow criteria with crossobject formulas•  Set up field history tracking to audit processes•  Learn techniques to prevent or record data changes 

Week 6-7Managing Data •  Learn when and how to use upsert•  Use data management tools and the capabilities of API-based tools•  Configure the Data Loader via command line•  Encrypt passwords using encrypt.bat•  Use the Data Loader to create mapping files and to upsert data  Visualforce Pages •  Learn about the capabilities of the Visualforce framework •  Incorporate Visualforce pages into Salesforce Construct expression bindings and incorporate •  Salesforce into Visualforce pages with Visualforce tags•  Use Visualforce tags to create page layouts,input forms, output tables, custom components; •  Create partial page refreshes on JavaScript events•  Learn about the functionality that comes with Visualforce standard controllers •  Find out when Apex is required for creating custom controllers or extensions