Yuvisekar Apps DBA Consultant

Thursday, 26 June 2014

FRM-92101: there was a failure in the forms server during startup

FRM-92101: there was a failure in the forms server during startup due to Forms is not generated successfully

bash-3.2$ frmcmp_batch.sh module=/FMSAPP/R12/apps/apps_st/appl/au/12.0.0/forms/US/APPSTAND.fmb userid=apps/fms4r0d output_file=/FMSAPP/R12/apps/apps_st/appl/au/12.0.0/forms/US/APPSTAND.fmx module_type=form compile_all=special
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

Forms 10.1 (Form Compiler): Release - Production

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
PL/SQL Version 10.1.0.5.0 (Production)
Oracle Procedure Builder V10.1.2.3.0 - Production
Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)
Oracle Multimedia Version 10.1.2.0.2 (Production)
Oracle Tools Integration Version 10.1.2.0.2 (Production)
Oracle Tools Common Area Version 10.1.2.0.2
Oracle CORE 10.1.0.5.0 Production
Compiling package specification APP_CUSTOM...
No compilation errors.

Compiling package specification APP_CUSTOM...
No compilation errors.

Compiling package body APP_CUSTOM...
No compilation errors.

Compiling EXPORT trigger on form...
No compilation errors.

Compiling CLOSE_THIS_WINDOW trigger on form...
No compilation errors.

Compiling WHEN-FORM-NAVIGATE trigger on form...
No compilation errors.

Compiling LASTRECORD trigger on form...
No compilation errors.

Compiling STANDARD_ATTACHMENTS trigger on form...
No compilation errors.

Compiling ZOOM trigger on form...
No compilation errors.

Compiling WHEN-NEW-FORM-INSTANCE trigger on form...
No compilation errors.

Compiling WHEN-NEW-RECORD-INSTANCE trigger on form...
No compilation errors.

Compiling PRE-FORM trigger on form...
No compilation errors.

Compiling WHEN-NEW-ITEM-INSTANCE trigger on form...
No compilation errors.

Compiling WHEN-NEW-BLOCK-INSTANCE trigger on form...
No compilation errors.

Compiling QUERY_FIND trigger on form...
No compilation errors.

Compiling MENU_TO_APPCORE trigger on form...
No compilation errors.

Compiling APPCORE_TO_CALENDAR trigger on form...
No compilation errors.

Compiling CLOSE_WINDOW trigger on form...
No compilation errors.

Compiling ACCEPT trigger on form...
No compilation errors.

Compiling PRE-POPUP-MENU trigger on form...
No compilation errors.

Compiling WHEN-WINDOW-CLOSED trigger on form...
No compilation errors.

Compiling KEY-EDIT trigger on form...
No compilation errors.

Compiling KEY-F9 trigger on form...
No compilation errors.

Compiling KEY-F0 trigger on form...
No compilation errors.

Compiling KEY-F1 trigger on form...
No compilation errors.

Compiling KEY-F2 trigger on form...
No compilation errors.

Compiling KEY-F3 trigger on form...
No compilation errors.

Compiling KEY-F4 trigger on form...
No compilation errors.

Compiling KEY-F5 trigger on form...
No compilation errors.

Compiling KEY-F6 trigger on form...
No compilation errors.

Compiling KEY-F7 trigger on form...
No compilation errors.

Compiling KEY-F8 trigger on form...
No compilation errors.

Compiling KEY-LISTVAL trigger on TEXT_ITEM130 item in BLOCKNAME data block...
No compilation errors.

Compiling KEY-PREV-ITEM trigger on SAMPLE_FOLDER data block...
No compilation errors.

Compiling KEY-NEXT-ITEM trigger on SAMPLE_FOLDER data block...
No compilation errors.

Compiling KEY-EXEQRY trigger on SAMPLE_FOLDER data block...
No compilation errors.

Compiling PRE-QUERY trigger on SAMPLE_FOLDER data block...
No compilation errors.

Compiling WHEN-NEW-BLOCK-INSTANCE trigger on SAMPLE_FOLDER data block...
No compilation errors.

Compiling POST-BLOCK trigger on SAMPLE_FOLDER data block...
No compilation errors.

Compiling PRE-BLOCK trigger on SAMPLE_FOLDER data block...
No compilation errors.

Compiling WHEN-NEW-ITEM-INSTANCE trigger on CURRENT_RECORD_INDICATOR item in DETAILBLOCK data block...
No compilation errors.

Compiling WHEN-NEW-ITEM-INSTANCE trigger on DRILLDOWN_RECORD_INDICATOR item in DETAILBLOCK data block...
No compilation errors.

Compiling KEY-LISTVAL trigger on TEXT_ITEM88 item in DETAILBLOCK data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on OPEN item in FOLDER_TOOLS data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on SAVE item in FOLDER_TOOLS data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NEW item in FOLDER_TOOLS data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on DELETE item in FOLDER_TOOLS data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on SHOW item in FOLDER_TOOLS data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on HIDE item in FOLDER_TOOLS data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on WIDEN item in FOLDER_TOOLS data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on SHRINK item in FOLDER_TOOLS data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on UP item in FOLDER_TOOLS data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on LEFT item in FOLDER_TOOLS data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on RIGHT item in FOLDER_TOOLS data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on DOWN item in FOLDER_TOOLS data block...
No compilation errors.

Compiling KEY-EXIT trigger on FOLDER_CONTROL data block...
No compilation errors.

