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
- FND_REQUEST Package
- FND_CONCURRENT Package
- FND_
- VALUE SETS
- Value set and Validation Types
- Usage of $
- 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
- 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
