Oracle Apps developer responsibilities - Download

A normal routine for an oracle apps developer is to understand the customer requirements, develop the code, perform testing and move the tested codes to different application/ database instances. There are some technical aspects involved in this process that every developer should know. Here is a document which covers all such topics in details.


Following topics are covered in the download:

  • FORMS IN APPS
  • Steps to build a form using TEMPLATE
  • Steps to register a custom form in APPS
  • Standard Program Unit in TEMPLATE
  • Standard Libraries in TEMPLATE
  • Overview of Query Find
  • Flex Fields
  • How to invoke a calendar in a form
  • Coding Handlers
  • How to open a form from another form
  • Custom reusable codes
  • REPORTS IN APPS
  • REQUEST SETS
  • CONCURRENT PROCESSING APIS FOR PL/SQL PROCEDURES
  • FND_REQUEST Package
  • FND_CONCURRENT Package
  • FND_FILE Package
  • VALUE SETS
  • Value set and Validation Types
  • Usage of $FLEX$
  • USER PROFILES
  • Overview of User Profiles
  • Predefined User Profile options
  • User Profile APIs
  • User Profile  C functions
  • TABLE REGISTRATION
  • RESPONSIBILITY
  • Security implementation using Responsibility
  • REQUEST GROUP
  • Defining a Request Group
  • Types of Request Group
  • Request Security Groups
  • Request Groups and Request Sets
  • DATA GROUPS
  • Introduction to Data Groups
  • Data Group's Purpose
  • Remarks on Data Group's structure
  • CONCURRENT PROCESSING
  • Overview of Concurrent Processing
  • Life Cycle of a Concurrent Request
  • Define Concurrent Managers
  • Types of Concurrent Managers
  • TUNING SQL
  • Rule Based Optimization (RBO)Features
  • Cost Based Optimization (CBO)
  • Oracle Hints
  • More about Index
  • High Watermarks
  • SQL Trace
  • TKProf