6 EBS Event Subscription Tasks

This chapter includes:

• EBS Event Subscription Setup

• EBS Event Subscription Install

EBS Event Subscription Setup

EBS raises the following oracle.apps.ap.supplier.event business event whenever there is a creation/modification of supplier, supplier sites, and supplier contacts.

1. Subscribe to the Supplier business event using Java subscription.

   1. Log in to EBS application using sysadmin.

   2. Navigate to Workflow Administrator Web Applications ->Administrator Workflow ->Business Events.

   3. Search for the oracle.apps.ap.supplier.event event and click Go.

   4. Click Subscription.

      Figure 6-1 Business Events screen

      
      

   5. Click Create Subscription.

   6. Enter the following details:

      • System - Select the System name using the LOV.

      • Source Type - Local

      • Event Filter - oracle.apps.ap.supplier.event

      • Phase - 71 (Any number less than 99)

      • Status - Enabled

      • Rule Data - Key

      • Action Type - Custom

      • On Error - Skip to Next

      • Click Next

      • Java Rule Function - com.oracle.retail.rfi.ebs.SupplierBES

      • Owner Name - Oracle Payables

      • Owner Tag - SQLAP

      Figure 6-2 Create Subscription

      
      

   7. Click Apply.

      Figure 6-3 Apply

      
      

      EBS raises the oracle.apps.gl.CurrencyConversionRates.dailyRate.specify business event whenever there is a creation/modification of Daily Currency Rates.

2. Subscribe to the Currency business event using Java subscription.

   1. Log in to EBS application using sysadmin.

   2. Navigate to Workflow Administrator Web Applications -> Administrator Workflow -> Business Events.

   3. Search for the oracle.apps.gl.CurrencyConversionRates.dailyRate.specify event and click Go.

   4. Click Subscription.

      Figure 6-4 Subscription

      
      

   5. Click Create Subscription.

   6. Enter the following details:

      • System - Select the System name using the LOV.

      • Source Type - Local

      • Event Filter - oracle.apps.gl.CurrencyConversionRates.dailyRate.specify

      • Phase - 70 (Any number less than 99)

      • Status - Enabled

      • Rule Data - Key

      • Action Type - Custom

      • On Error - Skip to Next

      • Click Next

      • Java Rule Function - com.oracle.retail.rfi.ebs.CurrencyRateBES

      • Owner Name - Oracle General Ledger

      • Owner Tag - SQLGL

      Figure 6-5 Create Subscription

      
      

   7. Click Apply.

      Figure 6-6 Apply

      
      