Compiling KEY-DOWN trigger on FOLDER_CONTROL data block...
No compilation errors.

Compiling KEY-CREREC trigger on FOLDER_CONTROL data block...
No compilation errors.

Compiling KEY-COMMIT trigger on FOLDER_CONTROL data block...
No compilation errors.

Compiling KEY-CLRREC trigger on FOLDER_CONTROL data block...
No compilation errors.

Compiling KEY-CLRBLK trigger on FOLDER_CONTROL data block...
No compilation errors.

Compiling KEY-NXTREC trigger on FOLDER_CONTROL data block...
No compilation errors.

Compiling KEY-CLRFRM trigger on FOLDER_CONTROL data block...
No compilation errors.

Compiling KEY-UP trigger on FOLDER_CONTROL data block...
No compilation errors.

Compiling KEY-PRVREC trigger on FOLDER_CONTROL data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on SHOW_QUERY item in FOLDER_CONTROL data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on OK_SAVE_FOLDER item in FOLDER_CONTROL data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on CANCEL_SAVE_FOLDER item in FOLDER_CONTROL data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on OK_ALTER_PROMPT item in FOLDER_CONTROL data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on CANCEL_ALTER_PROMPT item in FOLDER_CONTROL data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on DEFAULT_PROMPT item in FOLDER_CONTROL data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on OK_WHERE_CLAUSE item in FOLDER_CONTROL data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on OK_AUTOSIZE item in FOLDER_CONTROL data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on CANCEL_AUTOSIZE item in FOLDER_CONTROL data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on OK_SORT_DATA item in FOLDER_CONTROL data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on CANCEL_SORT_DATA item in FOLDER_CONTROL data block...
No compilation errors.

Compiling WHEN-RADIO-CHANGED trigger on CALENDAR data block...
No compilation errors.

Compiling KEY-OTHERS trigger on CALENDAR data block...
No compilation errors.

Compiling KEY-NEXT-ITEM trigger on CALENDAR data block...
No compilation errors.

Compiling KEY-PREV-ITEM trigger on CALENDAR data block...
No compilation errors.

Compiling KEY-ENTER trigger on CALENDAR data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on CALENDAR data block...
No compilation errors.

Compiling WHEN-LIST-CHANGED trigger on CALENDAR data block...
No compilation errors.

Compiling WHEN-MOUSE-CLICK trigger on CALENDAR data block...
No compilation errors.

Compiling KEY-DOWN trigger on CALENDAR data block...
No compilation errors.

Compiling KEY-UP trigger on CALENDAR data block...
No compilation errors.

Compiling KEY-NXTREC trigger on CALENDAR data block...
No compilation errors.

Compiling KEY-PRVREC trigger on CALENDAR data block...
No compilation errors.

Compiling WHEN-MOUSE-DOUBLECLICK trigger on CALENDAR data block...
No compilation errors.

Compiling WHEN-VALIDATE-ITEM trigger on TIMEZONE_NAME item in CALENDAR data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on SHOW_TIMEZONES_DATETIME item in CALENDAR data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on PREV_MONTH item in CALENDAR data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NEXT_MONTH item in CALENDAR data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NEXT_YEAR item in CALENDAR data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on PREV_YEAR item in CALENDAR data block...
No compilation errors.

Compiling KEY-NXTBLK trigger on QUERY_FIND data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on CLEAR item in QUERY_FIND data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NEW item in QUERY_FIND data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on FIND item in QUERY_FIND data block...
No compilation errors.

Compiling WHEN-CLEAR-BLOCK trigger on SAMPLE_MULTI data block...
No compilation errors.

Compiling KEY-CLRREC trigger on SAMPLE_MULTI data block...
No compilation errors.

Compiling KEY-F2 trigger on SAMPLE_MULTI data block...
No compilation errors.

Compiling KEY-F3 trigger on SAMPLE_MULTI data block...
No compilation errors.

Compiling KEY-CREREC trigger on SAMPLE_MULTI data block...
No compilation errors.

Compiling PRE-BLOCK trigger on SAMPLE_MULTI data block...
No compilation errors.

Compiling POST-BLOCK trigger on SAMPLE_MULTI data block...
No compilation errors.

Compiling SELECT_ALL trigger on SAMPLE_MULTI data block...
No compilation errors.

Compiling DESELECT_ALL trigger on SAMPLE_MULTI data block...
No compilation errors.

Compiling WHEN-MOUSE-CLICK trigger on SAMPLE_MULTI data block...
No compilation errors.

Compiling WHEN-NEW-RECORD-INSTANCE trigger on SAMPLE_MULTI data block...
No compilation errors.

Compiling KEY-DELREC trigger on SAMPLE_MULTI data block...
No compilation errors.

Compiling KEY-EXIT trigger on PROGRESS_INDICATOR data block...
No compilation errors.

Compiling KEY-DOWN trigger on PROGRESS_INDICATOR data block...
No compilation errors.

Compiling KEY-CREREC trigger on PROGRESS_INDICATOR data block...
No compilation errors.

Compiling KEY-COMMIT trigger on PROGRESS_INDICATOR data block...
No compilation errors.

Compiling KEY-CLRREC trigger on PROGRESS_INDICATOR data block...
No compilation errors.

Compiling KEY-CLRBLK trigger on PROGRESS_INDICATOR data block...
No compilation errors.

Compiling KEY-NXTREC trigger on PROGRESS_INDICATOR data block...
No compilation errors.

