Query to find Oracle EBS Application Short Name of a module

/* Find out Oracle EBS application short name with id */

SELECT FA.APPLICATION_ID           "Application ID",
       FAT.APPLICATION_NAME        "Application Name",
       FA.APPLICATION_SHORT_NAME   "Application Short Name",
       FA.BASEPATH                 "Basepath"

  FROM FND_APPLICATION     FA,
       FND_APPLICATION_TL  FAT

 WHERE FA.APPLICATION_ID = FAT.APPLICATION_ID
   AND FAT.LANGUAGE      = USERENV('LANG')
    AND UPPER(FAT.APPLICATION_NAME) LIKE '%PURCH%'  -- <change it>
 ORDER BY FAT.APPLICATION_NAME;

Query to find GL Flexfield security rule assignments to responsibilities

SELECT GLLG.LEDGER_ID,GLLG.NAME, GLLG.LEDGER_CATEGORY_CODE ,

      FLX.APPLICATION_ID, FLX.ID_FLEX_CODE, FLX.ID_FLEX_NAME ,
       STR_TL.ID_FLEX_NUM, STR.ID_FLEX_STRUCTURE_CODE, STR_TL.ID_FLEX_STRUCTURE_NAME ,STR_TL.DESCRIPTION ,
       SEG.SEGMENT_NAME,SEG.SEGMENT_NUM,SEG.APPLICATION_COLUMN_NAME,SEG.ENABLED_FLAG,SEG.SECURITY_ENABLED_FLAG--,SEG.FLEX_VALUE_SET_ID

      ,FLX_RULES.*


FROM FND_ID_FLEXS FLX
    ,FND_ID_FLEX_STRUCTURES_TL STR_TL
    ,FND_ID_FLEX_STRUCTURES STR
    ,FND_ID_FLEX_SEGMENTS SEG
    ,GL_LEDGERS GLLG
 
 ,(SELECT    APS.APPLICATION_NAME          ,
             APS.APPLICATION_ID            ,
             FVR.FLEX_VALUE_RULE_NAME    ,
             RSP.RESPONSIBILITY_ID         RESPONSIBILITY_ID,
             RSP.RESPONSIBILITY_KEY        RESPONSIBILITY,
             FVR.FLEX_VALUE_SET_ID , VS.FLEX_VALUE_SET_NAME, VS.DESCRIPTION FLEX_VALUE_SET_DESC,
             DECODE(FVRL.INCLUDE_EXCLUDE_INDICATOR,'E','EXCLUDE','I','INCLUDE') INC_EXC,
             FVRL.FLEX_VALUE_LOW, FVRL.FLEX_VALUE_HIGH,            
             USR.USER_ID, USR.USER_NAME, USR_GRP.START_DATE, USR_GRP.END_DATE            
           

        FROM FND_FLEX_VALUE_RULES        FVR,
             FND_FLEX_VALUE_RULE_USAGES  RU,
             FND_FLEX_VALUE_RULE_LINES FVRL,
             FND_RESPONSIBILITY          RSP,
             FND_APPLICATION_TL          APS,
             FND_FLEX_VALUE_SETS         VS,
             APPS.FND_USER_RESP_GROUPS USR_GRP,
             APPS.FND_USER USR
           
           
       WHERE  1=1
       AND FVR.FLEX_VALUE_RULE_ID = RU.FLEX_VALUE_RULE_ID
       AND FVR.FLEX_VALUE_RULE_ID = FVRL.FLEX_VALUE_RULE_ID
       AND FVR.FLEX_VALUE_SET_ID = FVRL.FLEX_VALUE_SET_ID    
         AND RU.RESPONSIBILITY_ID   = RSP.RESPONSIBILITY_ID
         AND RU.APPLICATION_ID      = APS.APPLICATION_ID
         AND FVR.FLEX_VALUE_SET_ID = VS.FLEX_VALUE_SET_ID
       
         AND RSP.RESPONSIBILITY_ID = USR_GRP.RESPONSIBILITY_ID
         AND USR_GRP.USER_ID = USR.USER_ID
     
    )FLX_RULES
 

WHERE 1=1

