A New Custom Form in Oracle Apps 11i

Illustrated below solution has described by using the  MS windows environment

1. Make sure the installation for form developer environment 6i e.g [roote]\orant\BIN  (C:\orant\BIN\ifbld60.EXE)
2. Copy all the resouce files from AU_TOP (application User TOP) by FTP from ERP installed environment e.g /d01/oracle/prodappl/au/11.5.0/resource to C:\orant\BIN
3. Copy source template file named (TEMPLATE.fmb, APPSTAND.fmb) by FTP from /d01/oracle/prodappl/au/11.5.0/forms/US into C:\orant\BIN
4. open MS Window registry by command REGEDIT, find FORMS60_PATH variable under the path HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE and add the ;C:\orant\BIN at the end of an existing string
5.  Run oracle form builder 6i & open file C:\orant\BIN\TEMPLATE.fmb for customization

Custom Form Compilation

How to compile custom Form

Form Registration into Oracle ERP

Supporting Document Link

 1. Do listed below necessary steps to show form into application menu

• Open Application Developer (Respons.) -->Application --> Forms
• Define Function for this form Application Developer (Respons.) -->Application --> Function
• In the end attached with in the menu you want to access screen. 

Useful web link

• ORACLE APPS QUICK REFERENCE
• Custom Form Registration

Find Oracle ERP object name

SELECT NAME, TYPE, REFERENCED_NAME, REFERENCED_TYPE
  FROM USER_DEPENDENCIES
 WHERE NAME = UPPER('ap_invoices')
 --WHERE NAME LIKE UPPER('%AP_INVOICE%')
 AND (TYPE = 'VIEW' OR REFERENCED_TYPE = 'TABLE')

Script to Kill Database Session in oracle

select a.object_id,a.session_id,b.object_name               

from v$locked_object a,dba_objects b                 
where a.object_id = b.object_id;               

               

select sid,serial# from v$session where sid = 99;               

               

alter system kill session '33,9';            

select 'alter system kill session ''' || sid ||','|| serial# ||''''

from v$session where sid in (99)

select 'alter system kill session ''' || sid ||','|| serial# ||''''

from v$session where sid in (99)