Compiling KEY-CLRFRM trigger on PROGRESS_INDICATOR data block...
No compilation errors.

Compiling KEY-UP trigger on PROGRESS_INDICATOR data block...
No compilation errors.

Compiling KEY-PRVREC trigger on PROGRESS_INDICATOR data block...
No compilation errors.

Compiling WHEN-LIST-CHANGED trigger on OBJECT_TYPE item in PROGRESS_INDICATOR data block...
No compilation errors.

Compiling WHEN-LIST-CHANGED trigger on OBJ1 item in PROGRESS_INDICATOR data block...
No compilation errors.

Compiling WHEN-LIST-CHANGED trigger on OBJ2 item in PROGRESS_INDICATOR data block...
No compilation errors.

Compiling WHEN-LIST-CHANGED trigger on OBJ4 item in PROGRESS_INDICATOR data block...
No compilation errors.

Compiling WHEN-VALIDATE-ITEM trigger on OBJ3 item in PROGRESS_INDICATOR data block...
No compilation errors.

Compiling WHEN-LIST-CHANGED trigger on PROP item in PROGRESS_INDICATOR data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on UPDATE_PROPERTIES item in PROGRESS_INDICATOR data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on REFRESH item in PROGRESS_INDICATOR data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on CANCEL_PROPERTIES item in PROGRESS_INDICATOR data block...
No compilation errors.

Compiling WHEN-CUSTOM-ITEM-EVENT trigger on PJC item in BLK_PJC data block...
No compilation errors.

Compiling WHEN-MOUSE-UP trigger in FOLDER_PROMPT_MULTIROW property class...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger in FOLDER_OPEN property class...
No compilation errors.

Created form file /FMSAPP/R12/apps/apps_st/appl/au/12.0.0/forms/US/APPSTAND.fmx

bash-3.2$ frmcmp_batch.sh module=/FMSAPP/R12/apps/apps_st/appl/au/12.0.0/resource/HR_SPEC.pll userid=apps/fms4r0d output_file=/FMSAPP/R12/apps/apps_st/appl/au/12.0.0/resource/HR_SPEC.plx module_type=LIBRARY batch=yes compile_all=special
bash-3.2$

bash-3.2$ frmcmp_batch.sh module=/FMSAPP/R12/apps/apps_st/appl/au/12.0.0/resource/HR_GEN.pll userid=apps/fms4r0d output_file=/FMSAPP/R12/apps/apps_st/appl/au/12.0.0/resource/HR_GEN.plx module_type=LIBRARY batch=yes compile_all=special
bash-3.2$

bash-3.2$ frmcmp_batch.sh module=/FMSAPP/R12/apps/apps_st/appl/au/12.0.0/forms/US/HRSTAND.fmb userid=apps/fms4r0d output_file=/FMSAPP/R12/apps/apps_st/appl/au/12.0.0/forms/US/HRSTAND.fmx module_type=form compile_all=special
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

Forms 10.1 (Form Compiler): Release - Production

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
PL/SQL Version 10.1.0.5.0 (Production)
Oracle Procedure Builder V10.1.2.3.0 - Production
Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)
Oracle Multimedia Version 10.1.2.0.2 (Production)
Oracle Tools Integration Version 10.1.2.0.2 (Production)
Oracle Tools Common Area Version 10.1.2.0.2
Oracle CORE 10.1.0.5.0 Production
FRM-18108: Failed to load the following objects.

Source Module:APPSTAND
Source Object: ENABLE_LIST_LAMP
Source Module:APPSTAND
Source Object: STANDARD_TOOLBAR
Source Module:APPSTAND
Source Object: STANDARD_PC_AND_VA
Source Module:APPSTAND
Source Object: ENABLE_LIST_LAMP
Compiling package specification SELECT_CHILD...
No compilation errors.

Compiling package specification APP_CUSTOM...
No compilation errors.

Compiling package body SELECT_CHILD...
No compilation errors.

Compiling package specification SELECT_CHILD...
No compilation errors.

Compiling procedure SESSION_DATE...
No compilation errors.

Compiling package specification APP_CUSTOM...
No compilation errors.

Compiling package body APP_CUSTOM...
No compilation errors.

Compiling procedure LOCAL_PRE_NAV_VALIDATION...
No compilation errors.

Compiling procedure INIT_DATE_DEPENDENT...
No compilation errors.

Compiling procedure CHANGE_WINDOW_TITLES...
No compilation errors.

Compiling procedure LOCAL_POST_CALL_FORM...
No compilation errors.

Compiling procedure HRSTAND_FDRCSID...
No compilation errors.

Compiling procedure HRSTAND_CHOOSE_LOV...
No compilation errors.

Compiling function CHK_BALANCE_BREAKDOWN...
No compilation errors.

Compiling procedure CHECK_PACKAGE_FAILURE...
No compilation errors.

Compiling procedure QUERY_MASTER_DETAILS...
No compilation errors.

Compiling procedure CLEAR_ALL_MASTER_DETAILS...
No compilation errors.

Compiling procedure DISPLAY_BAL1_BREAKDOWN_WINDOW...
No compilation errors.

Compiling HR_NAV_CLOSE_WINDOW trigger on form...
No compilation errors.

Compiling HR_NAV_KEY_EXIT trigger on form...
No compilation errors.

Compiling HR_NAV_ON_ROLLBACK trigger on form...
No compilation errors.

