author – a.kishore ://appsdba.info/docs/oracle_apps/sysadmin/...create user xxerp identified by...

10
Author – A.Kishore http://appsdba.info HOW TO INTEGRATE APPLICATIONS RELEASE 11i WITH CUSTOM APPLICATIONS Log into Applications as the System Administrator and navigate to Application Register. Connect as applmgr cd $APPL_TOP mkdir xxerp create structure as follows APPL_TOP ( /u02/oracle/visappl ) | XXERP_TOP ( /u02/oracle/visappl/xxerp/11.5.0 ) other product directories | --------------------------------------------------------------------------------- | | | | | | | | bin forms help lib log mesg out reports | | US US

Upload: others

Post on 18-Apr-2020

8 views

Category:

Documents


2 download

TRANSCRIPT

Page 1: Author – A.Kishore ://appsdba.info/docs/oracle_apps/sysadmin/...create user XXERP identified by XXERP default tablespace APPS_TS_TX_DATA temporary tablespace TEMP quota unlimited

Author – A.Kishore http://appsdba.info HOW TO INTEGRATE APPLICATIONS RELEASE 11i WITH CUSTOM APPLICATIONS

Log into Applications as the System Administrator and navigate to Application Register.

Connect as applmgr

cd $APPL_TOPmkdir xxerpcreate structure as follows

APPL_TOP ( /u02/oracle/visappl ) | XXERP_TOP ( /u02/oracle/visappl/xxerp/11.5.0 ) other product directories | --------------------------------------------------------------------------------- | | | | | | | | bin forms help lib log mesg out reports | | US US

Page 2: Author – A.Kishore ://appsdba.info/docs/oracle_apps/sysadmin/...create user XXERP identified by XXERP default tablespace APPS_TS_TX_DATA temporary tablespace TEMP quota unlimited

Author – A.Kishore http://appsdba.info

cd $APPL_TOPvi VIS_linuxerp.env

XXERP_TOP="/d01/oracle/visappl/xxerp/11.5.0"export XXERP_TOP

connect as system

create user XXERP identified by XXERP default tablespace APPS_TS_TX_DATA temporary tablespace TEMP quota unlimited on APPS_TS_TX_DATA quota unlimited on TEMP;

grant connect,resource to XXERP identified by XXERP;

Register the user with the Application Object Library. Log into Applications as the System Administrator and navigate to Security ORACLE Register.

Add the custom schema to a data group. Log into Applications as the System Administrator and navigate to Security ORACLE DataGroup.

Page 3: Author – A.Kishore ://appsdba.info/docs/oracle_apps/sysadmin/...create user XXERP identified by XXERP default tablespace APPS_TS_TX_DATA temporary tablespace TEMP quota unlimited

Author – A.Kishore http://appsdba.info

Cd $AU_TOP/forms/UScp TEMPLATE.fmb ERP.fmb

compile the form

f60gen userid=apps/epson module=ERP.fmb output_file=/d01/oracle/visappl/xxerp/11.5.0/forms/US/ERP.fmx module_type=form

Switch responsibility to Application Developer

Page 4: Author – A.Kishore ://appsdba.info/docs/oracle_apps/sysadmin/...create user XXERP identified by XXERP default tablespace APPS_TS_TX_DATA temporary tablespace TEMP quota unlimited

Author – A.Kishore http://appsdba.info

Make the form as part of the function

Page 5: Author – A.Kishore ://appsdba.info/docs/oracle_apps/sysadmin/...create user XXERP identified by XXERP default tablespace APPS_TS_TX_DATA temporary tablespace TEMP quota unlimited

Author – A.Kishore http://appsdba.info

Create the menu and attach the function

Page 6: Author – A.Kishore ://appsdba.info/docs/oracle_apps/sysadmin/...create user XXERP identified by XXERP default tablespace APPS_TS_TX_DATA temporary tablespace TEMP quota unlimited

Author – A.Kishore http://appsdba.info

Page 7: Author – A.Kishore ://appsdba.info/docs/oracle_apps/sysadmin/...create user XXERP identified by XXERP default tablespace APPS_TS_TX_DATA temporary tablespace TEMP quota unlimited

Author – A.Kishore http://appsdba.info

Page 8: Author – A.Kishore ://appsdba.info/docs/oracle_apps/sysadmin/...create user XXERP identified by XXERP default tablespace APPS_TS_TX_DATA temporary tablespace TEMP quota unlimited

Author – A.Kishore http://appsdba.info

Error

Page 9: Author – A.Kishore ://appsdba.info/docs/oracle_apps/sysadmin/...create user XXERP identified by XXERP default tablespace APPS_TS_TX_DATA temporary tablespace TEMP quota unlimited

Author – A.Kishore http://appsdba.info

Solution

Restart the forms server

Page 10: Author – A.Kishore ://appsdba.info/docs/oracle_apps/sysadmin/...create user XXERP identified by XXERP default tablespace APPS_TS_TX_DATA temporary tablespace TEMP quota unlimited

Author – A.Kishore http://appsdba.info