AND STR.APPLICATION_ID = STR_TL.APPLICATION_ID
and STR.ID_FLEX_CODE = STR_TL.ID_FLEX_CODE
and STR.ID_FLEX_NUM = STR_TL.ID_FLEX_NUM

AND FLX.APPLICATION_ID = STR_TL.APPLICATION_ID
AND FLX.ID_FLEX_CODE = STR_TL.ID_FLEX_CODE
AND STR_TL.LANGUAGE = USERENV('LANG')

AND STR_TL.APPLICATION_ID = SEG.APPLICATION_ID
AND STR_TL.ID_FLEX_CODE = SEG.ID_FLEX_CODE
AND STR_TL.ID_FLEX_NUM = SEG.ID_FLEX_NUM
AND STR_TL.ID_FLEX_NUM = GLLG.CHART_OF_ACCOUNTS_ID


AND FLX_RULES.FLEX_VALUE_SET_ID(+) = SEG.FLEX_VALUE_SET_ID


--AND FLX.ID_FLEX_NAME = 'System Items'
--AND STR_TL.ID_FLEX_STRUCTURE_NAME  = 'System Items'
AND STR.ID_FLEX_STRUCTURE_CODE = 'SYSTEM_ITEMS'
--AND  GLLG.LEDGER_ID = 1078 --SET OF BOOK

Copy APPS user / Create Read Only eBS databse user

-- Connect to APPS Database Schema

CREATE USER APPS_RO IDENTIFIED BY APPS_RO;
GRANT CONNECT, RESOURCE TO APPS_RO;


      ------------------ Synonyms List ------------------------
      /* Generate script for synonyms for new schema
      */

    SELECT   'CREATE OR REPLACE SYNONYM APPS_RO.'||DS.synonym_name|| '  FOR  '|| DS.table_owner||'.'||DS.table_name||';' script
    FROM dba_synonyms DS
    WHERE owner = 'APPS';


      ------------------ Tables List ------------------------

      /* Generate script for tables synonym for new schema
      */


    SELECT   'CREATE OR REPLACE SYNONYM APPS_RO.'||DS.TABLE_NAME|| '  FOR  '|| DS.OWNER||'.'||DS.table_name||';' script
    FROM dba_tables DS
    WHERE owner = 'APPS'
    ;


      ------------------ View List ------------------------

      /* Generate script for view synonym for new schema
      */


      SELECT   'CREATE OR REPLACE SYNONYM APPS_RO.'||DS.VIEW_NAME|| '  FOR  '|| DS.OWNER||'.'||DS.VIEW_name||';' script
      FROM dba_views DS
      WHERE owner = 'APPS';


------------------------------------ Grant SELECT(table,views) / EXECUTION(pkg,procudure,function) to Synonyms----------------------------------------

-- Connect to APPS Schema to assign rights


DECLARE
  LV_SCRIPT VARCHAR(500);
  LV_SCRIPT_PRO VARCHAR(500);
  LV_COUNTER NUMBER := 0;
  --IS_PKG_PRO_FUN_OBJ exception;
   -- pragma EXCEPTION_INIT(IS_PKG_PRO_FUN_OBJ, '-980');
 
BEGIN
 
            FOR CUR IN (
                    SELECT  'GRANT SELECT ON '||DS.synonym_name||' TO APPS_RO' SCRIPT,
                            'GRANT EXECUTE ON '||DS.synonym_name||' TO APPS_RO' SCRIPT_PRO ,
                    DS.*
                    FROM dba_synonyms DS
                    WHERE owner = 'APPS_RO'
                   -- and DS.synonym_name IN ('ACK','AP_INVOICE_DISTRIBUTIONS_ALL')
                   
             ) LOOP
           

             
                       LV_SCRIPT := CUR.SCRIPT;
                       LV_SCRIPT_PRO := CUR.SCRIPT_PRO;
                     

                       BEGIN
                       
                          EXECUTE IMMEDIATE(LV_SCRIPT);

                       
                        EXCEPTION WHEN OTHERS THEN
                         
                           BEGIN
                                 
                                EXECUTE IMMEDIATE(LV_SCRIPT_PRO);

                             EXCEPTION WHEN OTHERS THEN

                                  dbms_output.put_line(LV_SCRIPT);
                                  dbms_output.put_line(LV_SCRIPT_PRO);
                                  dbms_output.put_line('**Internal Exception ******');

                             END;
                       
                         
                       END;

             END LOOP;
           
              dbms_output.put_line('PROCESS COMPLETED');