Compiling LOCAL_PRE_NAV_VALIDATION trigger on form...
No compilation errors.

Compiling LOCAL_POST_CALL_FORM trigger on form...
No compilation errors.

Compiling INIT_DATE_DEPENDENT trigger on form...
No compilation errors.

Compiling CHANGE_WINDOW_TITLES trigger on form...
No compilation errors.

Compiling SPECIAL1 trigger on form...
No compilation errors.

Compiling SPECIAL2 trigger on form...
No compilation errors.

Compiling SPECIAL3 trigger on form...
No compilation errors.

Compiling SPECIAL4 trigger on form...
No compilation errors.

Compiling SPECIAL11 trigger on form...
No compilation errors.

Compiling SPECIAL12 trigger on form...
No compilation errors.

Compiling SPECIAL13 trigger on form...
No compilation errors.

Compiling SPECIAL14 trigger on form...
No compilation errors.

Compiling SPECIAL15 trigger on form...
No compilation errors.

Compiling SPECIAL11_CHECKBOX trigger on form...
No compilation errors.

Compiling SPECIAL12_CHECKBOX trigger on form...
No compilation errors.

Compiling SPECIAL13_CHECKBOX trigger on form...
No compilation errors.

Compiling SPECIAL14_CHECKBOX trigger on form...
No compilation errors.

Compiling SPECIAL15_CHECKBOX trigger on form...
No compilation errors.

Compiling KEY-LISTVAL trigger on form...
No compilation errors.

Compiling KEY-EDIT trigger on form...
No compilation errors.

Compiling KEY-HELP trigger on form...
No compilation errors.

Compiling KEY-EXIT trigger on form...
No compilation errors.

Compiling ON-ROLLBACK trigger on form...
No compilation errors.

Compiling POST_CALL trigger on form...
No compilation errors.

Compiling KEY-MENU trigger on form...
No compilation errors.

Compiling PRE-LOGOUT trigger on form...
No compilation errors.

Compiling KEY-DUPREC trigger on form...
No compilation errors.

Compiling WHEN-WINDOW-CLOSED trigger on form...
No compilation errors.

Compiling POST-FORM trigger on form...
No compilation errors.

Compiling ON-ERROR trigger on form...
No compilation errors.

Compiling ATTACHMENTS trigger on form...
No compilation errors.

Compiling PRE-BLOCK trigger on form...
No compilation errors.

Compiling WHEN-NEW-FORM-INSTANCE trigger on form...
No compilation errors.

Compiling ON-MESSAGE trigger on form...
No compilation errors.

Compiling HRSTAND_FDRCSID trigger on form...
No compilation errors.

Compiling HR_APP_TRACE_TRIGGER trigger on form...
No compilation errors.

Compiling HRLOCAL trigger on form...
No compilation errors.

Compiling ON-CLEAR-DETAILS trigger on form...
No compilation errors.

Compiling WHEN-CUSTOM-ITEM-EVENT trigger on USERAREA item in CTL_GLOBALS data block...
No compilation errors.

Compiling WHEN-VALIDATE-ITEM trigger on CTL_EMP data block...
No compilation errors.

Compiling PRE-BLOCK trigger on CTL_EMP data block...
No compilation errors.

Compiling WHEN-LIST-CHANGED trigger on IDENT_NUMBER_LIST item in CTL_EMP data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on CTL_EMP_FIND_BUTTON item in CTL_EMP data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on CTL_EMP_CLEAR_BUTTON item in CTL_EMP data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NAV_BUTTON1 item in CTL_HRNAV data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NAV_BUTTON2 item in CTL_HRNAV data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NAV_BUTTON3 item in CTL_HRNAV data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NAV_BUTTON4 item in CTL_HRNAV data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NAV_BUTTON5 item in CTL_HRNAV data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on DONE item in CONTROL data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on CLOSE item in CONTROL data block...
No compilation errors.

Compiling KEY-CLRBLK trigger on RRS1 data block...
No compilation errors.

Compiling KEY-F9 trigger on RRS1 data block...
No compilation errors.

Compiling WHEN-NEW-RECORD-INSTANCE trigger on RRS1 data block...
No compilation errors.

Compiling KEY-EXEQRY trigger on RRS1 data block...
No compilation errors.

Compiling KEY-NXTBLK trigger on RRS1 data block...
No compilation errors.

Compiling KEY-ENTQRY trigger on RRS1 data block...
No compilation errors.

Compiling KEY-CLRREC trigger on RRS1 data block...
No compilation errors.

Compiling WHEN-NEW-BLOCK-INSTANCE trigger on RRS1 data block...
No compilation errors.

Compiling POST-QUERY trigger on RRS1 data block...
No compilation errors.

Compiling WHEN-NEW-ITEM-INSTANCE trigger on CURRENT_RECORD_INDICATOR item in RRS1 data block...
No compilation errors.

Compiling WHEN-NEW-BLOCK-INSTANCE trigger on BAL1 data block...
No compilation errors.

Compiling POST-QUERY trigger on BAL1 data block...
No compilation errors.

Compiling ON-POPULATE-DETAILS trigger on BAL1 data block...
No compilation errors.

Compiling ON-CHECK-DELETE-MASTER trigger on BAL1 data block...
No compilation errors.

Compiling WHEN-NEW-ITEM-INSTANCE trigger on CURRENT_RECORD_INDICATOR item in BAL1 data block...
No compilation errors.

