Oracle® Retail Financial Integration for Oracle Retail Merchandise Operations Management and Oracle Financials Installation Guide Installation Guide Release 19.0.000 F25612-02 |
|
Previous |
Next |
This chapter includes:
EBS raises the following oracle.apps.ap.supplier.event business event whenever there is a creation/modification of supplier, supplier sites, and supplier contacts.
Subscribe to the Supplier business event using Java subscription.
Log in to EBS application using sysadmin.
Navigate to Workflow Administrator Web Applications ->Administrator Workflow ->Business Events.
Search for the oracle.apps.ap.supplier.event event and click Go.
Click Subscription.
Click Create Subscription.
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
Click Apply.
EBS raises the oracle.apps.gl.CurrencyConversionRates.dailyRate.specify business event whenever there is a creation/modification of Daily Currency Rates.
Subscribe to the Currency business event using Java subscription.
Log in to EBS application using sysadmin.
Navigate to Workflow Administrator Web Applications -> Administrator Workflow -> Business Events.
Search for the oracle.apps.gl.CurrencyConversionRates.dailyRate.specify event and click Go.
Click Subscription.
Click Create Subscription.
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
Click Apply.
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>);
Log in to the EBS UNIX server
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.
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/classesFor example: R12RET_rstnssiovm0050.env file in folder /u01/app/R12RET/apr12ret/applmgr/apps/apps_st/appl |
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/ |
Go to the $INST_TOP/appl/admin/ folder
cd $INST_TOP/appl/admin/
Edit <INSTANCE_SERVER>.xml (for example, R12RET_rstnssiovm0050.xml) file
vi <INSTANCE_SERVER>.xml
Add the ebs-financial-common-<version>.jar, retail-public-security-api-<version>.jar along with other dependent jars to CLASSPATH and AF_CLASSPATH variables (follow example from next step to add all the provided jars).
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-19.0.000.jar:/vol02/oracle/apsv1213/common/java/classes/rfi/retail-public-security-api/lib/retail-public-security-api-19.0.000.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-19.0.000.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-19.0.000.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>
Go to $ADMIN_SCRIPTS_HOME and run adautocfg.sh (Auto config).
cd $ADMIN_SCRIPTS_HOME sh adautocfg.sh
Enter the APPS user password.
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
Stop and restart Concurrent Manager.
Go to $ADMIN_SCRIPTS_HOME
cd $ADMIN_SCRIPTS_HOME
Run sh adcmctl stop <db_user>/<db_password> (sh adcmctl.sh stop apps/**** )
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/**** )
Run sh adcmctl start <db_user>/<db_password> **** )
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/**** |
Verify the values.
Close the telnet session, start a new telnet session, and run the env file (. ./apps.env)
echo $CLASSPATH and $AF_CLASSPATH The added jar file should be there.
Stop and restart the web server.
Go to $ADMIN_SCRIPTS_HOME.
adapcctl.sh stopall adapcctl.sh startall