유저생성 cbo_익스텐션유저등..

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/admin/driver

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/admin/sql

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/bin

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/forms/US

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/help/US

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/include

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/lib

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/log

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/mds/assetimpairment/webui

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/mds/attributesets

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/mds/iassets/webui

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/mds/migrationdata

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/mds/search/webui

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/mesg

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/out

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/patch/115/driver

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/patch/115/import/US

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/patch/115/irep/patch/115/import/US

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/patch/115/irep/patch/115/odf

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/patch/115/irep/patch/115/sql

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/patch/115/odf

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/patch/115/publisher/defs

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/patch/115/publisher/templates/US

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/patch/115/sql

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/patch/115/xdf

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/patch/115/xml/US

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/reports/US

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/sql

mkdir -p /app/dev/apps/apps_st/appl/xxgl/12.0.0/forms/src

CREATE TABLESPACE XXFA_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/XXFA_TS_TX_IDX01.dbf' SIZE 150M     autoextend on ;

CREATE TABLESPACE xxbom_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/xxbom_TS_TX_IDX01.dbf' SIZE 150M   autoextend on ;

CREATE TABLESPACE xxcmn_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/xxcmn_TS_TX_IDX01.dbf' SIZE 150M   autoextend on ;

CREATE TABLESPACE xxzx_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/xxzx_TS_TX_IDX01.dbf' SIZE 150M     autoextend on ;

CREATE TABLESPACE xxgl_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/xxgl_TS_TX_IDX01.dbf' SIZE 150M     autoextend on ;

CREATE TABLESPACE xxinv_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/xxinv_TS_TX_IDX01.dbf' SIZE 150M   autoextend on ;

CREATE TABLESPACE xxmrp_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/xxmrp_TS_TX_IDX01.dbf' SIZE 150M   autoextend on ;

CREATE TABLESPACE xxom_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/xxom_TS_TX_IDX01.dbf' SIZE 150M     autoextend on ;

CREATE TABLESPACE xxap_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/xxap_TS_TX_IDX01.dbf' SIZE 150M     autoextend on ;

CREATE TABLESPACE xxpje_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/xxpje_TS_TX_IDX01.dbf' SIZE 150M   autoextend on ;

CREATE TABLESPACE xxpjt_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/xxpjt_TS_TX_IDX01.dbf' SIZE 150M   autoextend on ;

CREATE TABLESPACE xxpa_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/xxpa_TS_TX_IDX01.dbf' SIZE 150M     autoextend on ;

CREATE TABLESPACE xxpo_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/xxpo_TS_TX_IDX01.dbf' SIZE 150M     autoextend on ;

CREATE TABLESPACE xxqa_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/xxqa_TS_TX_IDX01.dbf' SIZE 150M     autoextend on ;

CREATE TABLESPACE xxar_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/xxar_TS_TX_IDX01.dbf' SIZE 150M     autoextend on ;

CREATE TABLESPACE xxtr_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/xxtr_TS_TX_IDX01.dbf' SIZE 150M     autoextend on ;

CREATE TABLESPACE xxwip_TS_TX_IDX  DATAFILE '/stebs/DATA/oracrp2/xxwip_TS_TX_IDX01.dbf' SIZE 150M   autoextend on ;

CREATE USER cbo IDENTIFIED BY cbo  DEFAULT TABLESPACE APPS_TS_TX_DATA  

TEMPORARY TABLESPACE TEMP  QUOTA UNLIMITED ON APPS_TS_TX_DATA  QUOTA UNLIMITED ON APPS_TS_TX_IDX

PROFILE DEFAULT ACCOUNT UNLOCK ;

====================================================================================

select 'alter user '||username ||' QUOTA UNLIMITED ON '|| default_tablespace ||';' from dba_users where username like 'XX%' ; --참고

====================================================================================

GRANT ALTER ANY OUTLINE TO XXGL ;

GRANT ALTER ANY PROCEDURE TO XXGL ;

GRANT ALTER ANY TRIGGER TO XXGL ;

GRANT ALTER SESSION TO XXGL ;

GRANT ANALYZE ANY TO XXGL ;

GRANT APPS_CONNECT TO XXGL ;

GRANT CONNECT TO XXGL ;

GRANT CREATE ANY OUTLINE TO XXGL ;

GRANT CREATE ANY PROCEDURE TO XXGL ;

GRANT CREATE ANY TRIGGER TO XXGL ;

GRANT CREATE CLUSTER TO XXGL ;

GRANT CREATE DATABASE LINK TO XXGL ;

GRANT CREATE MATERIALIZED VIEW TO XXGL ;

GRANT CREATE SEQUENCE TO XXGL ;

GRANT CREATE SESSION TO XXGL ;

GRANT CREATE TABLE TO XXGL ;

--GRANT CREATE TRIGGER TO XXGL ;

GRANT CREATE TYPE TO XXGL ;

GRANT DROP ANY OUTLINE TO XXGL ;

GRANT DROP ANY PROCEDURE TO XXGL ;

GRANT DROP ANY TRIGGER TO XXGL ;

GRANT QUERY REWRITE TO XXGL ;

GRANT UNLIMITED TABLESPACE TO XXGL ;

제목: Function Not Available To Responsibility 

  문서 ID: 758772.1 유형:  PROBLEM 

  Modified Date:  11-FEB-2009 상태:  MODERATED 

In this Document

  Symptoms

  Cause

  Solution

  References

--------------------------------------------------------------------------------

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review. 

Applies to: 

Oracle Applications Technology Stack - Version: 12.0.0

This problem can occur on any platform.

Symptoms