Compiling WHEN-NEW-BLOCK-INSTANCE trigger on RRV1 data block...
No compilation errors.

Compiling KEY-F9 trigger on RRV1 data block...
No compilation errors.

Compiling POST-QUERY trigger on RRV1 data block...
No compilation errors.

Compiling WHEN-NEW-ITEM-INSTANCE trigger on CURRENT_RECORD_INDICATOR item in RRV1 data block...
No compilation errors.

Compiling KEY-OTHERS trigger on CTL_RRS data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on RESULT_VALUES item in CTL_RRS data block...
No compilation errors.

Compiling WHEN-NEW-BLOCK-INSTANCE trigger on PPM1 data block...
No compilation errors.

Compiling POST-QUERY trigger on PPM1 data block...
No compilation errors.

Compiling KEY-F9 trigger on PPM1 data block...
No compilation errors.

Compiling WHEN-NEW-ITEM-INSTANCE trigger on CURRENT_RECORD_INDICATOR item in PPM1 data block...
No compilation errors.

Compiling WHEN-CUSTOM-ITEM-EVENT trigger on CLIENT_AREA item in HRKPI data block...
No compilation errors.

FRM-30048: Unable to find record group .
LOV ENABLE_LIST_LAMP
Form: HRSTAND

FRM-30085: Unable to adjust form for output.

Form not created
bash-3.2$

Actually while compiling all the form and library files using adadmin, PERWSHRG.fmb is not generated successfully.
We tried to compile it manually, still issue persists.

adident Header PERWSHRG.fmb shows the APPSTAND.fmb and HRSTAND.fmb have relationship with this form file.

So we tried to compile it as per above order, HRSTAND.fmb have issue.
So i have copied this HRSTAND.fmb file from another APPPRD1 and compiled it successfully and now PERWSHRG.fmb got generated successfully.

Tuesday, 24 June 2014

Important Oracle documents

Create Accounting Performance issue related documents

How to improve Performance Of Create Accounting Program [ID 754604.1]
Troubleshooting Create Accounting Performance Issues in Payables [ID 1271365.1]
Create Accounting Performance Issue (xla_accounting_pkg.unit_processor_batch) [ID 1136906.1]
Create Accounting Accounting Program Performance Issue [ID 1098185.1]
XLAACCUP Accounting Program, Create Accounting Performance Problem [ID 977522.1]
XLAACCPB request program: Create Accounting performance issue [ID 602317.1]
XLAACCPB module: Create Accounting Poor Performance [ID 952764.1]
R12.1 Performance Problem With Create Accounting Which Did Not Complete In 12.5 Hours [ID 944256.1]
R12: Performance Issue with Create Accounting [ID 763500.1]

R12 SLA/FAH: How to Improve Performance in Subledger Accounting & Financials Accounting Hub (Doc ID 791049.1)

Create Accounting Program (XLAACCPB) Performance Problem (Doc ID 1472064.1)

11i & R12 Workflow Mailer Configuration Guide

11i & R12 Workflow Mailer Configuration Guide

First things first ................................................................................................................... 3
IMAP & SMTP Server Details ....................................................................................... 3
Dedicated Email ID......................................................................................................... 3
Verify Access to SMTP Server....................................................................................... 3
Folder Creation ............................................................................................................... 5
Verify Access to IMAP Server ....................................................................................... 5
Configuration of Workflow Mailer..................................................................................... 7
Step 1 .......................................................................................................................... 7
Step 2 .......................................................................................................................... 8
Step 3 .......................................................................................................................... 8
Step 4 .......................................................................................................................... 9
Step 5 .......................................................................................................................... 9
Step 6 ........................................................................................................................ 10
Step 7 ........................................................................................................................ 11
Step 8 ........................................................................................................................ 12
Step 9 ........................................................................................................................ 13
Step 10 ...................................................................................................................... 14
Step 11 ...................................................................................................................... 14
Step 12 ...................................................................................................................... 15
Step 13 ...................................................................................................................... 16
Step 14 ...................................................................................................................... 17
Step 15 ...................................................................................................................... 17
Step 16 ...................................................................................................................... 18
Step 17 ...................................................................................................................... 19
Step 18 ...................................................................................................................... 20
Step 19 ...................................................................................................................... 21

IMAP & SMTP Server Details
1. Make sure you have fully functional IMAP & SMTP servers.
2. Obtain the IP address and hostname of the IMAP and SMTP server from your
Sysadmin.

Dedicated Email ID
3. Request the Sysadmin to create a dedicated email id to configure Workflow
Mailer.

Verify Access to SMTP Server

Assumptions
SMTP Server Name - smtp.abc.com
Concurrent Manager Server Name
(Where Java Mailer service will be running) - cm.abc.com
Application Owner - applabc
Dedicated Email Id - erpwfmail@abc.com
Your Email Id - mine@abc.com (official) and mine@def.com
(personal)
(wondering why two email-id’s – hold on to
that question for sometime)

Commands to check the mail ids configured correctly

1. Login to cm.abc.com as applabc user.

2. telnet smtp.abc.com 25 (25 is the default SMTP port)
Expected Output
(Sample)
Trying...
Connected to SMTP.abc.com.
Escape character is '^]'.
220 smtp.abc.com ESMTP Service (Lotus Domino Release 8.0.1)
ready at Wed, 8 Oct 2008 15:56:11 -0400

3. EHLO cm.abc.com
Expected Output
(Sample)
250-smtp.abc.com Hello cm.abc.com ([10.10.10.10]), pleased to
meet you
250-HELP
250-SIZE 15360000
250 PIPELINING

