Custom Form Creation

what are the steps for building a screen from scratch?

A) Open up TEMPLATE.fmb, and save this as XXHELLOAPPS.fmb
B) Create a new window, by right clicking on Window/new
Name this window as XXHELLOAPPS,and assign it SubClass Type “WINDOW” from picklist.
C) Create a new canvas and name it XXHELLOAPPS , ensuring its Sublcass Type is “Content”
D) Make the windows property reference canvas XXHELLOAPPS and vice versa make the canvas reference windows XXHELLOAPPS.
E) Now create a block named XXHELLOAPPS . Lets keep this a control block for simplicity.
F) go to form level property, and set first navigation block to XXHELLOAPPS.
G) Add a label and a field named “Hello_World” to this block.
H) Generate the form on PC using Control-T keystrokes. This will ensure that nothing critical has been missed out.
I) FTP the form file to $XXPO_TOP/forms/US
Surely, this XX will be replaced by the naming convention at your client/company.
J) cd to $XXPO_TOP/forms/US
And f60gen on XXHELLOAPPS.fmb
This will create a file executable as XXHELLOAPPS.fmx
K) Go to Application Developer responsibility
Menu /applicaton/form
Register the form
L) Register the Forms Function

Now some important notes:-
1. If you have a table based block, and if that block has some description type fields, then try not to fetch them from post query trigger. Instead, develop a view in apps schema and assign that view as base tale to this block. This has a benefit that users will be able to query on the description field if need be. Indeed you will need to do dml on the actual table yourself by overriding on-insert, on-update, on-delete and on-lock triggers.
2. For each block in the screen, create a form level package spec and package body. Your triggers in the block/block fields will make calls to that package.
3. Try not to do to much pl/sql within the form. Always do such database intensive operations in a database level package.
4. Try not using global variables, unless really needed. Give preference to the creation of form package variables.
5. In a multi record block, always add a field for Current Record Indicator.


-Badma

Edit CUSTOM.pll

To convert from CUSTOM.pll to CUSTOM.pld
f60gen module_type=LIBRARY module=CUSTOM script=YES userid=apps/apps

To convert back from CUSTOM.pld to CUSTOM.pll ( after having edited the text pld file )
f60gen module_type=LIBRARY module=CUSTOM parse=YES userid=apps/apps

To convert from CUSTOM.pll to CUSTOM.plx
f60gen module_type=LIBRARY module=CUSTOM userid=apps/apps

Difference between configuration, conversion, and customization

What is the difference between configuration, conversion, and customization?
Conversion ,customization and configuration are part of an oracle implementation project they come in this order
1. configuration/set up
2. Customization
3. Conversion
Configuration is setting up customer specific requirement which generally exist in oracle apps customization is filling the gap between oracle apps and Customer requirement by developing some extension and solution design
Customization is relatively different thing, something that is not a part of oracle apps core product but the client requirement demands it we go for Customization. If the functionality demanded by the client exists in the application, it is to be configured according to his needs by taking some data, this is called configuration
Conversion is structural change of customer data in a form which is compatible with oracle database best of luck. Conversion is the process of mapping the tables from a legacy system to apps system. Sometimes conversions can be from one version to other

Patch List for Oracle Tutor Documents

hi,

pl find the details 126 Tutor patch numbers for 11i oracle applications. You can download these patches directly from metalink.

