Forms Process (FRMWEB) Consumes 100% of CPU

1) First we had to update the context file on the application middle tier as follows:

s_forms_catchterm=0

2) Since the FORMS_RECORD_GROUP_MAX is not a default variable in the app tier context file, you need to create a custom template as follows.

cd $AD_TOP/admin/template
mkdir custom
cp $AD_TOP/admin/template/APPLSYS_ux.env $AD_TOP/template/custom/APPLSYS_ux.env

Edit the custom template file:

vi $AD_TOP/admin/template/custom/APPLSYS_ux.env

Set the environment variable FORMS_RECORD_GROUP_MAX to a high value such as 10000 or greater.

FORMS_RECORD_GROUP_MAX=10000
export FORMS_RECORD_GROUP_MAX

Save the file.

3)Run autoconfig utility for apps middle tier server.

4)Start app tier services and test.

Ref (Doc ID 745711.1)

How to re-Compile Invalid Objects (Package, Function, Procedure, View, Trigger)

Step 1. Create sql file as compile.sql in shell and content as below:

connect &1/&2

set pages 1000
set head off
set feedback off

spool compile1.sql
prompt set feedback on
select 'alter '||decode(object_type,'PACKAGE BODY',
    'PACKAGE',object_type)||' '||object_name||' '||
     decode(object_type,'PACKAGE BODY','compile body','compile')||';'
from user_objects
where status='INVALID'
/
spool off
@compile1.sql


Step 2. Login Oracle by sqlplus:

#sqlplus / as sysdba

Step 3. execute sql file:

> @compile.sql

HZ & HR Employee tables

1.PER_ALL_ASSIGNMENTS_F

2.PER_ALL_PEOPLE_F

1. HZ_PARTIES

2. HZ_ORGANIZATION_PROFILES

3. HZ_PERSON_PROFILES

4. HZ_CUSTOMER_PROFILES

5. HZ_LOCATIONS

6. HZ_PARTY_SITES

7. HZ_PARTY_SITE_USES

8. HZ_CUST_ACCOUNTS

9. HZ_CUST_ACCT_SITES

10. HZ_CUST_SITE_USES

11. HZ_CONTACT_POINTS

12. HZ_ORG_CONTACTS

13. HZ_ORG_CONTACT_ROLES

14. HZ_RELATIONSHIPS

15. HZ_CLASS_CATEGORIES

16. HZ_CLASS_CODE_DENORM

17. HZ_CODE_ASSIGNMENTS

18. HZ_CLASS_CATEGORY_USES

19. HZ_RELATIONSHIP_TYPES

PO_EMPLOYEE_HIERARCHIES_ALL

Sample for SQL Loader

Http://psoug.org/reference/sqlloader.html




Upload_Cylinder_Control.ctl

LOAD DATA

INFILE          'Upload_Cylinder.txt'
BADFILE         'Upload_Cylinder_BAD.bad'
DISCARDFILE 'Upload_Cylinder_DSC.dsc'

--REPLACE         -- delete the data before loading
APPEND

INTO TABLE cyl_cylinder_base_data
TRAILING NULLCOLS
( 
bot_no          TERMINATED BY ' ',
    cylnd_no        TERMINATED BY ' ',
    bot_head_spec    TERMINATED BY ' ',
    load_gas_id     INTEGER EXTERNAL TERMINATED BY ' ',
load_gas_ingred TERMINATED BY ' ',
    cylnd_mtspc      TERMINATED BY ' ',
    arv_dat         DATE "DD-Mon-YY" TERMINATED BY ' ',
    av_non_chg_gas  TERMINATED BY ' ',
    ast_no          TERMINATED BY ' ',
    kd              TERMINATED BY ' ',
    cylnd_inner_vol INTEGER EXTERNAL TERMINATED BY ' ',
    OPLT_DAT        DATE "DD-Mon-YY" TERMINATED BY ' ',
    ltm_isp_dat     DATE "DD-Mon-YY" TERMINATED BY ' ',
    lst_isp_dat     DATE "DD-Mon-YY" TERMINATED BY ' ',
    ast_ben          TERMINATED BY ' ',
    ast_ben_id      TERMINATED BY ' ',
    nr_tx_id        TERMINATED BY ' ',
    pressure_test    TERMINATED BY ' ',
    capqty          INTEGER EXTERNAL TERMINATED BY ' ',
fct_id TERMINATED BY ' ',
enable TERMINATED BY ' ',
place_loc_no TERMINATED BY ' ',
place_loc_id TERMINATED BY ' '
)

INTO TABLE cyl_cylnd_trans_d
TRAILING NULLCOLS
(
        TX_ID POSITION(148:151),
        TX_DAT POSITION(90:99) DATE "DD-Mon-YY",
        TX_CATE POSITION(100:101),
        TX_TO POSITION(144:147),
        TX_TO_CATE POSITION(142:143),
        GAS_ID POSITION(23:29),
        CYLND_NO POSITION(08:19),
        BOT_NO POSITION(01:07),
        DONE POSITION(100:101),
        FCT_ID POSITION(164:167)
)


SQLLDR_UploadCylinder_TEST.bat

@ECHO OFF
set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
SET /P yn=您確定要執行鋼瓶新購上傳到 TEST 的動作嗎？[y/n]：

IF %yn%==y GOTO yes
IF %yn%==Y GOTO yes
IF %yn%==n GOTO no
IF %yn%==N GOTO no

:no
ECHO 取消執行！！！
PAUSE
EXIT

:yes
SQLLDR apps/apps@mlgtpeerpt1.boclh.com.tw:1571/crp2 CONTROL=Upload_Cylinder_Control.ctl LOG=Upload_Cylinder_Log.log
::TYPE NULL > Upload_Cylinder.txt
ECHO 執行完成！！！
PAUSE

EXIT

Sample for Form Personalizations

How to enable the “Operating Unit” Parameter for a Concurrent Program