EXCEPTION WHEN OTHERS THEN
 
       dbms_output.put_line('------------------Main Exception------------------------');

       dbms_output.put_line(LV_SCRIPT_PRO);
       dbms_output.put_line(LV_SCRIPT);

        dbms_output.put_line(SQLERRM||'~'||SQLCODE);


END;



------------------------------------------
-- Connect to APPS and execute for ('FUNCTION','PACKAGE','PROCEDURE')


BEGIN
   

    FOR CUR IN ( SELECT  'CREATE OR REPLACE SYNONYM APPS_RO.'||DP.object_name|| '  FOR  APPS.'|| DP.object_name CREATE_SYNONYME
                      ,'GRANT EXECUTE ON '||DP.object_name||' TO APPS_RO' GRANT_OBJECT
                     

              FROM DBA_PROCEDURES DP
              WHERE  1 = 1
              AND DP.OWNER = 'APPS'
              AND DP.object_type IN ('FUNCTION','PACKAGE','PROCEDURE')
              --AND DP.object_name IN('AP_INVOICES_PKG','AP_CHECKS_PKG')
              GROUP BY DP.object_name
              )
     LOOP
     
             
              EXECUTE IMMEDIATE (CUR.CREATE_SYNONYME);
              EXECUTE IMMEDIATE (CUR.GRANT_OBJECT);
         
     END LOOP;

               DBMS_OUTPUT.PUT_LINE('Process Completed !')  ;

EXCEPTION WHEN OTHERS THEN
          DBMS_OUTPUT.PUT_LINE(SQLERRM)  ;

 
END;
 

Conversion of Historical Data for Reporting Currencies and Secondary Ledgers

Conversion of Historical Data for Reporting Currencies and Secondary Ledgers

When defining a new subledger reporting currency or secondary ledger for an active primary ledger, you can use the SLA Secondary/ALC Ledger Historic Upgrade program to initialize journals.

You can determine the period from which to create ledger balances by selecting the first period for conversion. The journals are created from the selected period onwards. The first period of historic conversion should be the earliest period for which you have open transactions.

When a subledger level secondary or reporting ledger is added to an existing primary ledger, the accounting in the secondary or reporting ledger fails in the following scenarios:

• When a final accounted transaction is reversed: A Payables invoice is created and final accounted in the primary ledger. Then, a new subledger level secondary or reporting ledger is added to this primary ledger. The same invoice is cancelled. When the Create Accounting program is run, accounting for the invoice cancellation fails for the secondary or reporting ledger, as the accounting program does not find the corresponding Invoice accounting entry to generate the transaction reversal entry (Invoice cancellation accounting) for the secondary or reporting ledger.
• When a Payment accounting entry needs to be created using business flows: A Payables invoice is created and final accounted in the primary ledger. Then, a new subledger level secondary or reporting ledger is added to this primary ledger. A payment is generated against the same invoice. When the Create Accounting program is run, accounting for this payment fails for the secondary or reporting ledger, as the accounting program cannot find the corresponding upstream entry (Invoice accounting) to generate the downstream entry (Payment accounting) for the secondary or reporting ledger.

A new subledger level secondary/reporting ledger should not be added to an existing primary ledger that already has final accounted subledger journal entries.

Running the SLA Secondary/ALC Ledger Historic Upgrade Program

Use this procedure to run the SLA Secondary/ALC Ledger Historic Upgrade program.

Prerequisites:

Create initial balances for new ledgers:

Note: The SLA Secondary/ALC Ledger Historic Upgrade program creates journals in Oracle Subledger Accounting. These journals are created with a posting status of Posted and are never actually posted to Oracle General Ledger. To maintain historic balances in Oracle General Ledger, you must initialize balances for the new reporting currency ledger or secondary ledger.

To create initial balances for a:

• Reporting Currency Ledger: Run the Reporting Currency: Create Opening Balance Journals in Reporting Currency program. For more information on running this program, see the Implementation Considerations, Oracle General Ledger User's Guide topic within theOracle General Ledger User's Guide.
• Secondary Ledger: Use the Consolidation Workbench to copy initial balances. For more information on using the Consolidation Workbench, refer to the Oracle Financials Implementation Guide.