When attempting to create a form in custom module $XXX_TOP ,the following error occurs:

"Function is not available for this responsibility.Contact your system

Administrator or change the responsibility"/ 

Cause

The path for custom module is not defined the file $ORA_CONFIG_HOME/10.1.2/forms/server/default.env .

 When forms is running in servlet mode in a standard configuration the file

$ORA_CONFIG_HOME/10.1.2/forms/server/default.env is read to determine the environment in which forms connnection are ran.

The location of the FMX files is determined by the value set for XXX_TOP. If this location is not found the error as seen is raised.

Solution

1.Submit the "Compile Security" Concurrent program with the parameter everything set to Yes to verify that all the menu functions are compiled properly.

2.Create your-own  AutoConfig template file 

     2.1 Define a product_top 

   Use the Oracle Applications Manager Context Editor to add your custom product_top to the context   file. Refer to the Help pages available in Oracle Applications Manager. The relevant information for adding custom context variables is located in the "System Configuration"> "AutoConfig"> "Manage Custom Parameters" section. Choose the variable type "PROD_TOP" when adding the product_top variable. The default value for the product_top variable must be set to '<s_at>/<product name>/12.0.0'. 

This will add the XXX_TOP to the <SID>.xml file, so it picked up when the default.env is created by Autoconfig

3.Run AutoConfig

4.Restart apps services

5.Retest.

================================================================================================

[###] /app/test> echo $ORA_CONFIG_HOME/10.1.2/forms/server/default.env

/app/test/inst/apps/MND_ebs1/ora/10.1.2/forms/server/default.env

XXGL_TOP=/app/test/apps/apps_st/appl/xxgl/12.0.0

XXAP_TOP=/app/test/apps/apps_st/appl/xxap/12.0.0

XXAR_TOP=/app/test/apps/apps_st/appl/xxar/12.0.0

XXFA_TOP=/app/test/apps/apps_st/appl/xxfa/12.0.0

XXXTR_TOP=/app/test/apps/apps_st/appl/xxxtr/12.0.0

XXZX_TOP=/app/test/apps/apps_st/appl/xxzx/12.0.0

XXCST_TOP=/app/test/apps/apps_st/appl/xxcst/12.0.0

XXINV_TOP=/app/test/apps/apps_st/appl/xxinv/12.0.0

XXPO_TOP=/app/test/apps/apps_st/appl/xxpo/12.0.0

XXPOS_TOP=/app/test/apps/apps_st/appl/xxpos/12.0.0

XXOE_TOP=/app/test/apps/apps_st/appl/xxoe/12.0.0

XXWSH_TOP=/app/test/apps/apps_st/appl/xxwsh/12.0.0

XXEM_TOP=/app/test/apps/apps_st/appl/xxem/12.0.0

XXBOM_TOP=/app/test/apps/apps_st/appl/xxbom/12.0.0

XXMSC_TOP=/app/test/apps/apps_st/appl/xxmsc/12.0.0

XXWIP_TOP=/app/test/apps/apps_st/appl/xxwip/12.0.0

XXQA_TOP=/app/test/apps/apps_st/appl/xxqa/12.0.0

XXIM_TOP=/app/test/apps/apps_st/appl/xxim/12.0.0

XXMND_TOP=/app/test/apps/apps_st/appl/mnd/12.0.0

[###] /app/test> echo $CONTEXT_FILE

/app/test/inst/apps/MND_ebs1/appl/admin/MND_ebs1.xml

<MND_TOP oa_var="s_mndtop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/mnd/12.0.0</MND_TOP>

 <XXGL_TOP oa_var="s_xxgltop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxgl/12.0.0</XXGL_TOP>

 <XXAP_TOP oa_var="s_xxaptop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxap/12.0.0</XXAP_TOP>

 <XXAR_TOP oa_var="s_xxartop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxar/12.0.0</XXAR_TOP>

 <XXFA_TOP oa_var="s_xxfatop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxfa/12.0.0</XXFA_TOP>

 <XXXTR_TOP oa_var="s_xxxtrtop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxxtr/12.0.0</XXXTR_TOP>

 <XXZX_TOP oa_var="s_xxzxtop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxzx/12.0.0</XXZX_TOP>

 <XXCST_TOP oa_var="s_xxcsttop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxcst/12.0.0</XXCST_TOP>

 <XXINV_TOP oa_var="s_xxinvtop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxinv/12.0.0</XXINV_TOP>

         <XXPO_TOP oa_var="s_xxpotop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxpo/12.0.0</XXPO_TOP>

         <XXPOS_TOP oa_var="s_xxpostop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxpos/12.0.0</XXPOS_TOP>

         <XXIM_TOP oa_var="s_xximtop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxim/12.0.0</XXIM_TOP>

         <XXOE_TOP oa_var="s_xxoetop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxoe/12.0.0</XXOE_TOP>

         <XXWSH_TOP oa_var="s_xxwshtop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxwsh/12.0.0</XXWSH_TOP>

         <XXEM_TOP oa_var="s_xxemtop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxem/12.0.0</XXEM_TOP>

         <XXBOM_TOP oa_var="s_xxbomtop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxbom/12.0.0</XXBOM_TOP>

         <XXMSC_TOP oa_var="s_xxmsctop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxmsc/12.0.0</XXMSC_TOP>

         <XXWIP_TOP oa_var="s_xxwiptop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxwip/12.0.0</XXWIP_TOP>

         <XXQA_TOP oa_var="s_xxqatop" oa_type="PROD_TOP" oa_enabled="TRUE">/app/test/apps/apps_st/appl/xxqa/12.0.0</XXQA_TOP>