4. MAIL FROM: erpwfmail@abc.com
Expected Output
(Sample)
250 erpwfmail@abc.com... Sender OK

5. RCPT TO: mine@abc.com
Expected Output
(Sample)
250 mine@abc.com ... Recipient OK

6. DATA
Expected Output
(Sample)
354 Enter message, end with "." on a line by itself

7. Subject: Test email from cm.abc.com
Expected Output
(Sample)
[No output here, just stays in the next line, waiting to enter
the mail body]

8. Test
Expected Output
(Sample)
[No output here, just stays in the next line, waiting to enter
the mail body]

9. .(dot)
Expected Output
(Sample)
250 Message accepted for delivery

10. Quit
Expected Output
(Sample)
quit
221 smtp.abc.com SMTP Service closing transmission channel
Connection closed by foreign host.
The above test validates the email sending functionality of the SMTP server. Check
the inbox of mine@abc.com and make sure you had received the email.
In some organizations, additional policies might be imposed at the SMTP server level
to restrict emails being sent to non-official ids (in our assumption it is anything other
than @abc.com ie., mine@def.com ).

Now lets do a test to check for any such policies.

Repeat all steps as mentioned in the above table. For command 4 Replace mine@abc.com to mine@def.com

Error message “554 Relay rejected for policy reasons. “, will be reported, if
restrictions are imposed.

A message like this “250 mine@def.com ... Recipient OK” means you are good to go.

Even the “554 Relay rejected …” error message is not a show stopper to configure
the workflow mailer, provided this error message is reported only for non @abc.com
email id. You can still go ahead and configure the workflow mailer, with the only
drawback being you won’t be able to send any notification to non-official email id.
This will pose as a threat if you are planning to use say, Oracle Supplier Module
wherein when you register a new supplier, workflow will send out email notifications
to your suppliers with the username and password details.

Ok now is that we had verified our email id and SMTP server, lets do two more tests.

Folder Creation

4. Login to the corporate email application using the newly created email id ie.,
ebswfmail@abc.com.

5. Create two folders called PROCESS and DISCARD (not necessarily these
names, it can be anything). In general two folders are required – 1) To place
the emails that were processed by Workflow Mailer and 2) To place spam kind
of messages (received) which are meant to be discarded.

6. Try sending an email from erpwfmail@abc.com to your id (mine@abc.com)
and make sure you receive the email.

Verify Access to IMAP Server

Assumptions
IMAP Server Name - imap.abc.com

Commands for checking IMAP sever setup

1. Login to cm.abc.com as applabc user.
2. telnet imap.abc.com 143 (143 is the default SMTP port)
Expected Output
(Sample)
Trying...
Connected to imapserver.abc.com.
Escape character is '^]'.
OK Domino IMAP4 Server Release 8.0.1 ready Thu, 9 Oct 2008
15:25:52 -0400

3. 10 login mine <mine user password> [ Note: 10 is part of the command]
Expected Output
(Sample)
10 OK LOGIN completed

4. 10 select "INBOX"
Expected Output
(Sample)
* 181 EXISTS
* 0 RECENT
* OK [UNSEEN 20] Message 20 is first unseen
* OK [UIDVALIDITY 1] UIDs valid
* OK [UIDNEXT 182] Predicted next UID
* FLAGS (\Flagged \Seen \Answered \Deleted \Draft)
* OK [PERMANENTFLAGS (\Flagged \Seen \Answered \Deleted \Draft
\*)] Permanent flags
10 OK [READ-WRITE] SELECT completed

5. 10 select "PROCESS"
Expected Output
(Sample)
* 0 EXISTS
* 0 RECENT
* OK [UIDVALIDITY 2] UIDs valid
* OK [UIDNEXT 1] Predicted next UID
* FLAGS (\Flagged \Seen \Answered \Deleted \Draft)
* OK [PERMANENTFLAGS (\Flagged \Seen \Answered \Deleted \Draft
\*)] Permanent flags
10 OK [READ-WRITE] SELECT completed

6. 10 select "DISCARD"
Expected Output
(Sample)
* 17 EXISTS
* 0 RECENT
* OK [UIDVALIDITY 1] UIDs valid
* OK [UIDNEXT 18] Predicted next UID
* FLAGS (\Flagged \Seen \Answered \Deleted \Draft)
* OK [PERMANENTFLAGS (\Flagged \Seen \Answered \Deleted \Draft
\*)] Permanent flags
10 OK [READ-WRITE] SELECT completed

7 10 logout
Expected Output
(Sample)
* BYE logging out
10 OK LOGOUT completed
Connection closed by foreign host.

In the above table we verified two things
1) Access to IMAP Server
2) Accessibility to the folders that will be used by workflow mailer.

Now you are all set to configure the Workflow Mailer.

Configuration of Workflow Mailer

Step 1 : Login as Sysadmin -> System Administration -> Workflow
Step 2 : Click on the x symbol Next to Notification Mailers
Step 3 : Click on Edit
Step 4 : Click on Advanced
Step 5 : Click Next
Step 6 : Click Next
Represents the maximum number of times oracle apps will try connecting to the smtp server to obtain a connection in case of dis-connectivity / error before stopping workflow mailer.
Step 7 : Make sure you had provided valid details for IMAP Inbound server name, Username,password and SMTP Outbound Server Name, before clicking on next.