Restrictions:

• The program cannot be used for a secondary ledger whose subledger accounting method is different from that of the primary ledger.
• The program should be run immediately after creation of the new secondary/reporting currency ledger so that no new transactions are made between the creation of the new secondary/reporting ledger and running of the historic upgrade program.
• All fully accounted transactions of the primary ledger must be transferred to Oracle General Ledger before running the program.

To run the SLA Secondary/ALC Ledger Historic Upgrade program:

1. Navigate to the Submit Request form.
2. Select SLA Secondary/ALC Ledger Historic Upgrade from the LOV in the Name field.
3. Enter the parameters as follows:
   
   1. Primary Ledger: Select the primary ledger.
   2. Reporting/Secondary Ledger: Select the reporting/secondary ledger.
   3. Upgrade Start Period: Select the first period from which you wish to run the historic upgrade.
   4. Secondary Conversion Option: Select the secondary conversion option to be used when running a historic upgrade for a secondary ledger. The options are Derive from Original Transaction Rate and Use Initialization Rate.
   5. Secondary Currency Conversion Type: Select the currency conversion type or rate type to be used when running a historic upgrade for a secondary ledger.
   6. Secondary Currency Conversion Date: Select the conversion date to be used when running a historic upgrade for a secondary ledger.
   7. Mode:
      
      • Final: Select this value after you run the program in the Validation mode.
        This mode creates the journal entries within Oracle Subledger Accounting.
      • Validation: Select this value to run the program in Validation mode.
        
        Important: It is recommended to first run the program in Validation mode so that the program runs the validations that must be checked before performing the historic upgrade. If validations fail, you can view them within the log file and take action. After the program runs successfully in the Validation mode, you can run it in Final mode.
        
      • Recovery: Select this value to purge results after a concurrent request is terminated while in Final mode.
        
        Important: If you terminate the program while it is running in Final mode, then you must first run the program in Recovery mode before running the program again in Final mode. Recovery mode purges any upgrade data that may have been created during the terminated concurrent request.
        
   
   Note: In the case of a reporting currency ledger, the conversion option, rate type, and rate date are picked up from the ledger relationships defined in the Accounting Setup Manager.
   

Running the Upgrade Historical Subledger Transaction Accounting Program on Demand

Oracle Subledger Accounting provides a concurrent program, Upgrade Historical Subledger Transaction Accounting, that allows the historical accounting data conversion to be done independently for each subledger.

You must run the concurrent program Upgrade Historical Subledger Transaction Accounting instead of using the On Demand Upgrade Patch.

To run the Upgrade Historical Subledger Transaction Accounting, enter the following parameters:

1. Select or enter the Application name. The list shows the application attached to the responsibility from where the concurrent program is submitted.
2. Enter the name of the Ledger. The list shows all Primary ledgers.
3. Enter the Start Period Name. The list shows all periods not yet upgraded and associated with the ledger selected in the above parameter.
4. Enter the Number of Workers. The value should be greater than 1. Otherwise, the application inputs the default value of 1.
5. Enter the Batch size. The default value is 1000.

** Copied from here under link

https://docs.oracle.com/cd/E18727_01/doc.121/e13628/T149412T521412.htm

HOW TO CHECK FOREIGN KEYS IN EBS

SELECT tab.table_id, tab.table_name,  col.column_name,fk.foreign_key_name,
       pk_tab.table_name pk_table_name, pk_col.column_name pk_column_name,pk.PRIMARY_KEY_NAME
  FROM fnd_tables tab,
       fnd_columns col,
       fnd_foreign_keys fk,
       fnd_foreign_key_columns fkc,
       fnd_primary_keys pk,
       fnd_primary_key_columns pkc,
       fnd_tables pk_tab,
       fnd_columns pk_col
 WHERE tab.table_id = col.table_id
   AND fk.table_id = tab.table_id
   AND fkc.table_id = tab.table_id
   AND fkc.column_id = col.column_id
   AND fkc.foreign_key_id = fk.foreign_key_id
   AND fk.primary_key_application_id = pk.application_id
   AND fk.primary_key_id = pk.primary_key_id
   AND fk.primary_key_table_id = pk.table_id
   AND pk.primary_key_id = pkc.primary_key_id
   AND pk_tab.table_id = pkc.table_id
   AND pk_col.column_id = pkc.column_id
   AND pk_col.table_id = pkc.table_id
   AND pk_col.application_id = pkc.application_id
   AND pk.audit_key_flag = 'Y'