11i Tutor patch List
==============
7164129
Tutor: Patch
11i
COURSEWARE - D47542GC10 - 11I ENTERPRISE PERFORMANCE FOUNDATION INTRODUCTION
6270366
Tutor: Patch
11i
COURSEWARE - 14862GC10 - 11I IMPLEMENT AND USE PROJECT MANUFACTURING ED 1
6081408
Tutor: Patch
11i
COURSEWARE - D22054GC10 - 11I FLOW MANUFACTURING FUNDAMENTALS
6081415
Tutor: Patch
11i
COURSEWARE - D47548GC10 - 11I FINANCIAL CONSOLIDATION HUB FUNDAMENTALS ED1
5702112
Tutor: Patch
11i
COURSEWARE - D22190GC10 - 11I SOURCING FUNDAMENTALS
5702000
Tutor: Patch
11i
COURSEWARE - 14263GC20 - 11I ORACLE HRMS IMPLEMENT STANDARD BENEFITS
5702083
Tutor: Patch
11i
COURSEWARE - D17088GC30 - 11I IMPLEMENT DAILY BUSINESS INTELLIGENCE
5702033
Tutor: Patch
11i
COURSEWARE - D13559GC10 - 11I IMPLEMENTING AND USING HRMS CAREER AND SUCCESSION
5646713
Tutor: Patch
11i
COURSEWARE - D47427GC10 - YEAR END PROCESSING FOR PAYROLL US, 2006
5646737
Tutor: Patch
11i
COURSEWARE - D16446GC20 - 11I ORACLE WAREHOUSE MANAGEMENT FUNDAMENTALS ED 2
5646730
Tutor: Patch
11i
COURSEWARE - D11439GC21 - 11I FINANCIALS APPLICATIONS OVERVIEW
5646710
Tutor: Patch
11i
COURSEWARE - D45479GC10 - 11I ORACLE LEARNING MANAGEMENT FUNDAMENTALS
5646700
Tutor: Patch
11i
COURSEWARE - D22055GC20 - 11I PRODUCT LIFECYCLE MANAGEMENT FUNDAMENTALS
5646688
Tutor: Patch
11i
COURSEWARE - 14858GC20 - 11I BILLS OF MATERIAL AND ENGINEERING FUNDAMENTALS
5646680
Tutor: Patch
11i
COURSEWARE - 14813GC20 - 11I ORACLE HRMS IMPLEMENT AND USE FASTFORMULA
5402272
Tutor: Patch
11i
COURSEWARE - D17032GC10 - 11I SERVICE REQUEST FUNDAMENTALS
5402340
Tutor: Patch
11i
COURSEWARE - D17440GC10 - 11I SERVICE CONTRACTS FUNDAMENTALS
5234626
Tutor: Patch
11i
COURSEWARE - D13891GC40 - 11I ORACLE DEMAND PLANNING FUNDAMENTALS
5234642
Tutor: Patch
11i
COURSEWARE - D13939GC30 - 11I/2.6 IMPLEMENT ORACLE WORKFLOW
5234582
Tutor: Patch
11i
COURSEWARE - D11435GC30 - 11I ORDER TO CASH FUNDAMENTALS
5234655
Tutor: Patch
11i
COURSEWARE - D14149GC31 - 11I ENTERPRISE ASSET MANAGEMENT FUNDAMENTALS
5234703
Tutor: Patch
11i
COURSEWARE - D18351GC10 - 11I ADVANCED COLLECTIONS FUNDAMENTALS EDITION 1.0
5234676
Tutor: Patch
11i
COURSEWARE - D17302GC10 - 11I HEALTH AND WELFARE MANAGEMENT FUNDAMENTALS
5234664
Tutor: Patch
11i
COURSEWARE - D17212GC20 - 11I IMPLEMENT SELF-SERVICE HUMAN RESOURCES
5234682
Tutor: Patch
11i
COURSEWARE - D17327GC10 - 11I SHIPPING FUNDAMENTALS
5234693
Tutor: Patch
11i
COURSEWARE - D17399GC10 - 11I TRANSPORTATION PLANNING FUNDAMENTALS
5055937
Tutor: Patch
11i
D18972GC11 - 11I ENTERPRISE PLANNING AND BUDGETING ANALYST RESPONSIBILITY
4928584
Tutor: Patch
11i
COURSEWARE - D13003GC20 - 11I IMPLEMENT AND USE ORACLE TUTOR
4928652
Tutor: Patch
11i
COURSEWARE - D17131GC30 - 11I PROJECT RESOURCE MANAGEMENT FUNDAMENTALS, ED3
4928623
Tutor: Patch
11i
COURSEWARE - D16358GC20 - 11I IPROCUREMENT FUNDAMENTALS
4928661
Tutor: Patch
11i
COURSEWARE - D17482GC10 - 11I GRANTS ACCOUNTING FUNDAMENTALS
4928605
Tutor: Patch
11i
COURSEWARE - D14399GC20 - 11IISALES FUNDAMENTALS
4928633
Tutor: Patch
11i
COURSEWARE - D16810GC32 - 11I ORACLE PAYABLES FUNDAMENTALS ED. 3.2
4720723
Tutor: Patch
11i
COURSEWARE - J12698GC10 - 11I ORACLE PROCESS MANUFACTURING COST MANAGEMENT
4720713
Tutor: Patch
11i
COURSEWARE - D17478GC11 - 11I ORACLE LEARNING MANAGEMENT FUNDAMENTALS
4720703
Tutor: Patch
11i
COURSEWARE - 14676GC40 - 11I IMPLEMENT CONFIGURATOR
4720693
Tutor: Patch
11i
COURSEWARE - D17125GC30 - 11I PROJECT FOUNDATION FUNDAMENTALS, ED3
4720708
Tutor: Patch
11i
COURSEWARE - D17397GC10 - 11I TRANSPORTATION EXECUTION FUNDAMENTALS
4720706
Tutor: Patch
11i
COURSEWARE - D14103GC20 - 11I ASSET MANAGEMENT FUNDAMENTALS, ED. 2.0
4702515
Tutor: Patch
11i
COURSEWARE - D17129GC30 - 11I PROJECT MANAGEMENT FUNDAMENTALS, ED3
4578119
Tutor: Patch
11i
COURSEWARE -D17438GC10 - 11I TRADE MANAGEMENT: IMPLEMENTING SALES FORCE AUTOMATI
4578124
Tutor: Patch
11i
COURSEWARE - J14281GC10 - 11I ORACLE E-RECORDS ED 2
4578126
Tutor: Patch
11i
COURSEWARE - J14932GC10 - 11I ORACLE ISUPPORT
4578122
Tutor: Patch
11i
COURSEWARE - D17489GC10 - 11I COMPENSATION MANAGEMENT FUNDAMENTALS
4578123
Tutor: Patch
11i
COURSEWARE - D17501GC10 - 11I IMPLEMENT TREASURY MANAGEMENT ED 1
4578041
Tutor: Patch
11i
COURSEWARE - D13890GC30 - 11I ADVANCED SUPPLY CHAIN PLANNING FUNDAMENTALS ED 3
4578061
Tutor: Patch
11i
COURSEWARE -D16826GC10 - 11I ENTERPRISE MANAGEMENT FUNDAMENTALS: WORK STRUCTURES
4578070
Tutor: Patch
11i
COURSEWARE - D17282GC10 - 11I WORKFORCE SOURCING AND DEPLOYMENT FUNDAMENTALS
4578098
Tutor: Patch
11i
COURSEWARE - D17300GC10 - 11I HEALTH AND WELFARE MANAGEMENT FUNDAMENTALS
4578102
Tutor: Patch
11i
COURSEWARE - D17304GC10 - 11I ENTERPRISE MANAGEMENT FUNDAMENTALS: POSITIONS
4578043
Tutor: Patch
11i
COURSEWARE - D14411GC30 - 11I SYSTEM ADMINISTRATOR FUNDAMENTALS ED 3
4578064
Tutor: Patch
11i
COURSEWARE - D17226GC10 - 11I IMPLEMENT FEDERAL GENERAL LEDGER FUNDAMENTALS
4578096
Tutor: Patch
11i
COURSEWARE - D17284GC10 - 11I COMPENSATION MANAGEMENT FUNDAMENTALS
4578103
Tutor: Patch
11i
COURSEWARE - D17306GC10 - 11I COMPENSATION MANAGEMENT FUNDAMENTALS - EARNINGS
4578107
Tutor: Patch
11i
COURSEWARE - D17308GC10 - 11I COMPENSATION MANAGEMENT FUNDAMENTALS - FOUNDATIONS
4577339
Tutor: Patch
11i
COURSEWARE - 14590GC31 - 11I HRMS SYSTEM ADMINISTRATION
4577364
Tutor: Patch
11i
COURSEWARE - 14677GC40 - 11I IMPLEMENT ISTORE ED 4
4578040
Tutor: Patch
11i
COURSEWARE - D11437GC31 - 11I GENERAL LEDGER MANAGEMENT FUNDAMENTALS ED. 3.1
4578057
Tutor: Patch
11i
COURSEWARE - D16356GC20 - 11I INVENTORY MANAGEMENT FUNDAMENTALS ED 2
4578110
Tutor: Patch
11i
COURSEWARE - D17434GC10 - 11I PURCHASING FUNDAMENTALS ED 1
4578097
Tutor: Patch
11i
COURSEWARE - D17298GC10 - 11I WORKFORCE SOURCING AND DEPLOYMENT FUNDAMENTALS
4539616
Tutor: Patch
11i
COURSEWARE - D17039GC20 - 11I MARKETING FUNDAMENTALS
4539603
Tutor: Patch
11i
COURSEWARE - D12333GC20 - 11I MANUFACTURING FUNCTIONAL FOUNDATION
4539640
Tutor: Patch
11i
COURSEWARE - D17133GC20 - 11I PROJECT BILLING FUNDAMENTALS
4539582
Tutor: Patch
11i
MODEL DOCUMENTS - PAYROLL PROCEDURES FOR THE HRMS PRODUCT
4539630
Tutor: Patch
11i
COURSEWARE - D17131GC20 - 11I PROJECT RESOURCE MANAGEMENT FUNDAMENTALS
4451352
Tutor: Patch
11i
COURSEWARE - D17129GC20 - 11I PROJECT MANAGEMENT FUNDAMENTALS
4396708
Tutor: Patch
11i
COURSEWARE - D11411GC40 - 11I IMPLEMENT ORACLE STUDENT SYSTEM
4396726
Tutor: Patch
11i
COURSEWARE - D17125GC20 - 11I PROJECT FOUNDATION FUNDAMENTALS
4396745
Tutor: Patch
11i
COURSEWARE - D17278GC10 - 11I PAYROLL MANAGEMENT FUNDAMENTALS: PROCESSING PAYROLL
4396755
Tutor: Patch
11i
COURSEWARE - D17358GC10 - 11I INTRODUCTION TO CUSTOMER DATA MANAGEMENT
4396720
Tutor: Patch
11i
COURSEWARE - 11449GC20 - 11I IMPLEMENT AND USE ORACLE INTERNET EXPENSES
4291289
Tutor: Patch
11i
COURSEWARE - D17077GC11 - 11I TIME & LABOR MANAGEMENT FUNDAMENTALS
4141073
Tutor: Patch
11i
COURSEWARE - 14468GC20 - 11I NAVIGATE ORACLE APPLICATIONS ED 2
4141031
Tutor: Patch
11i
COURSEWARE - D17037GC20 - 11I ADVANCED PRICING FUNDAMENTALS
4141004
Tutor: Patch
11i
COURSEWARE - D17127GC20 - 11I PROJECT COSTING FUNDAMENTALS
4098729
Tutor: Patch
11i
COURSEWARE - D17102GC10 - 11I DEPOT REPAIR FUNDAMENTALS
4098731
Tutor: Patch
11i
COURSEWARE - D17104GC10 - 11I FIELD SERVICE FUNDAMENTALS
4098732
Tutor: Patch
11i
COURSEWARE - D17240GC20 - 11I IMPLEMENT AND USE LEASE MANAGEMENT
4098726
Tutor: Patch
11i
COURSEWARE - D13762GC30 - 11I EBUSINESS SUITE ESSENTIALS FOR IMPLEMENTERS, ED 3
4007585
Tutor: Patch
11i
COURSEWARE - 14850GC40 - 11I IMPLEMENT ADVANCED INBOUND
3554732
Tutor: Patch
11i
MODEL DOCUMENTS - GENERIC (NON-EBS SPECIFIC) VERSION OF TUTOR PROCESS DOCUMENTS
3541611
Tutor: Patch
11i
MODEL DOCUMENTS - ORACLE PROCESS MANUFACTURING DOCUMENTS
3961385
Tutor: Patch
11i
COURSEWARE - D11431GC20 - 11I FINANCIALS FUNCTIONAL FOUNDATION
3961365
Tutor: Patch
11i
COURSEWARE - 14854GC40 - 11I IMPLEMENT SCRIPTING
3920821
Tutor: Patch
11i
COURSEWARE - D16918GC10 - 11I ORACLE PROCESS MANUFACTURING PROCESS EXECUTION
3920810
Tutor: Patch
11i
COURSEWARE - D16916EC10 - 11I ORACLE PROCESS MANUFACTURING QUALITY MANAGEMENT
3920831
Tutor: Patch
11i
COURSEWARE - D16919GC10 - 11I ORACLE PROCESS MANUFACTURING PRODUCT DEVELOPMENT
3920088
Tutor: Patch
11i
COURSEWARE - D13939GC20 - 11I/2.6 IMPLEMENT ORACLE WORKFLOW
3879081
Tutor: Patch
11i
COURSEWARE - D16818GC10 - 11I WORKFORCE SOURCING AND DEPLOYMENT FUNDAMENTALS
3554847
Tutor: Patch
11i
MODEL DOCUMENTS - ORACLE EBUSINESS SUITE SPECIFIC VERSION OF PROCESS DOCUMENTS
3554869
Tutor: Patch
11i
MODEL DOCUMENTS - INFORMATION TECHNOLOGY PROCEDURES
3198357
Tutor: Patch
11i
COURSEWARE - ENGLISH LANGUAGE VERSION
1935555
Tutor: Patch
11i
MODEL DOCUMENTS - PROCEDURES TRANSLATED INTO BRAZILIAN PORTUGUESE
2167559
Tutor: Patch
11i
MODEL DOCUMENTS - INV AND OM PROCEDURES TRANSLATED TO GERMAN
1871159
Tutor: Patch
11i
MODEL DOCUMENTS - 154 TUTOR PROCEDURES TRANSLATED INTO FRENCH
1933235
Tutor: Patch
11i
MODEL DOCUMENTS - TUTOR PROCEDURES TRANSLATED TO ITALIAN (AP, AR, GL, HR, PO)
1903325
Tutor: Patch
11i
COURSEWARE - PROCUREMENT
1903410
Tutor: Patch
11i
COURSEWARE - ORACLE PROCESS MANUFACTURING
1845010
Tutor: Patch
11i
MODEL DOCUMENTS - TUTOR MFG AND HRMS PROCEDURES TRANSLATED TO DUTCH
1865658
Tutor: Patch
11i
COURSEWARE - MANUFACTURING
1742061
Tutor: Patch
11i
COURSEWARE - CRM
1711199
Tutor: Patch
11i
MODEL DOCUMENTS - FINANCE PROCEDURES TRANSLATED INTO LATIN AMERICAN SPANISH
1747530
Tutor: Patch
11i
MODEL DOCUMENTS - FINANCIAL PROCEDURES TRANSLATED TO BRAZILIAN PORTUGUESE
1770527
Tutor: Patch
11i
COURSEWARE - CRM EDU1572Y THROUGH EDU1686Y
1712619
Tutor: Patch
11i
MODEL DOCUMENTS - FINANCE PROCEDURES TRANSLATED INTO GERMAN
1803237
Tutor: Patch
11i
MODEL DOCUMENTS - PURCHASING PROCEDURES WERE TRANSLATED INTO GERMAN
1852725
Tutor: Patch
11i
COURSEWARE - FIN-PROJECT ACCOUNTING
3327497
Tutor: Patch
11i
COURSEWARE - 13357GC20 - 11i USE AND IMPLEMENT QUOTING ED 2
3323427
Tutor: Patch
11i
COURSEWARE - USING ORACLE PURCHASING FOR PROCESS INVENTORY
3327520
Tutor: Patch
11i
COURSEWARE - D11433GC20 - 11i PROCURE TO PAY FUNDAMENTALS
3323434
Tutor: Patch
11i
COURSEWARE - D16968GC10 - 11i IMPLEMENT INTERNAL CONTROLS MANAGER
2955476
Tutor: Patch
11i
COURSEWARE - MFG-MRP
2843111
Tutor: Patch
11i
COURSEWARE - OLN FILES ORACLE APPLICATIONS END USERS
2829251
Tutor: Patch
11i
MODEL DOCUMENTS - 209 TUTOR PROCEDURES ARE TRANSLATED TO TRADITIONAL CHINESE
2745486
Tutor: Patch
11i
MODEL DOCUMENTS - 172 PROCEDURES TRANSLATED TO SIMPLIFIED CHINESE
2674456
Tutor: Patch
11i
COURSEWARE - MFG
2377217
Tutor: Patch
11i
COURSEWARE - INV & PO TRANSLATED TO FRENCH CANADIAN
2323685
Tutor: Patch
11i
COURSEWARE - OM TRANSLATED TO FRENCH CANADIAN
2323093
Tutor: Patch
11i
MODEL DOCUMENTS - FINANCE PROCEDURES RE-RELEASED IN DUTCH
2323985
Tutor: Patch
11i
MODEL DOCUMENTS - 202 PROCEDURES TRANSLATED INTO DANISH
2323987
Tutor: Patch
11i
COURSEWARE - 153 FILES TRANSLATED INTO DANISH
2227153
Tutor: Patch
11i
COURSEWARE - 63 COURSEWARE FILES TRANSLATED INTO FRENCH CANADIAN
2181155
Tutor: Patch
11i
MODEL DOCUMENTS - 150 PROCEDURES TRANSLATED TO FRENCH CANADIAN
2181168
Tutor: Patch
11i
MODEL DOCUMENTS - 111 PROCEDURES TRANSLATED TO BRAZILIAN PORTUGUESE
2181173
Tutor: Patch
11i
MODEL DOCUMENTS - 111 PROCEDURES WERE TRANSLATED TO SPANISH

Good luck

Happy reading
-Badma

Oracle Apps Evolution - History

Apps History

Oracle apps Financials

Interested in sharing new things and like to invite you all people to update your valuable reply and new post.

- Badma