Click Next

At this stage following validation activities will be performed by Oracle Apps.
• Connectivity to IMAP and SMTP server
• Workflow mailer user Information (email id and password verification)
• Verify Process and Discard folder
IMAP server name.
Valid Email Id.
SMTP server name.

Step 8 : Verify Reply-to Address & HTML Agent value before clicking on Next and also enable
Autoclose FYI if its not checked.
Click Next
Step 9 : Click Next
Step 10 : Click Next
Step 11 : Click Next
Step 12 : Click Finish
Step 13 : At this time, the workflow mailer should be started. To verify the status, Click on Service Components.
Step 14 : Check for agents before starting Workflow Notification Mailer (if its still down).
Enter % in the search window.
Step 15 : Start Workflow Notification Mailer after making sure the agents are running (as in the below picture).
Step 16 : Select Start and click Go.
Step 17 : Click Ok.
Step 18 : To check on the status, click on the refresh button on the browser toolbar or F5 and NOT FROM THE DROP DOWN LIST.
Step 19 : The status for Workflow Notification Mailer should be with the tick mark and running.

This ensures your workflow mailer is up and running. Hoooooray!!!!!!!!!!!

OS Preparation for Oracle EBS R12 installation in IBM AIX on Power Systems

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for IBM AIX on Power Systems (64-bit) [ID 761569.1]

Oracle® E-Business Suite Installation and Upgrade Notes

Release 12 (12.1.1) for IBM AIX on Power Systems (64-bit)

April 2013

This document updates the following documentation with AIX specific information for Oracle E-Business Suite (EBS) Release 12 (12.1.1). Refer to the information contained here and to the appropriate manual when you install or upgrade your system.

Operating Systems Requirements

The operating system requirements for IBM AIX on Power Systems (64-bit) are listed in the following sections.

Operating System Supported Versions

The following table lists the supported operating system versions.

Operating System Name	Supported Version
IBM AIX (64-bit)	7 (7.1) - technology level 0, Service Pack 0 through technology level 2 (7100-00-00 - 7100-02-xx)

Use the following command to check the operating system, technology level and Service Pack versions:

$ oslevel -s

Required Patches

The following table lists the required patches and the minimum required versions for AIX on Power Systems. Unless otherwise noted, the patches must be installed manually.

Operating System	Required Patches
AIX 7 (7.1)	IZ87216¹ IZ87564¹ IZ89165¹ IV36875 for TL 02 SP01, SP02²

¹ : Required on the database tier with 11gR2 (11.2.0.2 or higher)
² : These fixes are required to address a known issue with Oracle Forms executables failing to run after relinking ( 'FRM-40833: Could not completely load dynamic user exit libraries. User exit FND did not execute') on these particular AIX TL and SP levels. Customers should contact IBM, request these APARs and apply them on their AIX systems on these TL/SP levels in order to avoid this problem.

Use the following command to retrieve the list of operating system patches already applied:

$ /usr/sbin/instfix -i | more

Use the following command to check for a specific patch:

$ /usr/sbin/instfix -ik [patchname]

Java Requirements

A number of Java Development Kits (JDK) and Java Runtime environments (JRE) are bundled with Oracle E-Business Suite version 12.1.1 and associated Oracle Database (11.1) and Application Server Oracle Homes (10.1.2 and 10.1.3).

The E-Business Suite's core use of the Java runtime environment for application tier processing is with JDK version 6 as bundled in the "<10.1.3 OH>/appsutil/jdk" directory for Release 12.1. There are several other versions of the JDK tied to older versions of the Application Server - the full list of Java versions on the application tier bundled with 12.1 are:

<10.1.2 OH>/jdk : version 1.4.2 SR9
<10.1.2 OH>/jdk64 : version 1.4.2 SR9 (64-bit)
<10.1.2 OH>/jre/1.4.2: version 1.4.2 SR1
<10.1.3 OH>/jdk: version 5 (1.5 SR7)
<10.1.3 OH>/jre/1.4.2: version 1.4.2 SR1
<10.1.3 OH>/appsutil/jdk: version 6 (1.6 SR2)
<$COMMON_TOP>/util/java: version 5 (1.5 SR2+)

The Database tier uses the following Java versions:

<11.1.0 OH>/jdk: version 5 (1.5 SR4, 1.5 SR10 for Power7 using startCD patch 12.1.1.13 or higher)
<11.1.0 OH>/appsutil/jre: version 6 (1.6 GA)*

*: used for Autoconfig on the Database tier

Additional Information: Check the IBM Web site for Java requirements for AIX on Power Systems:

http://www.ibm.com/developerworks/java/jdk/aix/service.html

Note: IBM Systems based on the latest Power 7 chip architecture has certain minimum requirements for JDK 1.4.2, 5 and 6 as outlined in:

https://www.ibm.com/developerworks/java/jdk/power7/index.html

Customers running E-Business Suite on Power 7 systems should upgrade their respective minor (SR) versions of the JDK in each of the JDK directories. Generally speaking, customers should not be upgrading an older version of the JDK in the E-Business Suite distribution to a later major version. One exception is the 10gR2 JDK - upgrading the <10.1.2 OH>/jdk from version 1.4.2 to 6 is now certified and recommended because of the approaching end of lifecycle support of JDK 1.4.2.

The E-Business Suite note that outlines the way to upgrade JDK versions in the appsutil directories and for the 10gR2 JDK is:

