Oracle® Application Integration Architecture Installation and Upgrade Guide for Pre-Built Integrations Release 11.3 Part Number E28316-03 |
|
|
PDF · Mobi · ePub |
This chapter discusses how to configure and deploy the Oracle Financial Operations Control Integration Pack for Oracle Retail Merchandise Operations Management and PeopleSoft Enterprise Financials (Financials Ops Control: Oracle Retail - PSFT PIP).
This chapter includes the following sections:
Section 29.3, "Configuring and Deploying the Financials Ops Control: Oracle Retail - PSFT PIP"
Section 29.6, "Undeploying the Financials Ops Control: Oracle Retail - PeopleSoft PIP"
To run AIA Pre-Built Integrations Installer you must have ODI access with Supervisor privileges.
For install purposes, the ODI software must reside at the same server where Foundation Pack is installed. Once the PIP installation is complete, the ODI Software can be installed into another server (if desired) connecting to the master and work repositories provided during the PIP installation.
If you decide to have ODI software running on a different server than Foundation Pack, after installing the PIP, you should copy the <aia_home>/config/AIAConfigurationProperties.xml file into that server, then modify the JDBC URL information for the AIA Configuration Properties DS Data Server in ODI to point to the new location of the AIAConfigurationProperties.xml
AIA Configuration Properties DS is located in the Physical Architecture tab in ODI topology. The JDBC URL is located under the JDBC tab.
For example, after installing you copied the file into Z:/Oracle/PIP/. Consider the following JDBC URL:
jdbc:snps:xml?f=D:/Oracle/FPAIAHOME/config/AIAConfigurationProperties.xml&s=AIACONFIGSCHEMA
Then update the path to the location of the file in the server where ODI software is running:
jdbc:snps:xml?f=Z:/Oracle/PIP/AIAConfigurationProperties.xml&s=AIACONFIGSCHEMA
For more information, see Notes on the Recommended Topology section for additional configurations for running ODI in a different server.
The ODI batch pieces of the Retail to PSFT PIP are designed to process extremely large transaction volumes. You must adjust and tune all databases accordingly particularly the rollback capability of the Retail (source) database. For this you must size the UNDO tablespace. For information on how to size the UNDO tablespace, see the OTN article at: http://www.oracle.com/technology/oramag/oracle/05-jul/o45tuning.html
You can use an existing master repository if it exists on an Oracle database. You need not create a new master repository.
You can use an existing work repository if it exists on an Oracle database and its ID is not 900. If its ID is 900, AIA advises you to create another repository and do not use 900 as Work Repository ID
When you run the DCW, it inserts/updates the PIP artifacts into these repositories.
AIA recommends that you take a backup of master and work repositories before you start the install process.
For information about creating Oracle Data Integrator Master and Work repositories, see Oracle Fusion Middleware Developer's Guide for Oracle Data Integrator, "Administering the Oracle Data Integrator Repositories."
Perform the following steps to apply the required patches to your ODI 11.1.1.5.0.
To install prerequisite installer patch #10288265:
Access My Oracle Support [https://support.oracle.com
]
Navigate to the Patches & Updates tab
In the Patch Name or Number field, write 10288265
Select your platform
Click Search
Download and install patch #10288265
Access My Oracle Support [https://support.oracle.com
]
Navigate to the Patches & Updates tab
In the Patch Name or Number field, write 12837214
Select your platform
Click Search
Download and install patch #12837214
After applying the patches, launch the ODI Installer:
Go to Topology.
Go to Physical Architecture.
Find the XML technologies and expand it.
You should see data sources for all DVM's used in your ODI flows.
Select each DVM data source.
Go to the JDBC tab.
Append this to the end of the URL "&back_compat_specific_keywords=true"
Test the data source to make sure the connection is successful.
Save your changes.
For a screenshot of this screen in ODI Installer, see Appendix B, "Oracle Data Integrator Screen".
The DCW screens prompt you to enter the data required for successful configuration of the Financials Ops Control: Oracle Retail - PSFT PIP. Enter the details of the Financials Ops Control: Oracle Retail - PSFT PIP screens below, take a printout and keep it ready when you run the DCW. This action enables faster and error free configuration.
Note:
Oracle Schema Names are in uppercase. Enter the schema names in uppercase in the DCW screens.
All artifacts associated with the PIP infrastructure components deploy to the PIP server. This screen contains the following fields:
Table 29-1 PIP Server Details Screen Fields
Field | Description |
---|---|
Admin Host Name |
Specifies the admin server resides. This can be a remote server or the same system where the AIA Pre-Built Integrations Installer is launched. Example: The Admin Host Name is _________________________________ |
Admin Port |
This is the port number on which the Weblogic Admin server is started. To find this value contact the WebLogic administrator. Example: The Admin Port is _____________________________________ |
Domain Name |
This is WebLogic server domain corresponding to the Admin Server. Example: The Domain Name is _______________________________ |
Admin User |
This value is the WebLogic admin user name. To find this value contact your WebLogic administrator. The Admin User is __________________________________ |
Admin Password |
This value is the WebLogic admin password. To find this value contact your WebLogic administrator. The password is _____________________________________ |
Managed Server |
After you enter the Admin Host Name, Admin Port and Admin User, this field populates with managed servers for the domain. Select the managed server from the list. If you are deploying the PIP to a SOA cluster, you should select the cluster name in this field. The Managed Server is _______________________________ |
Managed Port |
This field is automatically updated after you select the managed server. If you have configured a SOA Cluster, the SOA Cluster port appears in the list. |
Use this screen to enter details related to your PeopleSoft FSCM Web Services instance. These details are also used by the DrillBackForward service to:
Construct the URL for PSFT
Communicate with PSFT web service deployed at this location
The screen contains the following fields:
Table 29-2 PeopleSoft FSCM Web Services Details Screen Fields
Field | Description |
---|---|
Host Name |
This value is the host name for the web service provided by PeopleSoft. To find this value, contact PeopleSoft system administrator. Example: PeopleSoft FSCM Web Services Host Name is _________________________________ |
Port Number |
This value is the port for the web service provided by PeopleSoft. To find this value, contact the PeopleSoft system administrator. Example: PeopleSoft FSCM Web Services Port Number is _______________________________ |
Default Local Node |
This value is the default local node for the specific instance of PeopleSoft. This value is unique to the instance of PeopleSoft and enables the PeopleSoft Gateway to identify the application server to which it should route the web service request. Example: PeopleSoft FSCM Web Services Default Local Node is _______________________________ |
Use this screen to enter details related to PeopleSoft FSCM Application URL. These details are used by the DrillBackForward service to construct PSFT application URL.
The screen contains the following fields:
Table 29-3 PeopleSoft FSCM Application URL Details Screen Fields
Field | Description |
---|---|
Servlet |
This value is the name of the PeopleSoft FSCM Application Servlet. To find this value, contact the PeopleSoft system administrator. Example: PeopleSoft FSCM Application Servlet name is _____________________________________ |
Site |
This value is the Site name of the PeopleSoft FSCM application. To find this value, contact the PeopleSoft system administrator. Example: PeopleSoft FSCM Application Site name is _________________________________________ |
Portal,Node,Content |
This value is the Portal, Node, Content for the PeopleSoft FSCM Application. To find this value, contact the PeopleSoft system administrator. Enter this information in this format: <portal>/<node>/<content>Example: The Portal, Node, Content for the PeopleSoft FSCM Application is ______________________ |
Use this screen to enter details related to your PeopleSoft FSCM database connection instance.
The screen contains the following fields:
Table 29-4 PeopleSoft FSCM Database Connection Details Screen Fields
Field | Description |
---|---|
Database Type |
This value is the database type being used by the PeopleSoft Financials system. To find this value, contact the database administrator. Example: PeopleSoft Financials system Database Type is ____________________________. |
Database Host Name |
This value is the PeopleSoft database host name. To find this value, contact the database administrator. Example: PeopleSoft Financials system Database Host Name is ____________________________. |
Database Port Number |
This value is the PeopleSoft database host name. To find this value, contact the database administrator. Example: PeopleSoft Financials system Database Port Number is ____________________________. |
SID (System ID) |
To find this value, contact the database administrator. Example: PeopleSoft Financials system SID is ____________________________. |
Database Username |
To find this value, contact the database administrator. Example: PeopleSoft Financials system Database Username is ____________________________. |
Database Password |
To find this value, contact the database administrator. Example: PeopleSoft Financials system Database Password is ____________________________. |
Database Schema |
Usually, this value equals the Database user name. However, if the database user name uses synonymous schema to access the actual tables, provide the schema name that owns the tables. This value is the PeopleSoft database schema. To find this value, contact the database administrator. Example: PeopleSoft Financials system Database Schema is ____________________________. |
Use this screen to enter details related to your Oracle Retail Service Layer connection database instance. These details are also used by the DrillBackForward service to communicate with Retail service.
The screen contains the following fields:
Table 29-5 Oracle Retail Service Layer Connection Details Screen Fields
Field | Description |
---|---|
Host Name |
This value is the host name for the web services provided by Retail. To find this value, contact the Retail system administrator. Example: Host Name is ___________________________ |
Port Number |
This value is the port for the web services provided by Retail. To find this value, contact the Retail system administrator. Example: Port Number is __________________________ |
Use this screen to enter details related to your Oracle Retail Integration Bus connection database instance.
The screen contains the following fields:
Table 29-6 Oracle Retail Integration Bus Connection Details Screen Fields
Field | Description |
---|---|
Database Host Name |
This value is the database host name for the Retail Integration Bus (RIB) database connection. To find this value, contact the Retail database administrator. Example: Oracle Retail Integration Bus Database Host Name is ______________________________. |
Database Port Number |
This value is the database port number for the RIB database connection. To find this value, contact the Retail database administrator. Example: Oracle Retail Integration Bus Database Port Number is ______________________________. |
Database SID |
This value is the database system ID for the RIB database connection. To find this value, contact the Retail database administrator. Example: Oracle Retail Integration Bus Database SID is ______________________________. |
Database Username |
This value is the database user name for the RIB database connection. To find this value, contact the Retail database administrator. Example: Oracle Retail Integration Bus Database Username is ______________________________. |
Database Password |
This value is the database password for the RIB database connection. To find this value, contact the Retail database administrator. Example: Oracle Retail Integration Bus Database Host Name is ______________________________. |
Use this screen to enter details related to your Oracle Retail database connection instance.
The screen contains the following fields:
Table 29-7 Oracle Retail Database Connection Details Screen Fields
Field | Description |
---|---|
Database Host Name |
To find this value, contact the database administrator. Example Oracle Retail Database Host Name is______________________ |
Database Port Number |
To find this value, contact the database administrator. Example: Oracle Retail Database is Port Number ____________________ |
Database SID |
To find this value, contact the database administrator. Example Oracle Retail Database SID is ________________________ |
Database Username |
To find this value, contact the database administrator. Example: Oracle Retail Database Username is ______________________ |
Database Password |
To find this value, contact the database administrator. Example: Oracle Retail Database Password is ___________________ |
Database Schema |
Usually, this value equals the Database user name. However, if the database user name uses synonymous schema to access the actual tables, provide the schema name that owns the tables. To find this value, contact the database administrator. Example: Oracle Retail Database Schema is ___________________ |
Use this screen to enter details to access Oracle Data Integrator. The screen contains the following fields:
Table 29-8 Oracle Data Integrator Access Details Screen Fields
Field | Description |
---|---|
Path to Oracle Data Integrator |
Provide the path to the ODI HOME up to the agent folder (included). To find this value, contact your administrator. Example: Oracle Data Integrator Path is _________________________________________ |
ODI User |
To find this value, contact your administrator. Example: Oracle Data Integrator User is _________________________________________ |
ODI Password |
To find this value, contact your administrator. Example: Oracle Data Integrator Password is ______________ |
Path for exported DVMs |
Enter the path to directory to export Domain Value Mappings (DVM). Example: One of the steps for setting up the PIP is to export some DVMs to a location. The Installer must have this location to configure ODI artifacts during the install. It is recommended to choose this location in the same server where ODI software runs. Path for Exported DVM is _______________________ |
You must set up an ODI Master Repository before installing the Financials Ops Control: Oracle Retail - PSFT PIP. This master repository must be created in an Oracle database. The install process appends PIP artifacts into this master repository.
Use this screen to enter details to access the Oracle Data Integrator Master Repository.
The screen contains the following fields:
Table 29-9 Oracle Data Integrator Master Repository Details Screen Fields
Field | Description |
---|---|
Database Host Name |
To find this value, contact your database administrator. Example: Oracle Database Integrator Master Repository Database Host Name is _________________ |
Database Port Number |
To find this value, contact your database administrator. Example: Oracle Database Integrator Master Repository Database Port Number is_________________ |
Database SID |
To find this value, contact your database administrator. Example: Oracle Database Integrator Master Repository Database SID is _________________ |
Database Username |
To find this value, contact your database administrator. Example: Oracle Database Integrator Master Repository Database Username is _________________ |
Database Password |
To find this value, contact your database administrator. Example: Oracle Database Integrator Master Repository Database Password is _________________ |
The install process imports the Retail to PeopleSoft Financials ODI artifacts into an ODI Work repository. You can provide an existing ODI Work Repository or provide an empty one. It is recommended to use an empty repository.
Use this screen to enter details related to the ODI Work Repository.
The screen contains the following fields:
Table 29-10 Oracle Data Integrator Work Repository for Retail to PeopleSoft Financials PIP Details Screen Fields
Field | Description |
---|---|
ODI Work Repository Name |
Enter the name you gave to the ODI Work Repository for PIP Artifacts. Example: ODI Work Repository Name is: _________________________ |
ODI Work Repository ID |
Enter the ID number that you used for the ODI Work Repository. It should be between 1 and 899. Example: Do not use 900. Also do not use the ID used for other work repositories. ODI Work Repository ID is: ______________ |
This section discusses the PIP configuration and deployment process. There are two steps:
Configure your PIP using the deployment DCW.
Deploy the PIP to the Fusion Middleware server.
The screens that appear prompt you to enter the data that is required for successful configuration of the Financials Ops Control: Oracle Retail - PSFT PIP. Keep the completed worksheets of the Financials Ops Control: Oracle Retail - PSFT PIP screens ready before you launch the DCW.
Note:
If you are harvesting content to OER, perform the first three steps. If not, start from step 4.
To configure the Financials Ops Control: Oracle Retail - PSFT PIP:
Navigate to /slot/emsxxxx/oracle/Middleware/user_projects/domains/soa_domain/bin/ and open setDomainEnv.sh for Linux based systems and setDomainEnv.bat for Microsoft Windows.
Replace WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=false" with WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=true".
Restart the server.
Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh
for Linux based systems and aiaenv.bat
for Microsoft Windows to configure the environment.
Navigate to <AIA_HOME>/bin and run the command ./aiaconfig.sh
for Linux based systems and aiaconfig.bat
for Microsoft Windows.
This launches the AIA DCW.
Click Next.
Select the Financials Ops Control: Oracle Retail - PSFT PIP
Click Next.
To specify PIP Server details:
Enter information related to your PIP server in the PIP Server Details screen.
Click Next.
To specify PeopleSoft FSCM Web Services details:
Enter information about your PeopleSoft FSCM Web Services installation in the PeopleSoft FSCM Web Services Information screen.
Click Next.
To specify PeopleSoft FSCM Application URL details:
Enter information about your PeopleSoft FSCM Web Application URL in the PeopleSoft FSCM Application URL screen.
Click Next.
To specify PeopleSoft FSCM Database Connection details:
Enter information about your PeopleSoft FSCM Database Connection installation in the PeopleSoft FSCM Database Connection Information screen.
Click Next.
To specify Oracle Retail Service Layer Connection details:
Enter information about your Oracle Retail Service Layer Connection installation in the Oracle Retail Service Layer Connection Information screen.
Click Next.
To specify Oracle Retail Integration Bus Connection details:
Enter information about your Oracle Retail Integration Bus Connection installation in the Oracle Retail Integration Bus Connection Information screen.
Click Next.
To specify Oracle Retail Database Connection details:
Enter information about your Oracle Retail Database Connection installation in the Oracle Retail Database Connection Information screen.
Click Next.
To specify Oracle Data Integrator Access details:
Enter information about your Oracle Data Integrator Access installation in the Oracle Data Integrator Access Information screens.
Oracle Data Integration Access Information is captured in three screens. Enter the following information in the screens.
Specify ODI Home.
Click Next.
Enter ODI User and ODI Password.
Click Next.
Specify the Path for exported DVMs.
Click Next.
To specify Oracle Data Integrator Master Repository details:
Enter information about your Oracle Data Integrator Master Repository installation in the Oracle Data Integrator Master Repository screen.
Click Next.
To specify Oracle Data Integrator Work Repository details:
Enter information about your Oracle Data Integrator Work Repository installation in the Oracle Data Integrator Work Repository for Retails to PeopleSoft Financials screen.
Click Next.
Review the configuration information on the Configuration Summary screen.
Note:
If you want to make changes to the configuration, use the navigation pane on the left and select the screen you want to edit.
You can create a response file based on the input provided in the DCW and use it in future when you want to deploy the PIP. You can configure using the steps described in Section 29.3.2, "Configuring using the Response File". Click Save Response File and save the response file with the name and location of your choice.
Click Configure to accept the configuration.
The system displays progress of the configuration in the Configuration Progress screen.
The system displays any warnings or errors as necessary. You can review the configuration log for additional details. The configuration log location is displayed in Configuration Progress screen.
When the configuration process completes without errors, the AIA DCW displays the Configuration Complete screen.
Click Finish to close the DCW.
To configure using the response file:
Open the response file.
When you create a response file through OUI, passwords get stored as <SECURE>.
Replace the password fields with actual passwords in the response file.
Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh
for Linux based systems and aiaenv.bat
for Microsoft Windows to configure the environment.
Navigate to <AIA_HOME>/bin and run the command ./aiaconfig.sh <Response File Location and Name>
for Linux based systems and aiaconfig.bat <Response File Location and Name>
for Microsoft Windows.
To deploy the PIP to Fusion Middleware server:
Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh
for Linux based systems and aiaenv.bat
for Microsoft Windows to configure the environment.
Run the command for your platform
Note:
When you copy and paste the command in the command line, ensure that there is space between .xml
and -
. Ensure that there is space between these two when you run undeployment command too.
Table 29-11 Deployment Commands for the Financials Ops Control: Oracle Retail - PSFT PIP
Platform | Deployment Command |
---|---|
Linux Solaris SPARC IBM AIX Based Systems. HP-UX |
ant -f <AIA_HOME>/Infrastructure/Install/AID/AIAInstallDriver.xml -DDeploymentPlan=<AIA_HOME>/pips/OracleRetailToPeopleSoftFinancials/DeploymentPlans/OracleRetailToPeopleSoftFinancialsDP.xml -DPropertiesFile=<AIA_HOME>/aia_instances/<AIA_Instance>/config/AIAInstallProperties.xml -DDeploymentPolicyFile=<AIA_HOME>/pips/OracleRetailToPeopleSoftFinancials/DeploymentPlans/OracleRetailToPeopleSoftFinancialsConditionalPolicy.xml -DSupplementaryDeploymentPlan=<AIA_HOME>/pips/OracleRetailToPeopleSoftFinancials/DeploymentPlans/OracleRetailToPeopleSoftFinancialsSupplementaryDP.xml -l <AIA_HOME>/pips/OracleRetailToPeopleSoftFinancials/DeploymentPlans/OracleRetailToPeopleSoftFinancialsDP.log |
Microsoft Windows |
ant -f <AIA_HOME>\Infrastructure\Install\AID\AIAInstallDriver.xml -DDeploymentPlan=<AIA_HOME>\pips\OracleRetailToPeopleSoftFinancials\DeploymentPlans\OracleRetailToPeopleSoftFinancialsDP.xml -DPropertiesFile=<AIA_HOME>\aia_instances\<AIA_Instance>\config\AIAInstallProperties.xml -DDeploymentPolicyFile=<AIA_HOME>\pips\OracleRetailToPeopleSoftFinancials\DeploymentPlans\OracleRetailToPeopleSoftFinancialsConditionalPolicy.xml -DSupplementaryDeploymentPlan=<AIA_HOME>\pips\OracleRetailToPeopleSoftFinancials\DeploymentPlans\OracleRetailToPeopleSoftFinancialsSupplementaryDP.xml -l <AIA_HOME>\pips\OracleRetailToPeopleSoftFinancials\DeploymentPlans\OracleRetailToPeopleSoftFinancialsDP.log |
Note:
In Windows 2008, 2008 R2 and Vista, run the command prompt as an administrator (elevated mode). If the command prompt is invoked in normal mode, the PIPs are not displayed.
Review the log file in the location specified in the command to verify successful deployment.
Oracle AIA ships artifacts in AIA Lifecycle Workbench which can be used in your integrations. These artifacts are created using FMW technologies such as BPEL and Mediator and are natively supported by AIA Foundation Pack tools such as Project Lifecycle Workbench, Harvester, Deployment Generator, AIA Deployment Driver (ADD). These are called native artifacts and they include SOA artifact types such as composites, DataSources, DVM, xRef, and so on. These artifacts can be modified or new natively supported artifacts can be added using the AIA Lifecyle Workbench and a BOM.xml file can be generated.
AIA PIP development teams, most often, also require deployment of artifact types that are beyond what is supported by the Project Lifecycle Workbench and AIA Harvester. For instance, integration may require artifacts such as, Java applications, Shell Scripts, ANT based build scripts which constitute part of integration landscape in addition to the artifacts that are delivered by AIA. AIA also supports deployment of these supplementary artifacts. However, you must modify and add new non native artifacts outside AIA Lifecycle Workbench.
For more information on deploying artifacts, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Generating Deployment Plans and Deploying Artifacts".
This section discusses the following postdeployment configurations for the Financials Ops Control: Oracle Retail - PSFT PIP:
Section 29.4.1, "Configuring Retail to PeopleSoft Accounting Entries Integration"
Section 29.4.2, "Configuring Retail to PeopleSoft Invoice/Voucher Integration"
Section 29.4.4, "Creating Sequence Rights to PeopleSoft Database User (Required)"
Section 29.4.5, "Verifying the Database Connection (Optional)"
Section 29.4.6, "Setting Up and Exporting Domain Value Mappings (Required)"
Section 29.4.7, "Setting Up ORGANIZATION_ID XREF (Required)"
The Retail to PeopleSoft_AccountingEntry ODI Integration can be configured to send emails to an individual when a successful transaction occurs.
To send emails to individuals on successful transaction:
Edit the AIAConfigurationProperties.xml file located in AIA_HOME/config.
Set the polling interval.
<Property name="PollingInterval">300000</Property>
The ODI process has a polling interval, which is the time period (in milliseconds) the process waits before polling tables for new data. This polling interval can be changed as required.
Modify the property name:
Enter the email ID of the recipient in the ToMailAddress section to specify the person to receive the email messages.
Enter the email ID of the sender in the FromMailAddress section.
This value is required by the email process to send the email. Oracle AIA recommends that FromMailAddress and ToMailAddress to prevent the recipient from receiving two emails for the same successful process.
Enter the name of the mail server in the MailServerName section to specify the mail server.
After you modify the AIAConfigurationProperties.xml file, update the MDS with the information.
To update SOA-MDS, apps/AIAMetaData:
Browse to the folder at $AIA_HOME/aia_instances/$INSTANCE_NAME/bin.
Execute source aiaenv.sh
and source the file aiaenv.sh.
Browse to the folder at $AIA_HOME/aia_instances/$INSTANCE_NAME/config and open UpdateMetaDataDP.xml.
Update the file UpdateMetaDataDP.xml. To add resource groups to the MDS insert the include tags.
To upload all the files under "AIAMetaData", add <include name ="AIAMetadata/**"/>
To upload the files copied to AIAComponents/ApplicationObjectLibrary/SEBL/schemas folder, add <include name ="AIAComponents/ApplicationObjectLibrary/SEBL/schemas/**"/>
Note:
In the include tag, the folder path must be relative to the folder AIAMetaData.
Browse to AIA_HOME/Infrastructure/Install/scripts.
Execute ant -f UpdateMetaData.xml to update MDS.
The Retail to PeopleSoft Invoice ODI Integration can be configured to send emails to an individual when a successful transaction occurs.
To send emails to individuals on successful transaction:
Edit the AIAConfigurationProperties.xml file located in AIA_HOME/config.
Set the polling interval.
<Property name="PollingInterval">300000</Property>
The ODI process has a polling interval, which is the time period (in milliseconds) the process waits before polling tables for new data. This polling interval can be changed as required.
Modify the property name:
Enter the email ID of the recipient in the ToMailAddress section to specify the person to receive the email messages.
Enter the email ID of the sender in the FromMailAddress section.
This value is required by the email process to send the email. Oracle AIA recommends that FromMailAddress and ToMailAddress to prevent the recipient from receiving two emails for the same successful process.\
Enter the name of the mail server in the MailServerName section to specify the mail server.
In addition to the above modules, you can perform postdeployment configuration for the following services:
CreatePaymentTermPeopleSoftReqABCSImpl
CreatePaymentTermRetailProvProvABCSImpl
CreateSupplierPartyListPeopleSoftReqABCSImpl
CreateSupplierPartyRetailProvProvABCSImpl
DrillBackForward
ProcessGLAccountValidationPeopleSoftProvABCSImpl
ProcessGLAccountValidationRetailReqABCSImpl
SyncCurrencyExchangeListPeopleSoftReqABCSImpl
SyncCurrencyExchangeListRetailProvProvABCSImpl
SyncPaymentTermListPeopleSoftReqABCSImpl
SyncSupplierPartyListPeopleSoftReqABCSImpl
SyncSupplierPartyListRetailProvProvABCSImpl
UpdatePaymentTermPeopleSoftReqABCSImpl
UpdatePaymentTermRetailProvProvABCSImpl
UpdateSupplierPartyListPeopleSoftReqABCSImpl
UpdateSupplierPartyRetailProvProvABCSImpl
For more information on how to configure these services, see the Oracle Application Integration Architecture Oracle Financial Operations Control Integration Pack Implementation Guide for Oracle Retail Merchandise Operations Management and PeopleSoft Enterprise Financials.
The ODI processes create a database sequence in PeopleSoft database. Ensure that the database user for the PeopleSoft database has appropriate rights to create sequences.
To verify the database connection:
Open ODI Topology Manager.
Expand Oracle in Physical Architecture tab.
Select AIA SCHEMA DS.
Right click and select Edit to open AIA SCHEMA DS.
Click Test.
This opens Test Connection window.
Click Test.
If successful connection message does not appear, verify the connection information in the Definitions and JDBC tabs.
Repeat steps 1 to 6 for the following data sources:
ORACLE RETAIL DS
PEOPLESOFT DS
Note:
If PeopleSoft is under IBM DB2, the data source is under IBM DB2 UDB technology.
You must set up and export Domain Value Maps (DVM) to complete the install process.
Set up all DVMs for the PIP.
Export the following DVMs:
BUSINESS_UNIT
CURRENCY_CODE
CHARTOFACCOUNTS_GLELEMENT
During installation, AIA Pre-Built Integrations Installer prompts you to specify a folder in your local file system to store the exported DVMs files. Export the following DVMs to that folder:
BUSINESS_UNIT
CURRENCY_CODE DVMs
And export the CHARTOFACCOUNTS_GLELEMENT DVM to the <AIA_HOME>/services/core/BulkDataProcess/OracleRetailToPeopleSoft/Financials/CreateRetailViewSQL folder. When exporting this dvm, change the name to CHARTOFACCOUNTS_GLELEMENT.xml, instead of CHARTOFACCOUNTS_GLELEMENT.dvm.
For more information on how to set up DVMs, see Oracle Application Integration Architecture Oracle Financial Operations Control Integration Pack Implementation Guide for Oracle Retail Merchandise Operations Management and PeopleSoft Enterprise Financials, "Describing Domain Value Maps", Implementing Oracle Retail to PeopleSoft Financials Process Integration Pack.
For information about how to set up the ORGANIZATION_ID XREF, see Oracle Application Integration Architecture Oracle Financial Operations Control Integration Pack Implementation Guide for Oracle Retail Merchandise Operations Management and PeopleSoft Enterprise Financials, "Implementing Oracle Retail Merchandising Integration Pack for PeopleSoft Enterprise Financials, " Setting Up Cross-References for Oracle Retail IDs and PeopleSoft Entities.
To verify the Financials Ops Control: Oracle Retail - PSFT PIP deployment:
Open the log files from the following location and look for warnings and error messages:
For Linux, Solaris SPARC, HP-UX and IBM AIX Based Systems: Review the install log located at <AIA_HOME>/aia_instances/<instance name>/logs to verify that the PIP is successfully installed.
For Microsoft Windows: Review the install log located at <AIA_HOME>\logs\Install\PIPS\<PIPName>Install-${current.time}.log to verify that the PIP is successfully installed.
Verify that you can see the following Financials Ops Control: Oracle Retail - PSFT PIP services were installed.
Navigate to the Oracle Enterprise Manager Fusion Middleware Control: (http://<server name>:<port number>/em/).
Log in with the server admin user name. For access details, contact the system administrator.
Expand Farm_soa_domain, SOA, soa-infra, Default and look for the following items:
ChartOfAccountsEBS
CreatePaymentTermPeopleSoftReqABCSImpl
CreatePaymentTermRetailProvABCSImpl
CreateSupplierPartyPeopleSoftReqABCSImpl
CreateSupplierPartyRetailProvABCSImpl
CurrencyExchangeEBS
CurrencyExchangePeopleSoftJMSConsumer
PaymentTermEBS
PaymentTermPeopleSoftJMSConsumer
ProcessGLAccountValidationPeopleSoftProvABCSImpl
ProcessGLAccountValidationRetailReqABCSImpl
SupplierPartyEBS
SupplierPartyPeopleSoftJMSConsumer
SyncCurrencyExchangeListPeopleSoftReqABCSImpl
SyncCurrencyExchangeListRetailProvJMSProducer
SyncPaymentTermListPeopleSoftReqABCSImpl
SyncPaymentTermListRetailProvABCSImpl
SyncSupplierPartyListPeopleSoftReqABCSImpl
SyncSupplierPartyListRetailProvABCSImpl
UpdatePaymentTermPeopleSoftReqABCSImpl
UpdatePaymentTermRetailProvABCSImpl
UpdateSupplierPartyPeopleSoftReqABCSImpl
UpdateSupplierPartyRetailProvABCSImpl
Confirm that the Financials Ops Control: Oracle Retail - PSFT PIP queues (JMS) are installed.
To verify the JMS Queues, connect to the WLS Console http:<host>:<port>/console.
Navigate to Services, Messaging, JMS Modules, AIAJMSModule.
Drill down and verify that the following queues exist:
AIA_PeopleSoftCurrencyExchangeJMSQueue.
AIA_PeopleSoftPaymentTermsJMSQueue.
AIA_PeopleSoftSupplierPartyJMSQueue.
Confirm that the DrillBackForward web service is installed:
Navigate to the Application Server Console: http://<server name>:<port number>/em.
Select the Application Server Control option.
Log in with the server administrator user name. To find this information, contact the system administrator.
Navigate to Farm_SOA_Domain, Application Deployments.
Verify that in the Web Services tab, the GetDrillBackForwardURL web service is available with port name DrillBackForwardURLService.
Confirm that necessary configuration properties exist.
Navigate to the AIA home location. For example, http://<host_name>:<port>/AIA/faces/home.jspx
Navigate to Setup, Configuration and check for the following configuration properties:
CreatePaymentTermPeopleSoftReqABCSImpl
CreatePaymentTermRetailProvABCSImpl
CreateSupplierPartyPeopleSoftReqABCSImpl
CreateSupplierPartyRetailProvABCSImpl
ProcessGLAccountValidationPeopleSoftProvABCSImpl
ProcessGLAccountValidationRetailReqABCSImpl
SyncCurrencyExchangeListPeopleSoftReqABCSImpl
SyncCurrencyExchangeListRetailProvABCSImpl
SyncPaymentTermListPeopleSoftReqABCSImpl
SyncPaymentTermListRetailProvABCSImpl
SyncSupplierPartyListPeopleSoftReqABCSImpl
SyncSupplierPartyListRetailProvABCSImpl
UpdatePaymentTermPeopleSoftReqABCSImpl
UpdatePaymentTermRetailProvABCSImpl
UpdateSupplierPartyPeopleSoftReqABCSImpl
UpdateSupplierPartyRetailProvABCSImpl
Verify Integration Scenarios.
Navigate to the AIA home location. For example, http://<host_name>:<port>/AIA/faces/home.jspx
Find Project Lifecycle Workbench and click Go.
On the AIA Project Lifecycle Workbench page, click Search.
Click the link in the Bill Of Material column to view the following artifacts included in this PIP.
Create PaymentTerm PeopleSoft Requestor
Create PaymentTerm Retail Provider
Create SupplierParty PeopleSoft Requestor
Create SupplierParty Retail Provider
Process GL Account Validation PeopleSoft Provider
Process GL Account Validation Retail Requestor
ProcessGLAccountValidationRetailReqABCSImpl
Sync CurrencyExchangeList PeopleSoft Requestor
Sync CurrencyExchangeList Retail Provider
Sync PaymentTerm PeopleSoft Requestor
Sync PaymentTerm Retail Provider
Sync SupplierParty PeopleSoft Requestor
Sync SupplierParty Retail Provider
Update PaymentTerm PeopleSoft Requestor
Update PaymentTerm Retail Provider
Update SupplierParty PeopleSoft Requestor
Update SupplierParty Retail Provider
Verify that 32 ABCSs have been published.
Navigate to the AIA home location. For example, http://<host_name>:<port>/AIA/faces/home.jspx
Navigate to Service Repository, type %ABCS%
in the Service Name field and click Search.
CreatePaymentTermPeopleSoftReqABCSImpl
CreatePaymentTermPeopleSoftReqABCSImplExt
CreatePaymentTermRetailProvABCSImpl
CreatePaymentTermRetailProvABCSImplExt
CreateSupplierPartyPeopleSoftReqABCSImpl
CreateSupplierPartyPeopleSoftReqABCSImplExt
CreateSupplierPartyRetailProvABCSImpl
CreateSupplierPartyRetailProvABCSImplExt
ProcessGLAccountValidationPeopleSoftProvABCSImpl
ProcessGLAccountValidationPeopleSoftProvABCSImplExt
ProcessGLAccountValidationRetailReqABCSImpl
ProcessGLAccountValidationRetailReqABCSImplExt
SyncCurrencyExchangeListPeopleSoftReqABCSImpl
SyncCurrencyExchangeListPeopleSoftReqABCSImplExt
SyncCurrencyExchangeListRetailProvABCSImpl
SyncCurrencyExchangeListRetailProvABCSImplExt
SyncPaymentTermListPeopleSoftReqABCSImpl
SyncPaymentTermListPeopleSoftReqABCSImplExt
SyncPaymentTermListRetailProvABCSImpl
SyncPaymentTermListRetailProvABCSImplExt
SyncSupplierPartyListPeopleSoftReqABCSImpl
SyncSupplierPartyListPeopleSoftReqABCSImplExt
SyncSupplierPartyListRetailProvABCSImpl
SyncSupplierPartyListRetailProvABCSImplExt
UpdatePaymentTermPeopleSoftReqABCSImpl
UpdatePaymentTermPeopleSoftReqABCSImplExt
UpdatePaymentTermRetailProvABCSImpl
UpdatePaymentTermRetailProvABCSImplExt
UpdateSupplierPartyPeopleSoftReqABCSImpl
UpdateSupplierPartyPeopleSoftReqABCSImplExt
UpdateSupplierPartyRetailProvABCSImpl
UpdateSupplierPartyRetailProvABCSImplExt
All SOA composites are protected by Global Policies provided by Foundation Pack as defined in the Security section of the Developer Guide. Additionally individual services for this PIP have locally attached security policies.
To validate locally attached security policies:
Log in to Oracle Enterprise Manager Fusion Middleware Control.
Navigate to WebLogic Domain, soa_domain, Web Services, Policies.
Verify Service Policy attachment.
Find the service policy in the list of policies.
Click the number in Attachment Count column.
This opens Usage Analysis screen.
Change the Subject Type list box to SOA Service.
Validate that all the composites are listed with local attachment to this service policy.
Verify Client Policy attachment
Navigate back to Policies screen and find the client policy
Click the number in Attachment Count column.
This opens Usage Analysis screen.
Change the Subject Type list box to SOA Reference
.
Validate that all the composites are listed with local attachment to this client policy and attached to the correct references.
Table 29-12 Service Policy Attachments for Financials Ops Control: Oracle Retail - PSFT PIP
Composite | Service Policy |
---|---|
ProcessGLAccountValidationRetailReqABCSImpl |
oracle/no_authentication_service_policy |
Table 29-13 No Authentication Client Policy Attachments for Financials Ops Control: Oracle Retail - PSFT PIP
Composite | Reference | Client Policy |
---|---|---|
ProcessGLAccountValidationPeopleSoftProvABCSImpl |
GL_CHARTFIELD |
oracle/no_authentication_client_policy |
CreatePaymentTermRetailProvABCSImpl |
PayTermService |
oracle/no_authentication_client_policy |
UpdatePaymentTermRetailProvABCSImpl |
PayTermService |
oracle/no_authentication_client_policy |
SyncPaymentTermListRetailProvABCSImpl |
PayTermService |
oracle/no_authentication_client_policy |
CreateSupplierPartyRetailProvABCSImpl |
SupplierService |
oracle/no_authentication_client_policy |
UpdateSupplierPartyRetailProvABCSImpl |
SupplierService |
oracle/no_authentication_client_policy |
SyncSupplierPartyListRetailProvABCSImpl |
SupplierService |
oracle/no_authentication_client_policy |
For more information about security validation, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack "Working with Security."
Verify the following connections are accurate in the Physical Architecture tab.
Launch ODI Topology Manager and navigate to Physical Architecture tab.
Expand XML node and double click AIA Configuration PropertiesDS.
Click JDBC tab and check for the connection <AIAHome>/aia_instances/<AIAInstance Name>/AIAMetaData/config/AIAConfigurationProperties.xml
Similarly find the following data servers based on the technology and artifact name. The first row in the table is used as an example.
Artifact imported | Connection | Technology |
---|---|---|
CONN_AIAConfigurationPropertiesDS.xml |
<AIAHome>/aia_instances/<AIAInstance Name>/AIAMetaData/config/AIAConfigurationProperties.xml |
XML |
CONN_AIASCHEMADS.xml |
AIA database connection |
Oracle |
CONN_BusinessUnitGLDS.xml |
Path to exported DVM BUSINESS_UNIT.xml |
XML |
CONN_CurrencyCodeDS.xml |
Path to exported DVM CURRENCY_CODE.xml |
XML |
CONN_ExchangeRateTypeDS.xml |
Path to exported DVM CURRENCYEXCHANGE_CONVERSIONTYPECODE.xml |
XML |
CONN_ORACLERETAILDS.xml |
Oracle Retail database connection |
Oracle |
CONN_PEOPLESOFTDS.xml ** |
PeopleSoft database connection |
Oracle |
CONN_PSFT_DB2_DS ** |
PeopleSoft database connection |
IBM DB2 UDB |
Note:
If your data server connects to an Oracle database, the Schema and User name must be capitalized.
Verify the context in the Contexts tab.
If PeopleSoft system is under an Oracle database, the name of the artifact imported is RETL_TO_PSFT.xml. If the PeopleSoft system is under an IBM DB2 database, then the context imported is CONT_RETL_TO_PSFT_DB2.xml.
Launch ODI Topology Manager and navigate to Contexts tab.
Double click RETL_TO_PSFT and navigate to Schema tab.
Table 29-15 describes the imported artifacts:
Table 29-15 Imported Artifacts
Artifact imported | Description |
---|---|
CONT_RETL_TO_PSFT.xml Or CONT_RETL_TO_PSFT_DB2.xml |
Holds the correlation between logical schemas and physical ones. Verify the following schemas associations are set up. You may see more schemas than the ones here. The PIP processes ignore these additional schemas. AIAConfigSchema BusinessUnitGL Currency ESB_XREF Exchange Rate PSFT_DB2_LogicalSchema PeopleSoft Retail |
Note:
If PeopleSoft system is connected to an Oracle database, associate the Logical schema PeopleSoft with Physical schema. If it is under IBM DB2, then associate PSFT_DB2_Logial Schema to a Physical schema.
Verify the following Logical Data Servers are imported in the Logical Architecture tab.
Launch ODI Topology Manager and navigate to Logical Architecture tab.
Expand XML node and double click AIA Config Schema.
Click Definition tab check whether the RETL_TO_PSFT context has AIA Configuration properties DS physical schema associated.
Similarly find the following logical data servers based on the technology and artifact name. The first row in Table 29-16 is used as an example.
Table 29-16 Logical Data Servers
Artifact imported | Description | Technology |
---|---|---|
LSC_AIAConfigSchema.xml |
<AIA_HOME>/config/ AIAConfigurationProperties.xml |
XML |
LSC_BusinessUnitGL.xml |
Exported DVM BUSINESS_UNIT.xml |
XML |
LSC_Currency.xml |
Exported DVM CURRENCY_CODE.xml |
XML |
LSC_ESB_XREF.xml |
AIA database connection |
Oracle |
LSC_ExchangeRate.xml |
Exported DVM CURRENCYEXCHANGE_CONVERSIONTYPECODE.xml |
XML |
LSC_Retail.xml |
Oracle Retail database |
Oracle |
LSC_Peoplesoft.xml |
PeopleSoft database for Oracle database |
Oracle |
LSC_PSFT_DB2_LogicalSchema.xml |
PeopleSoft database for IBM DB2 database |
IBM DB2 UDB |
Launch ODI Designer and verify the following models are imported in the Models tab.
Oracle Retail To PeopleSoft
RMS To PeopleSoft Accounting Entry
ReIM To PSFT Invoice
ReIM To PeopleSoft Accounting Entry
Launch ODI Designer and verify the following projects are imported in the Projects tab.
RMS To PSFT Acct Entry Project
ReIM To PSFT Acct Entry Project
ReIM To PeopleSoft Invoice Project
Verify the path to the AIAConfigurationProperties.xml is correctly set up for RMS to PSFT AcctEntry project.
Expand RMS to PSFT AcctEntry and Procedures.
Double-click the Load AIA Configuration Properties XML procedure.
Double-click the command LoadAIAConfigXML in the Details tab.
Under Definition tab, click Command on Source sub tab.
Verify the path to AIAConfigurationProperties.xml is accurate.
Using the same procedure verify the path for the following Exported DVMs:
Load Business Unit GL DVM XML
Load Currency Code DVM XML
Verify the path to the AIAConfigurationProperties.xml is correctly set up for ReIM To PSFT Acct Entry project.
Verify the path to the Exported DVMs:
Load Business Unit GL DVM XML
Load Currency Code DVM XML
Verify the path to the AIAConfigurationProperties.xml is correctly set up for ReIM To PeopleSoft Invoice project
Verify the path to the Exported DVMs:
Load Business Unit GL DVM XML
Load Currency Code DVM XML
Verify the WSDL URL for ErrorNotification step name is accurate for AIAAsyncErrorHandlingBPELProcess in the Load RMS To PSFT Acct Entry Package:
Launch ODI Designer.
Go to Projects tab.
Double click Load RMS To PSFT Acct Entry Package.
Select the Diagram tab.
Click the Error Notification icon.
In the Properties frame under General tab verify the WSDL URL user and password are accurate
Verify the WSDL URL for ErrorNotification step name is accurate for AIAAsyncErrorHandlingBPELProcess in the Load ReIM to PSFT AcctEntry PKG
Verify the WSDL URL for OdiInvokeWebService 5-step name is accurate for AIAAsyncErrorHandlingBPELProcess in the Load RETL Invoices To PSFT Pkg.
When deploying the Financials Ops Control: Oracle Retail - PSFT PIP, you might encounter the following errors:
Failed to execute: Create user xxxxx identified by yyyyy
Unique Constraint Violation
AIA Pre-Built Integrations Installer displays this error message in the log file if the install script attempts to create a database user name for an existing database user name. You can ignore this message and continue with the install process.
The AIA Pre-Built Integrations Installer displays the following message when it finds an identical database user name:
Example 29-3 Identical Database User Name Message
ODIInstall_CreateDBSchemaWorkRep: [echo] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [echo] Creating ODI Work Repository DB User: xxxxx [sql] Executing commands [sql] Failed to execute: create user xxxxx identified by yyyyy [sql] java.sql.SQLException: ORA-01920: user name 'xxxxx' conflicts with another user or role name [sql] 1 of 2 SQL statements executed successfully [echo] Done creating DB User for ODI Work Repository: xxxxx [echo] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Note:
xxxxx refers to the database user name provided for ODI Work Repository and yyyyy is the password.
AIA Pre-Built Integrations Installer displays this error message in the log file if the ODI data source xxxxx exists in the ODI master repository. The ODI data source is defined in Topology in the Physical Architecture tab. This error occurs when the Financials Ops Control: Oracle Retail - PSFT PIP is reinstalled.
The AIA Pre-Built Integrations Installer displays the following message when it finds an identical ODI data source:
Example 29-4 Identical ODI Data Source Message
[echo] - Importing CONN_xxxxx.xml [exec] OracleDI: Starting Command : OdiImportObject -FILE_NAME=<AIA_HOME>/PIPS/Core/DIS/RetailToPSFTFin/ODI Master Repository/CONN_xxxxx.xml -IMPORT_MODE=SYNONYM_INSERT_UPDATE ... [exec] java.sql.SQLException: ORA-00001: unique constraint (SNPM.PK_MTXT) violated
This error does not stop the install process. The process imports the remaining ODI PIP artifacts into the ODI; however, it is important to verify the accuracy of the connections for these ODI data sources. To resolve this issue, verify that the connections and associated logical schemas in the ODI topology are accurate.
For PIP implementation, see Oracle Application Integration Architecture Oracle Financial Operations Control Integration Pack Implementation Guide for Oracle Retail Merchandise Operations Management and PeopleSoft Enterprise Financials.
To undeploy the PIP from Fusion Middleware Server:
Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh
for Linux based systems and aiaenv.bat
for Microsoft Windows to configure the environment.
Run the command for your platform.
Table 29-17 Undeployment Command for the Financials Ops Control: Oracle Retail - PeopleSoft PIP
Platform | Undeployment Command |
---|---|
Linux Solaris SPARC IBM AIX Based Systems. HP-UX |
ant Uninstall -f <AIA_HOME>/Infrastructure/Install/AID/AIAInstallDriver.xml -DPropertiesFile=<AIA_HOME>/aia_instances/<AIA_Instance_name>/config/AIAInstallProperties.xml -DDeploymentPlan=<AIA_HOME>/pips/OracleRetailToPeopleSoftFinancials/DeploymentPlans/OracleRetailToPeopleSoftFinancialsUndeployDP.xml -l <AIA_HOME>/pips/OracleRetailToPeopleSoftFinancials/DeploymentPlans/OracleRetailToPeopleSoftFinancialsUndeployDP.log |
Microsoft Windows |
ant Uninstall -f <AIA_HOME>\Infrastructure\Install\AID\AIAInstallDriver.xml -DPropertiesFile=<AIA_HOME>\aia_instances\<AIA_Instance_name>\config\AIAInstallProperties.xml -DDeploymentPlan=<AIA_HOME>\pips\OracleRetailToPeopleSoftFinancials\DeploymentPlans\OracleRetailToPeopleSoftFinancialsUndeployDP.xml -l <AIA_HOME>\pips\OracleRetailToPeopleSoftFinancials\DeploymentPlans\OracleRetailToPeopleSoftFinancialsUndeployDP.log |
Restart the SOA server.
Uninstall the PIP following the instructions in Chapter 37, "Uninstalling Oracle AIA".