Create and register a custom Descriptive Flexfield (DFF)

http://oraclemaniac.com/2012/08/14/create-and-register-a-custom-descriptive-flexfield-dff/

Display User Name in ERP Report

11.       Add Parameter P_CONC_REQUEST_ID in report

2     Begin

3       SRW.USER_EXIT('FND SRWINIT');

4

begin

                                select nvl(description,user_name)

                                into :P_GENERATED_BY

                                from fnd_user

                                where USER_ID = fnd_profile.value('USER_ID');

                exception

                                when no_data_found then null;

                end;

5Return (True);

List of Tables for Oracle Forms Personalization

FND_FORM_CUSTOM_RULES
FND_FORM_CUSTOM_SCOPES
FND_FORM_CUSTOM_ACTIONS
FND_FORM_CUSTOM_PARAMS
FND_FORM_CUSTOM_PROP_VALUES
FND_FORM_CUSTOM_PROP_LIST

Find all current Oracle Application user logged in

/**********************************************************
 *PURPOSE: To list all users currently logged in Oracle Apps *
 **********************************************************/

SELECT DISTINCT ic.disabled_flag,
  fu.user_name User_Name,
  fr.RESPONSIBILITY_KEY Responsibility,
  fu.user_id,
  fu.description,
  fu.employee_id,
  ic.responsibility_application_id,
  ic.responsibility_id,
  ic.org_id,
  ic.function_type,
  ic.counter,
  ic.first_connect,
  ic.last_connect,
  ic.nls_territory,
  ic.time_out,
  fr.menu_id,
  fr.responsibility_key
FROM fnd_user fu,
  fnd_responsibility fr,
  icx_sessions ic
WHERE fu.user_id          = ic.user_id
AND fr.responsibility_id  = ic.responsibility_id
AND ic.disabled_flag      ='N'
and IC.RESPONSIBILITY_ID is not null
AND ic.last_connect       > sysdate - (ic.time_out/60)/96

Application Form Existance into Hierarchy (Menu Hierarchy)

