1ERP - ORACLE APPLICATIONS Pre-requ isites to learn Oracle Applications Oracle 9i SQL - Reference books • DDL Commands • DML Commands • TCL Commands • Quarries, Sub Quarries • Operators PL/SQL - Reference books – by author Scott Urman • Cursors • Trigger • Packages, Procedure, Functions Forms 6i - Reference books – by Evan Baris • Canvases – types – functionality • Property Classes • Visual attributes • Programe Units • Record Group • Triggers – Sequences • Form functions – like call form Reports 6i • Variables – like Bind, Lexical • Columns - like Summery, Placeholder, Formula • Report Triggers – 6 types and sequence • Format Triggers and Validate triggers • Layout objects o Frame o Repeat frame o Anchor o Boilerplate 2Oracle Applications 11i - Introduction ERPs available in market • SAP • Oracle Applications o People soft o Siebel o JD Edwards Oracle Applications are used to capture Business functionality information of the organization. • Instances o Development - Development Development stage 1 Development stage 2 o Testing - Testing o Production – Client testing Involved personalities of Oracle Applications and their roles and responsibilities in brief 1) DBA – Database Administrator a. Installation of Oracle Applications b. Applying patches c. Maintaining Multiple Instances 2) Functional Consultant a. Interaction with the client b. Gathering the requirements for development / customization c. About oracle applications what available and what wasn’t available. d. Example invoice form – fields - Or develop a invoice form from scratch e. Preparation of FDD (Functional Design Document) 3) Technical Consultant – Input FDD a. Go through the FDD b. Prepare...