3. Verify that Status=ENABLED and the Licensed_flag=Y for the event and event subscription.

   • SELECT * FROM wf_events where name='<Event_Name>';

   • SELECT * from wf_event_subscriptions where event_filter_guid=(SELECT guid FROM wf_events where name='<Event_Name>);

EBS Event Subscription Install

1. Log in to the EBS UNIX server

2. From the ORFI server, copy the <INSTALL_DIR>/retail-financial-integration-solution/service-based-integration/target/ebs-side/rfi folder to a staging folder. This folder is referred to as EBS_COMP_DIR for the remainder of this document.

Install the Business Event Handler.

1. Log in to EBS UNIX server (telnet session) and run the env file (. ./apps.env).

   
   

   Note: If apps.env file is not available, please check the <Instance_name>_<Servername>.env file in folder <APPS INSTALLED FOLDER>/ apps_st/appl for the values of INST_TOP, ADMIN_SCRIPTS_HOME, APPL_CONFIG_HOME. JAVA_TOP folder is <APPS INSTALLED FOLDER>/apps_st/comn/java/classes For example: R12RET_rstnssiovm0050.env file in folder /u01/app/R12RET/apr12ret/applmgr/apps/apps_st/appl

   
   

2. Copy the ebs-side "rfi" folder from $EBS_COMP_DIR to $JAVA_TOP

   
   

   Note: The "rfi" folder is generated in the ORFI server $INSTALL_DIR/retail-financial-integration-solution/service-based-integration/target/ebs-side/

   
   

3. Go to the $INST_TOP/appl/admin/ folder

   cd $INST_TOP/appl/admin/
   

4. Edit <INSTANCE_SERVER>.xml (for example, R12RET_rstnssiovm0050.xml) file

   vi <INSTANCE_SERVER>.xml
   

5. Add the ebs-financial-common-<version>.jar and retail-public-security-api-<version>.jar to CLASSPATH and AF_CLASSPATH variables.

6. Add the retail-public-security-api-<version>.jar as the first entry in AF_CLASSPATH.

   
   

   Note: File locations used in the example are the absolute path and must be replaced to reflect the actual paths. Oracle recommends that you thoroughly review the example below and ensure that the order within the CLASSPATH and AF_CLASSPATH is maintained as described. This guidance assumes that you have already updated the version numbers of the .jar files to suit your environment.

   
   

   For example:

                           <CLASSPATH oa_var="s_adovar_classpath" osd="unix">/vol02/oracle/apsv1213/oracle/10.1.3/appsutil/jdk/lib/dt.jar:/vol02/oracle/apsv1213/oracle/10.1.3/appsutil/jdk/lib/tools.jar:/vol02/oracle/apsv1213/oracle/10.1.3/appsutil/jdk/jre/lib/rt.jar:/vol02/oracle/apsv1213/common/java/lib/appsborg.zip:/vol02/oracle/apsv1213/oracle/10.1.2/forms/java:/vol02/oracle/apsv1213/oracle/10.1.2/forms/java/frmall.jar:/vol02/oracle/apsv1213/oracle/10.1.2/jlib/ewt3.jar:/vol02/oracle/apsv1213/oracle/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar:/vol02/oracle/apsv1213/common/java/classes:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/commons-cli-1.2.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/commons-logging-1.1.1.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/groovy-all-2.1.2.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-api-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-internal-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-common-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-unsupported-api-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jacc-spi-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-ee-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-manifest-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-mbeans-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-upgrade-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-wls-11.1.1.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/identitystore-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/oraclepki-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/osdt_core-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/osdt_cert-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/sjsxp-1.0.2.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jsr173-1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/rfi-ebs-event-handler/ebs-financial-common-14.1.1.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/retail-public-security-api-14.0.0.jar</CLASSPATH><AF_CLASSPATH oa_var="s_adovar_afclasspath" osd="unix">/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/retail-public-security-api-14.0.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/commons-cli-1.2.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/commons-logging-1.1.1.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/groovy-all-2.1.2.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-api-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-internal-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-common-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-unsupported-api-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jacc-spi-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-ee-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-manifest-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-mbeans-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-upgrade-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jps-wls-11.1.1.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/identitystore-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/oraclepki-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/osdt_core-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/osdt_cert-11.1.1.1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/sjsxp-1.0.2.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/jsr173-1.0.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/rfi-ebs-event-handler/ebs-financial-common-14.1.1.jar:/vol02/oracle/apsv1213/oracle/10.1.3/appsutil/jdk/lib/dt.jar:/vol02/oracle/apsv1213/oracle/10.1.3/appsutil/jdk/lib/tools.jar:/vol02/oracle/apsv1213/oracle/10.1.3/appsutil/jdk/jre/lib/rt.jar:/vol02/oracle/apsv1213/common/java/lib/appsborg2.zip:/vol02/oracle/apsv1213/common/java/classes</AF_CLASSPATH>
   

7. Go to $ADMIN_SCRIPTS_HOME and run adautocfg.sh (Auto config).

   cd $ADMIN_SCRIPTS_HOME
   sh adautocfg.sh
   

8. Enter the APPS user password.

9. To verify the values, go to the $APPL_CONFIG_HOME/admin folder and check CLASSPATH and AF_CLASSPATH in adovars.env.

   cd $APPL_CONFIG_HOME/admin
   view adovars.env
   

10. Stop and restart Concurrent Manager.

    1. Go to $ADMIN_SCRIPTS_HOME

       cd $ADMIN_SCRIPTS_HOME
       

    2. Run sh adcmctl stop <db_user>/<db_password> (sh adcmctl.sh stop apps/**** )

    3. Make sure the Concurrent Manager is in "Not Active" status before running the next command. sh adcmctl status <db_user>/<db_password> (sh adcmctl.sh status apps/**** )

    4. Run sh adcmctl start <db_user>/<db_password> **** )

    5. Stop and restart the server

       sh adstpall.sh apps/****
       sh adstrtal.sh apps/****
       

       
       

       Note: If the Concurrent Manager is Not Active, start Concurrent Manager - sh adcmctl start apps/****

       
       

    6. Verify the values.

       1. Close the telnet session, start a new telnet session, and run the env file (. ./apps.env)

       2. echo $CLASSPATH and $AF_CLASSPATH The added jar file should be there.

11. Stop and restart the web server.

    Go to $ADMIN_SCRIPTS_HOME.

    adapcctl.sh stopall
    adapcctl.sh startall