SELECT   'PR', prompt, menu.menu_id, menu.description, responsibility_name,
         rsp.description application, user_name, full_name full_name
    FROM fnd_menu_entries_vl menu,
         apps.fnd_responsibility_vl rsp,
         fnd_user_resp_groups_direct ursp,
         (SELECT fu.user_id, fu.user_name, full_name full_name, pp.person_id
            FROM apps.fnd_user fu, apps.per_people_f pp
           WHERE pp.person_id = fu.employee_id
             AND NVL (fu.end_date, SYSDATE + 1) >= TRUNC (SYSDATE)) person
   WHERE rsp.menu_id = menu.menu_id
     AND ursp.responsibility_id = rsp.responsibility_id
     AND person.user_id = ursp.user_id
     AND NVL (ursp.end_date, SYSDATE + 1) >= TRUNC (SYSDATE)
     AND (   menu.menu_id IN (
                SELECT menu.menu_id
                  FROM fnd_menu_entries_vl menu
                 WHERE sub_menu_id IN (SELECT menu.menu_id
                                         --, menu.description,SUB_MENU_ID
                                       FROM   fnd_menu_entries_vl menu
                                        WHERE function_id IN (:P_function_id))
                UNION ALL
                SELECT menu.menu_id
                  FROM fnd_menu_entries_vl menu
                 WHERE sub_menu_id IN (
                          SELECT menu.menu_id
                            FROM fnd_menu_entries_vl menu
                           WHERE sub_menu_id IN (
                                                 SELECT menu.menu_id
                                                   --, menu.description,SUB_MENU_ID
                                                 FROM   fnd_menu_entries_vl menu
                                                  WHERE function_id IN (:P_function_id)))
                UNION ALL
                SELECT menu.menu_id
                  FROM fnd_menu_entries_vl menu
                 WHERE sub_menu_id IN (
                          SELECT menu.menu_id
                            FROM fnd_menu_entries_vl menu
                           WHERE sub_menu_id IN (
                                    SELECT menu.menu_id
                                      FROM fnd_menu_entries_vl menu
                                     WHERE sub_menu_id IN (
                                                 SELECT menu.menu_id
                                                   --, menu.description,SUB_MENU_ID
                                                 FROM   fnd_menu_entries_vl menu
                                                  WHERE function_id IN (:P_function_id))))
                UNION ALL
                SELECT menu.menu_id
                  FROM fnd_menu_entries_vl menu
                 WHERE sub_menu_id IN (
                          SELECT menu.menu_id
                            FROM fnd_menu_entries_vl menu
                           WHERE sub_menu_id IN (
                                    SELECT menu.menu_id
                                      FROM fnd_menu_entries_vl menu
                                     WHERE sub_menu_id IN (
                                              SELECT menu.menu_id
                                                FROM fnd_menu_entries_vl menu
                                               WHERE sub_menu_id IN (
                                                        SELECT menu.menu_id
                                                          --, menu.description,SUB_MENU_ID
                                                        FROM   fnd_menu_entries_vl menu
                                                         WHERE function_id IN
                                                                       (:P_function_id)))))
                UNION ALL
                SELECT menu.menu_id
                  FROM fnd_menu_entries_vl menu
                 WHERE sub_menu_id IN (
                          SELECT menu.menu_id
                            FROM fnd_menu_entries_vl menu
                           WHERE sub_menu_id IN (
                                    SELECT menu.menu_id
                                      FROM fnd_menu_entries_vl menu
                                     WHERE sub_menu_id IN (
                                              SELECT menu.menu_id
                                                FROM fnd_menu_entries_vl menu
                                               WHERE sub_menu_id IN (
                                                        SELECT menu.menu_id
                                                          FROM fnd_menu_entries_vl menu
                                                         WHERE sub_menu_id IN (
                                                                  SELECT menu.menu_id
                                                                    --, menu.description,SUB_MENU_ID
                                                                  FROM   fnd_menu_entries_vl menu
                                                                   WHERE function_id IN
                                                                            (:P_function_id))))))
                UNION ALL
                SELECT menu.menu_id
                  FROM fnd_menu_entries_vl menu
                 WHERE sub_menu_id IN (
                          SELECT menu.menu_id
                            FROM fnd_menu_entries_vl menu
                           WHERE sub_menu_id IN (
                                    SELECT menu.menu_id
                                      FROM fnd_menu_entries_vl menu
                                     WHERE sub_menu_id IN (
                                              SELECT menu.menu_id
                                                FROM fnd_menu_entries_vl menu
                                               WHERE sub_menu_id IN (
                                                        SELECT menu.menu_id
                                                          FROM fnd_menu_entries_vl menu
                                                         WHERE sub_menu_id IN (
                                                                  SELECT menu.menu_id
                                                                    FROM fnd_menu_entries_vl menu
                                                                   WHERE sub_menu_id IN (
                                                                            SELECT menu.menu_id
                                                                              --, menu.description,SUB_MENU_ID
                                                                            FROM   fnd_menu_entries_vl menu
                                                                             WHERE function_id IN
                                                                                      (:P_function_id))))))))
          OR menu.function_id IN (:P_function_id)
         )
GROUP BY menu.menu_id,
         menu.description,
         responsibility_name,
         rsp.description,
         user_name,
         full_name,
         prompt

Custom Form Compilation

login SSH by user/Pass e.g developer / 123456

 1. Execute the following file availabe at user home or /d01/oracle (file to set environment variable by Apps DBA)  . APPSPROD_erp-01.env

 2. Move to the full qualified path where file exist which need to be compiled (/d01/oracle/prodappl/gl/11.5.0/forms/US) and execute the given    below command
--> f60gen userid=APPS/APPS module=PAYMENT_ALERT_CONFIG.fmb module_type=form compile_all=Y
    OR
    f60gen module=/d01/oracle/prodappl/gl/11.5.0/forms/US/payment_alert_config.fmb userid=apps/appsoutput_file=/home/developer/payment_alert_config.log

Forms Personalization Tutorial

http://erpschools.com/articles/forms-personalization-tutorial

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)