Using Latest Java 6.0 Update With Oracle E-Business Suite Release 12 (My Oracle Support Note 455492.1)

Required Filesets

The following table lists the required filesets for AIX on Power Systems.

Operating System	Required Filesets
AIX 7 (7.1)	xlC.aix61.rte:11.1.0.1 or later xlC.rte:11.1.0.1 or later
AIX 7 (7.1)	bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat bos.perf.perfstat bos.perf.proctools rsct.basic.rte rsct.compat.clients.rte X11.motif.lib

¹: Starting on May 1^st 2011, users must have upgraded their TL levels to versions that include versions 9.0.0.10 or higher (see My Oracle Support Note 1294357.1) prior to applying E-Business Suite patches.

Use the following command to check for existing filesets:

$ lslpp -l [fileset]

The state of the fileset should be 'COMMITTED'.

If any fileset is in an 'APPLIED' state, it is recommended that it be 'COMMITED' using smit or the following command:

$ installp -c [fileset]

Software Requirements

The following are software requirements for IBM AIX on Power Systems (64-bit).

Maintenance Tools

The following maintenance tools must be installed on all machines, and their locations specified both in the PATH of the account that runs Rapid Install and in the PATH of the accounts that will own the database tier and application tier file systems.

ar
ld
linkxlC
make
X Display Server

Install the IBM XL C/C++ Utilities package

The XL C/C++ Enterprise Edition for AIX Utilities is available from the IBM Web site for those who do not have a full version of the compiler installed. It's not a requirement to have a full compiler for use with EBS on AIX - the requirement is for the Utilities package containing a linker (linkxlC) which is distributed by IBM separately but is also part of the full compiler.

Prior to May 1st 2011, users were instructed to download and install the XL C/C++ utilities package (xlcpp.util.8.0.0) and any prerequisites.

AIX users should now download and install version 9.0 or 11.1 versions of the utility package or the corresponding versions of the full compiler if they so choose.

Note: Starting on May 1^st 2011, users must upgrade their TL levels to versions that include runtime versions 9.0.0.10 or higher and to use the versions 9.0 or 11.1 of the linker (either as part of the Utilities package or the full Compiler) prior to applying E-Business Suite patches.
Please review My Oracle Support Note 1294357.1 ('New Oracle E-Business Suite R12 Operating System and Tools Requirements on IBM AIX on Power Systems').

Other Requirements

The following are other requirements for AIX on Power Systems.

Patching Oracle E-Business Suite

Note: When querying for Oracle E-Business Suite Release 12 patches on My Oracle Support and selecting 'IBM AIX on Power Systems (64-bit)' in the Platform dropdown list, it will re-direct you to a patch with '5L' in its name. This patch may be applied to systems with AIX 5L and later versions such as AIX 6 and AIX 7.

ulimit Value Settings

Verify that the owner of the Oracle Application Server and Oracle Database server file systems have the following 'ulimit' values:

time (seconds) = unlimited
file (blocks) = unlimited
data (kbytes) = unlimited
stack (kbytes) = unlimited
memory (kbytes) = unlimited
coredump (blocks) = unlimited
nofiles (descriptors) = 65536

Use the following command to check the ulimit settings:

$ ulimit -a

Kernel Settings

The following table lists the kernel settings for AIX on Power Systems:

Note: Verify that the following kernel parameters are set either to the formula shown, or to values greater than or equal to the recommended value shown. Refer to your operating system documentation or contact your operating system vendor for more information on configuring kernel parameters.

Parameter	Value
Soft FILE size	-1 (unlimited)
Soft CPU time	-1 (unlimited)
Soft DATA segment	-1 (unlimited)
Soft STACK size	-1 (unlimited)
Soft NOFILE size	65536
Maximum number of PROCESSES allowed per user	2048
ARG_MAX	524288

Start "smitty" as the root user to verify or change the kernel settings:

$ /usr/bin/smitty

Host Names Settings

Verify that the /etc/hosts file is formatted as follows:

127.0.0.1 localhost.localdomain localhost

[ip_address] [node_name].[domain_name] [node_name]

Enable Asynchronous I/O (conditional)

Use the following steps to enable asynchronous I/O if you're on AIX 5L (asynchronous I/O is enabled by default on AIX 6 and 7):

Log in as the root user.
Enter the following command to verify whether asynchronous I/O services are running. If they are not, the command will start services:

# mkdev -l aio0

To ensure the services are configured with each system restart:

a. At the command prompt, enter the following:

# smit aio

b. Select the menu item: Change/Show Characteristics of Asynchronous I/O.

c. Change the field: "STATE to be configured at system restart" from DEFINED to AVAILABLE.

OPMN port conflict

Attention: By default, the OPMN service of the Application Server technology stack listens on port 6000 when started up during Rapid Install. This can conflict with the X11 port used for the graphics console on AIX servers and prevent Rapid Install from completing.

To address this issue, perform the following steps before installing or upgrading:

Check if the port 6000 is being used ("netstat -a | grep 6000")
If so, then you should disable the graphics console login process on the AIX server. This can be accomplished by logging in as the UNIX root user and issuing the following commands:

Shutdown the dtlogin process with the command "/usr/dt/bin/dtconfig -kill"
Confirm that nothing is listening at port 6000 ("netstat -a | grep 6000")
Disable the local X console for dtlogin with command "/usr/dt/bin/dtconfig -d"
Restart dtlogin with command "/usr/dt/bin/dtconfig -e"